centos 6 安装 mysql

1. 检查服务器是否已安装 mysql :

   yum list installed|grep mysql

2. 下载 mysql 服务端源：

   wget https://downloads.mysql.com/archives/get/p/23/file/mysql-community-server-5.7.39-1.el6.x86_64.rpm

3. 安装 mysql 服务端:

   rpm -ivh mysql-community-server-5.7.39-1.el6.x86_64.rpm --nodeps --force

   提示需要安装客户端依赖等错误：

   error: Failed dependencies: mysql-community-client(x86-64) >= 5.7.9 is needed by mysql-community-server-5.7.39-1.el6.x86_64 mysql-community-common(x86-64) = 5.7.39-1.el6 is needed by mysql-community-server-5.7.39-1.el6.x86_64
   需要加 --nodeps --force

4. 启动mysql service mysqld start

5. 下载 mysql 客户端：

   wget https://downloads.mysql.com/archives/get/p/23/file/mysql-community-client-5.7.39-1.el6.x86_64.rpm

6. 安装 mysql 客户端:

   rpm -ivh mysql-community-server-5.7.39-1.el6.x86_64.rpm

7. 查看初始密码
   grep "password" /var/log/mysqld.log

8. 登录 mysql :

   mysql -uroot -p 输入初始密码

   修改密码

   ALTER USER 'root'@'localhost' IDENTIFIED BY 'xxx';
   

   需重启生效 service mysqld restart

9. 设置可远程连接

   use mysql;
   update user set host = '%' where user ='root';
   flush privileges;