438
CentOS中安装MySQL8.0
先从官网下载相应的软件包:
wget https://cdn.mysql.com//Downloads/MySQL-8.0/mysql-community-client-8.0.19-1.el7.x86_64.rpm
wget https://cdn.mysql.com//Downloads/MySQL-8.0/mysql-community-libs-8.0.19-1.el7.x86_64.rpm
wget https://cdn.mysql.com//Downloads/MySQL-8.0/mysql-community-server-8.0.19-1.el7.x86_64.rpm
安装顺序:common->libs->client->server
rpm -ivh mysql-community-common-8.0.19-1.el7.x86_64.rpm
rpm -ivh mysql-community-libs-8.0.19-1.el7.x86_64.rpm
rpm -ivh mysql-community-client-8.0.19-1.el7.x86_64.rpm
rpm -ivh mysql-community-server-8.0.19-1.el7.x86_64.rpm
注:安装libs的时候可能会出现如下错误提示:
error: Failed dependencies:
mariadb-libs is obsoleted by mysql-community-libs-8.0.19-1.el7.x86_64
说明系统安装了一个被废弃的mariadb-libs, 将之移除即可:
yum remove mysql-libs
安装好之后,需要启动它
systemctl start mysqld
登录mysql需要先获取安装时的默认密码:
cat /var/log/mysqld.log|grep "temporary password"
得到如下信息:
2020-03-29T10:14:01.368010Z 5 [Note] [MY-010454] [Server] A temporary password is generated for root@localhost: kyl<6_qxruhW
标红的即是默认的root密码
登录mysql:
mysql -uroot -p -hlocalhost
输入上面的密码登录进去,但是不允许执行任何语句,因为没有修改掉默认密码。
执行命令更新密码:
mysql>alter user root@localhost identified by 'Root123_'; //Root123_是自定义密码