CentOS7安装Mysql

1、环境准备(下载mysql包)

wget http://repo.mysql.com/mysql-community-release-el7-5.noarch.rpm

2、准备安装

sudo rpm -ivh mysql-community-release-el7-5.noarch.rpm

3、开始安装中间提示按y+回车

sudo yum install mysql-server

4、登录mysql

mysql -u root

4.1、可能报错

权限问题导致，解决办法，赋权重启mysql服务

chown root /var/lib/mysql/

service mysqld restart

5、重新进入mysql

mysql -u root

6、修改密码：

use mysql;

update user set password=password('liaowei123') where user='root';

7、重启服务

service mysqld restart

8、远程连接配置,登录mysql

GRANT ALL PRIVILEGES ON *.* TO '$username'@'%' IDENTIFIED BY '$password' WITH GRANT OPTION;

8.1、 $username：用户名，$password：密码;

9、刷新

flush privileges;