1.6、使用rpm -ivh mysql-community-common-8.0.15-1.el7.x86_64.rpm --nodeps --force 命令安装 common
1.7、使用如上命令依次安装libs、client、server
注意:如果安装server过程中出现如下错误
执行yum install libaio -y语句,然后再次执行安装server rpm -qa | grep mysql语句查看已经安装过的东西
1.8、执行mysqld --initialize和chown -R mysql:mysql / var/ lib/mysql语句
1.9、systemctl start mysqld启动mysql
1.10、查看初始密码cat /var/log/mysqld.log | grep password
1.11、使用初始密码登录mysql,修改初始密码ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '123456'
1.12、分别执行以下语句授权可以远程连接
use mysql; ALTER USER ‘root’@‘localhost’ IDENTIFIED WITH mysql_native_password BY '123456'; update user set host='%' where user = 'root'; flush privileges; 2、使用在线方式安装
2.1、输入rpm -Uvh http://dev.mysql.com/get/mysql-community-release-el7-5.noarch.rpm进行下载
2.2、使用yum -y install mysql-community-server命令安装mysql
2.3、启动mysqlsystemctl start mysql
2.4、创建用户并登录mysqlmysqladmin -uroot password 123456
2.5、授权远程访问
grant all privileges on *.* to 'root'@'%' identified by '123456' with grant option; flush privileges; 3、测试启动mysql服务器
[root@localhost /]# /usr/local/mysql/support-files/mysql.server start
显示如下结果,说明数据库安装并可以正常启动!
异常情况
1、如果出现如下提示信息
Starting MySQL... ERROR! The server quit without updating PID file
查看是否存在mysql和mysqld的服务,如果存在,则结束进程,再重新执行启动命令
#查询服务 ps -ef|grep mysql | grep -v grep ps -ef|grep mysqld | grep -v grep #结束进程 kill -9 PID #启动服务 /usr/local/mysql/support-files/mysql.server start
2、添加软连接,并重启mysql服务
[root@localhost /]# ln -s /usr/local/mysql/support-files/mysql.server /etc/init.d/mysql [root@localhost /]# ln -s /usr/local/mysql/bin/mysql /usr/bin/mysql [root@localhost /]# service mysql restart
3、登录mysql,修改密码(密码为步骤5生成的临时密码)
[root@localhost /]# mysql -u root -p Enter password: mysql>set password for root@localhost = password('yourpass'); 注意:输入密码时,Enter password 后面不会有任何显示,此时实际是输入成功的,输入完密码后直接回车即可。或使用:mysql -u root -p 密码 ,回车后,即可直接进入数据库
4、开放远程连接
mysql>use mysql; msyql>update user set user.Host='%' where user.User='root'; mysql>flush privileges;