centos安装mysql8
- 下载安装包。
- 将下载的合集包上传到服务器并解压。
- 依次安装如下安装包
rpm -ivh mysql-community-common-
rpm -ivh mysql-community-libs-
rpm -ivh mysql-community-client-
rpm -ivh mysql-community-server-
- 查看mysql服务状态 systemctl status mysqld.service
- 启动mysql服务 systemctl start mysqld.service
- 获取随机生成的密码 grep 'temporary password' /var/log/mysqld.log 如果无输出用 vi /var/log/mysqld.log 打开文件 查找temporary password
- 使用mysql -u root -p 登录mysql 粘贴log中的mysql密码登录
第一次登录操作前需要修改密码 否则会提示 You must reset your password using ALTER USER statement before executing this statement 执行下面的命令
alter user 'root'@'localhost' identified by '你的密码'; (密码需同时包含数字大小写字母以及特殊字符 示例 g%xfEHg44ZpNi8)
8.设置远程可以连接的命令:
use mysql;
update user set host = ‘%’ where user = ‘root’;
flush privileges;