Linux 通过rpm包安装mysql
5.7版本:rpm包方法安装(mysql-5.7.19&CentOS7.2)
(1)停止防火墙和修改selinux
# systemctl stop firewalld
# vi /etc/selinux//config
SELINUX=disabled
(2)安装需要的软件包和卸载mariadb-libs
# yum install -y perl-Data-Dumper perl perl-devel perl-JSON
# rpm -e mariadb-libs-1:5.5.44-2.el7.centos.x86_64 --nodeps
(3)安装rpm包(5.7版本的需要安装下面的包,而且需要安装找个顺序)
# rpm -ivh mysql-community-common-5.7.19-1.el7.x86_64.rpm
# rpm -ivh mysql-community-libs-5.7.19-1.el7.x86_64.rpm
# rpm -ivh mysql-community-client-5.7.19-1.el7.x86_64.rpm
# rpm -ivh mysql-community-server-5.7.19-1.el7.x86_64.rpm
# rpm -ivh mysql-community-devel-5.7.19-1.el7.x86_64.rpm
(4)启动Mysql服务
# systemctl start mysqld
(5)连接mysql
# mysql -u root -p
然后需要输入密码,安装后自动设置了一个随机密码,查看密码:
# vi /var/log/mysqld.log
root@localhost: Vrik>y%s_9i/ #如这里的随机密码
第一次登陆需要修改密码
mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY '1qaz@WSX';
注:以前的 password()函数将会被抛弃,官方建议使用下面的命令来修改密码。
查看数据库
mysql> show databases;