CentOS7 yum安装mysql

1. 官网(https://dev.mysql.com/downloads/repo/yum/)下载mysql的repo源

# wget https://repo.mysql.com//mysql80-community-release-el7-1.noarch.rpm

 

2. 安装mysql-community-release-el7-5.noarch.rpm包

# rpm -ivh mysql80-community-release-el7-1.noarch.rpm

 

3. 安装mysql

# yum install mysql-server

 

4. 重置密码

# chown -R openscanner:openscanner /var/lib/mysql

# systemctl start mysqld.service

# mysql -u root

mysql >use mysql;

mysql >update user set password=password('123456') where user='root';

mysql >exit;

 

5. 更改权限实现远程连接MYSQL数据库

# mysql -h localhost -uroot -p

Enter password: ******

mysql>use mysql;

mysql>select host, user, password from user;

mysql>Grant all privileges on *.* to 'root'@'%' identified by '123456' with grant option;

mysql>flush privileges;

mysql>select host, user, password from user;

 

6.删除mysql

# yum remove mysql-server

 

ps: 其它数据库操作 如 "新建数据库"、"执行sql文件"

参见  https://blog.csdn.net/jiekou0376/article/details/86736643