下载与安装
yum search mysql
wget https://dev.mysql.com/get/mysql57-community-release-el7-11.noarch.rpm
yum localinstall -y mysql57-community-release-el7-11.noarch.rpm
启动
systemctl start mysqld.service
查看默认密码并登录
cat /var/log/mysqld.log |grep password
mysql -uroot -p密码
修改密码
set password = password('password');
查看用户连接权限
use mysql;
show tables;
select * from user \G;
(\G 格式化显示)
select host, user from user \G;
修改root用户权限,允许远程访问:
update user set host="%" where user='root';
更新权限配置:
flush privileges;