安装:
wget http://dev.mysql.com/get/mysql57-community-release-el7-10.noarch.rpm
yum -y install mysql57-community-release-el7-10.noarch.rpm
yum -y install mysql-community-server
启动:
service mysqld start 或 systemctl restart mysqld.service
查看默认密码:
grep ‘password’ /var/log/mysqld.log
登陆:
mysql -uroot -p密码
如果没有默认密码可以如下修改密码:
1.修改MySQL的登录设置:
vim /etc/my.cnf 在[mysqld]的段中加上一句:skip-grant-tables
2.重新启动mysql:
service mysqld restart
3.登录并修改MySQL的root密码
use mysql;
#修改密码安全策略
set global validate_password_policy=0;
update user set authentication_string = password (‘新密码’) where user = ‘root’; 或者 ALTER USER ‘root’@’localhost’ IDENTIFIED BY ‘新密码’;
授予远程管理权限:GRANT ALL PRIVILEGES ON *.* TO ‘root’@’%’ IDENTIFIED BY ‘密码’;
flush privileges;
\q 或 exit 退出
4.将MySQL的登录设置修改回来
vim /etc/my.cnf 将刚才在[mysqld]的段中加上的skip-grant-tables注释,保存并且退出vim
5.重新启动mysql
service mysqld restart
开启mysql端口服务:
iptables -I INPUT -p tcp –dport 3306 -j ACCEPTs
service network restart