1.下载安装mysql
- wget http://repo.mysql.com/mysql-community-release-el7-5.noarch.rpm
- yum -y install mysql-community-release-el7-5.noarch.rpm
- yum -y install mysql-community-server
2.配置mysql登陆账号密码
- systemctl start mysqld.service 启动mysql
- 查看mysql 默认初始密码 grep "password" /var/log/mysqld.log
- 登录数据库 mysql -uroot -p 回车输入密码
- 设置密码复杂度
set
global
validate_password_policy=0; //非必须
设置密码 ALTER
USER
'root'
@
'localhost'
IDENTIFIED
BY
'user password'
;//若没有进行步骤4则需要按照mysql密码校验规则设置密码
- 设置远程登陆连接 update user set host='%' where user='root' and host='localhost';
- 刷新权限 flush privileges;
- 设置阿里云安全组 允许端口3306被访问
3.忘记root密码 怎么修改
- 设置mysql跳过密码验证 vi /etc/my.cnf 在[mysqld]后加一行代码:skip-grant-tables 保存退出
- 重启mysql service mysqld restart
- 登录mysql mysql
- 设置新密码 use mysql; alter user 'root'@'localhost' identified by 'youpassword'; 或者
update user set authentication_string=password('123') where user='root'; //5.7
- 设置mysql密码验证 vi /etc/my.cnf 去掉skip-grant-tables 保存退出
- 重启mysql service mysqld restart