rpm方式安装mysql

2023年6月16日测试，本篇教程已经无法使用，请使用https://www.cnblogs.com/q202105271618/p/16335429.html 来安装mysql 5.6.17

wget http://repo.mysql.com/mysql-community-release-el7-5.noarch.rpm
rpm -ivh mysql-community-release-el7-5.noarch.rpm
yum update
yum install mysql-server
权限设置
chown -R mysql:mysql /var/lib/mysql/
初始化 MySQ
mysqld --initialize
启动 MySQL
systemctl start mysqld
重启mysql
systemctl restart mysqld
查看 MySQL 运行状态
systemctl status mysqld
mysqladmin -u root password "sdfhjk1992";

mysql -uroot -p密码
查看所有用户
select host,user,password from mysql.user;
创建dev的用户，只能本地访问
CREATE USER 'dev'@'127.0.0.1' IDENTIFIED BY 'sdfhjk1992';
将所有权限都给dev
GRANT ALL PRIVILEGES ON *.* TO 'dev'@'127.0.0.1';
刷新权限
flush privileges;

　如果需要修改mysql端口号和mysql数据库存储位置，可以查找my.cnf文件，修改my.cnf即可

创建dev用户允许远程访问
CREATE USER 'dev'@'%' IDENTIFIED BY 'iopbnm1992';
只允许dev用户可以访问test数据库
GRANT ALL PRIVILEGES ON test.* TO 'dev'@'%';