1、解压tar -xf
2、yum -y install mysql-community-*
3、修改存储路径
1) 复制mysql的存储文件到我们的路(/home/mysql/)
cp -R /var/lib/mysql /home/mysql
现在我们的mysql的存储路径就是/home/mysql/mysql
2) 更改存储目录的用户(为了service启动)
chown -R mysql:mysql /home/mysq/mysql
3.修改/etc/my.cnf
vi /etc/my.cnf
[mysqld]
socket=/home/mysql/mysql/mysql.sock
[client]
socket=/home/mysql/mysql/mysql.sock
这里客户端必须也指定,不然连不上mysql的客户端,因为其socket路径还是原路径
4.修改/etc/init.d/mysql
修改 datadir=/home/mysql/mysql
5.修改/usr/bin/mysqld_safe
修改DATADIR=/home/mysql/mysql
6.修改linux的selinux(Centos7)
打开/etc/selinux/config,把SELINUX=enforcing改为SELINUX=disabled
这一段转自https://blog.csdn.net/qq_22271479/article/details/81229721
4、第一次登陆
忘记初始密码的话使用:grep "temporary password" /var/log/mysqld.log
红框就是初始密码
5、修改密码
ALTER USER "root"@"localhost" IDENTIFIED BY "密码,需要大小写数字都有";
我反正大小写数字特殊字符都放上了才成功要不然一直报:ERROR 1819 (HY000): Your password does not satisfy the current policy requirements
6、navicat连接
编辑my.cnf文件vim /etc/my.cnf
在[mysqld]下[client]上面添加:default_authentication_plugin=mysql_native_password
在服务器登陆mysql创建用户并授权
CREATE USER 'xxx'@'%' IDENTIFIED BY 'xxx';
GRANT ALL PRIVILEGES ON *.* TO 'xxx'@'%' WITH GRANT OPTION;
ALTER USER 'xxx'@'%' IDENTIFIED WITH mysql_native_password BY 'xxx';
flush privileges;