yum安装最新版mysql步骤和命令

来源:互联网 发布:ios虚拟定位软件 编辑:程序博客网 时间:2024/05/23 05:09

1首先在https://dev.mysql.com/downloads/repo/yum/找到对应的版本,并复制下载链接

2下载rpm:wget https://repo.mysql.com//mysql57-community-release-el7-11.noarch.rpm

3下载完成之后安装: yum localinstall mysql57-community-release-el7-11.noarch.rpm

4查看可安装的mysql版本:yum repolist all |grep mysql 或者yum repolist enabled

5安装mysql:yum install mysql-community-server

6查看安装状态: rpm -qi mysql-community-server.x86_64

7启动服务:sudo service mysqld start

8查看初始密码:sudogrep'temporary password' /var/log/mysqld.log 显示为:  A temporary password is generated for root@localhost: fpi!P!rpj1=I

9根据日志中的显示的初始密码登陆:mysql-u root-p fpi!P!rpj1=I

10更改密码: ALTER USER 'root'@'localhost' IDENTIFIED BY 'password';密码要求:大小写特殊字符

11允许远程链接:GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'mypassword' WITH GRANT OPTION;


原创粉丝点击