Linux 安装mysql8 修改lower_case_table_names=1的方法
linux-dash
A beautiful web dashboard for Linux
项目地址:https://gitcode.com/gh_mirrors/li/linux-dash

·
对于已经有数据的数据库
- 备份原有的数据库sql文件
- 卸载原有的数据库
查看依赖项
dpkg --list|grep mysql
卸载(将所有依赖项通过以下命令删除)
sudo apt-get remove mysql-common
sudo apt-get autoremove --purge mysql-server
sudo apt-get autoremove --purge mysql-apt-config
-
重新安装mysql
-
从官网下载对应的安装包.deb
-
sudo dpkg -i mysql-apt-config_0.8.10-1_all.deb
-
-
sudo apt-get upgrade
在安装前把my.cnf下面的修改以下内容
[mysqld]
lower_case_table_names = 1
安装mysql
sudo apt install mysql-server
设置密码
选择Use Strong Password Encryption (RECOMMENDED)
systemctl start mysql
mysql8 修改root远程连接权限
CREATE USER ‘root’@’%’ IDENTIFIED BY ‘Hadoop3!’;
grant all privileges on . to ‘root’@’%’;
alter user ‘root’@’%’ identified with mysql_native_password by ‘Hadoop3!’;
flush privileges;




A beautiful web dashboard for Linux
最近提交(Master分支:5 个月前 )
186a802e
added ecosystem file for PM2 4 年前
5def40a3
Add host customization support for the NodeJS version 4 年前
更多推荐
所有评论(0)