MySQL

Linux安装

1. yum repolist all | grep mysql
2. yum install yum-utils
3. yum-config-manager --disable mysql80-community
4. yum-config-manager --enable mysql57-community
5. 验证版本：/etc/yum.repos.d/mysql-community.repo
6. yum repolist enabled | grep mysql
7. yum install mysql-community-server
8. systemctl start mysqld.service (centos7以下旧版本：service mysqld start)
9. 查看:systemctl status mysqld.service (service mysqld status)
10. sudo grep 'temporary password' /var/log/mysqld.log
11. mysql -uroot -p
12. ALTER USER 'root'@'localhost' IDENTIFIED BY '123456';
13. SHOW VARIABLES LIKE 'validate_password%';

注：更新请看：https://dev.mysql.com/doc/mysql-yum-repo-quick-guide/en/

添加用户

create user 'dev'@'%' identified by 'dev@123456';
drop user 'dev'@'%';

set password for 'dev'@'%' = '123456';
alert user 'dev'@'%' identified by '123456';

grant all privileges on *.* to 'dev'@'%'  ( with grant option );
revoke all on *.* from 'dev'@'%';   （注意撤销和授权对应）

Linux修改端口

vim /etc/my.cnf
=> port=3506

systemctl restart mysqld