1、卸载 centos7 自带 mariadb
yum remove mysql-libs
2、安装mysql-server （下载地址 https://dev.mysql.com/downloads/mysql 根据自己系统选择你想安装的版本）
移动 MySQL-5.6.42-1.el7.x86_64.rpm-bundle.tar /usr/local/src/ 并解压
yum localinstall MySQL-server-5.6.42-1.el7.x86_64.rpm
yum localinstall MySQL-devel-5.6.42-1.el7.x86_64.rpm
MySQL-client-5.6.42-1.el7.x86_64.rpm
3、查看安装
mysql --version
4、启动服务
service mysql start
5、mysql root 默认密码在 /root/.mysql_secret 文件中
6、登录修改密码
mysql> set password =password('123456');
刷新权限
mysql> flush privileges;
设置 root 远程连接
mysql>use mysql;
mysql> GRANT ALL PRIVILEGES ON *.* TO root@"%" IDENTIFIED BY "root";
mysql> flush privileges;
mysql> exit
7、设置表名不区分大小写
vim vim /usr/my.cnf
加入
lower_case_table_names=1
Comments (0)