3.上传至服务器,指定目录然后解压:
tar -xvf mysql-5.7.27-1.el7.x86_64.rpm-bundle.tar
4.卸载冲突的rpm组件,如果不删除,会安装不成功。先查询,再删除:
查询命令:
rpm -qa | grep postfix
rpm -qa | grep mariadb
删除命令:
rpm -e --nodeps mariadb-libs-5.5.37-1.el7_0.x86_64
5.安装相关依赖:
yum -y install libaio
yum -y install net-tools
yum -y install perl
6.安装mysql相关组件,注意组件的顺序:
rpm -ivh mysql-community-common-5.7.27-1.el7.x86_64.rpm
rpm -ivh mysql-community-libs-5.7.27-1.el7.x86_64.rpm
rpm -ivh mysql-community-client-5.7.27-1.el7.x86_64.rpm
rpm -ivh mysql-community-server-5.7.27-1.el7.x86_64.rpm
7.启动mysql,并查看mysql状态
1 | systemctl start mysqld.service |
1 | systemctl status mysqld.service |
8.获取临时密码,MySQL5.7为root用户随机生成了一个密码:
1 | grep 'temporary password' /var/log/mysqld.log |
注:密码就是root@localhost:***,后面的星号就是临时密码
9.通过临时密码登录
1 | mysql -uroot -p |
注:使用临时密码有可能登录不上。解决方案是:
1).关闭mysql服务:
systemctl stop mysqld.service或者service mysqld stop
2)进入etc/my.cnf目录,在[mysqld]添加skip-grant-tables
3).重启mysql :
service mysqld restart或者systemctl start mysqld.service
注:修改完密码后,记得改回来。这里是无密码登录。
4).修改密码
mysql> use mysql;
mysql> update user set password=password('123456') where user='root';
mysql> flush privileges; (必要步骤,一定要刷新权限表结构)
注:如果修改密码第二句设置修改密码,不行,可以使用下面这句。update mysql.user set authentication_string=password('root_password') where user='root';
5.授权远程机器登录:
1 | GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'yourpassword' WITH GRANT OPTION; |
6.授权开机自启动:
1 | systemctl enable mysqld |
7.设置MySQL的字符集为UTF-8,令其支持中文
1 | vim /etc/my.cnf,添加如下配置: |
8.重启mysql:
1 | service mysqld restart |