一、CentOS7 安装 MySQL
1、下载 8.x 的安装包
wget http://dev.mysql.com/get/mysql80-community-release-el7-3.noarch.rpm
2、解压安装包
yum install mysql80-community-release-el7-3.noarch.rpm
3、确认安装版本: 输入 yum repolist all | grep mysql 可以查看当前 安装包中分别 启用/禁用 了哪些版本的内容
输入 sudo yum install mysql-community-server 即开始安装
4、启动mysql: systemctl start mysqld
关闭mysql服务: service mysqld stop
重启:sudo service mysqld restart
查看mysql状态:systemctl status mysqld
获取mysql的临时密码:grep 'temporary password' /var/log/mysqld.log
登录mysql:(密码为上一步骤获取的临时密码)mysql -u root -p(此处不用输入密码,按下回车后会专门要你再输入密码的)
修改密码: ALTER USER 'root'@'localhost' IDENTIFIED BY '新的密码';
5、配置 MySQL 自启动:
systemctl enable mysqld
systemctl daemon-reload
修改用户root为简单密码root,且设置root可以远程登录:
1、修改my.cnf文件: vim /etc/my.cnf
在最后再加:
validate_password.check_user_name=0
validate_password.policy=0
validate_password.length=1
validate_password.number_count=0
validate_password.mixed_case_count=0
validate_password.special_char_count=0
2、重启:sudo service mysqld restart
3、先查看密码的规则:SHOW VARIABLES LIKE 'validate_password%';
4、更改密码为root:ALTER USER 'root'@'localhost' IDENTIFIED BY 'root';
5、重启:sudo service mysqld restart
6、用新密码登录mysql,验证密码
7、进入数据库:use mysql;
8、mysql> update user set host = "%" where user='root';
9、查看用户权限:select host, user, authentication_string, plugin from user;
root的host为%,表示可以进行远程连接。
10、刷新当前配置:FLUSH PRIVILEGES;
11、远程登录。
创建用户和授权:
用户创建:create user 'test'@'%' identified by 'test';
授权:grant all privileges on *.* to 'test'@'%' with grant option;
查看用户权限:select host, user, authentication_string, plugin from user;
刷新当前配置:FLUSH PRIVILEGES;