在官网(https://dev.mysql.com/downloads/mysql/)下载安装包 mysql-*.rpm-bundle.tar,使用命令 tar 解压缩,接下来按照下列顺序依次安装:
rpm -ivh mysql-community-common-5.7.24-1.el7.x86_64.rpm
rpm -ivh mysql-community-libs-5.7.24-1.el7.x86_64.rpm
rpm -ivh mysql-community-client-5.7.24-1.el7.x86_64.rpm
rpm -ivh mysql-community-server-5.7.24-1.el7.x86_64.rpm
rpm -ivh mysql-community-devel-5.7.24-1.el7.x86_64.rpm (可选)
安装之后初始化数据库
mysqld --initialize --user= mysql
初始化之后查看管理员密码
vim /var/log/mysqld.log
启动数据库
service mysqld start
登陆数据库
mysql -u root -p
查看用户及修改登陆密码,允许管理员远程登陆
select host,user,password from user;
alter user 'root' @'localhost' identified by 'your_password' ;
flush privileges;
update user set Host = '%' where user = 'root' ;
quit
配置完成后重启数据库
service mysqld restart