redhat mysql RPM安装_centos/redhat rpm方式安装mysql

1、查看linux版本

cat /etc/redhat-release

2、查看linux位数

getconf LONG_BIT

3、在官网下载对应版本

https://dev.mysql.com/downloads/mysql/

4、上传包并安装mysql

rpm -ivh mysql-community-common-5.7.14-1.el6.x86_64.rpm

rpm -ivh mysql-community-libs-5.7.14-1.el6.x86_64.rpm

rpm -ivh mysql-community-client-5.7.14-1.el6.x86_64.rpm

rpm -ivh mysql-community-server-5.7.14-1.el6.x86_64.rpm

5、数据库初始化

mysqld --initialize --user=mysql

如果报错 查看mysql.log文件的错误信息 (如果之前安装过mysql，但是没有删除mysql的data文件就会报错，次数删除文件即可 删除/var/lib/mysql文件夹)

6、查看mysql的root初始密码并root登录

cat /var/log/mysqld.log | grep "temporary password"

mysql -u root -p

7、修改root密码

SET PASSWORD FOR 'root'@'localhost' = PASSWORD('[password]');

8、创建用户

CREATE USER 'newusername'@'localhost' IDENTIFIED BY '[password]';

9、配置用户权限

GRANT ALL PRIVILEGES ON * . * TO '[newusername]'@'localhost';

FLUSH PRIVILEGES;

远程访问的地址也要另外配置权限

GRANT ALL PRIVILEGES ON * . * TO '[newusername]'@'[newip]' identified by '[password]';

FLUSH PRIVILEGES;