centos7安装mysql5.7.18.tat.gz

1,centos7安装了mariadb需要卸载

rpm -e mariadb-libs-XXXXXX.x86_64 --nodeps

2,/user/local

tar -zxvf mysql-5.7.18-linux-glibc2.5-x86_64.tar.gz -C /usr/local

ln -s mysql-5.7.18-linux-glibc2.5-x86_64 mysql

3,添加账户

groupadd mysql
useradd -r -g mysql -s /bin/false mysql

4,修改mysql文件夹权限

cd /usr/local/mysql

chown -R mysql:mysql ./

5,安装

./bin/mysqld --user=mysql --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data --initialize

    注意root账户初始密码

6,开启服务,加入系统服务

./support-files/mysql.server start

cp support-files/mysql.server /etc/init.d/mysqld

service mysqld restart

7,登陆mysql,修改root密码

利用初始密码登陆
mysql -u root -p123

修改密码
alter user 'root'@'localhost' identified by 'rootroot';

远程连接

update user set user.Host='%' where user.User='root';

flush privileges;

https://www.cnblogs.com/coderls/p/6848873.html