[DB]如何在linux安装mysql8.0以及常用命令

最新推荐文章于 2024-06-05 13:49:12 发布

jameskaron

最新推荐文章于 2024-06-05 13:49:12 发布

阅读量258

点赞数

分类专栏： database SQL 文章标签： rpm mysql

本文链接：https://blog.csdn.net/jameskaron/article/details/104358230

版权

database 同时被 2 个专栏收录

37 篇文章 1 订阅

订阅专栏

SQL

7 篇文章 0 订阅

订阅专栏

在官网下载rpm package

Guide: https://dev.mysql.com/doc/refman/8.0/en/linux-installation-rpm.html

- 修改配置文件:
       nano /etc/my.cnf
- 重启服务:
       systemctl restart mysqld.service
	systemctl start mysqld.service
	systemctl stop mysqld.service
- 卸载:
       1. sudo yum remove mysql mysql-server
       2. sudo mv /var/lib/mysql /var/lib/mysql_old_backup
           sudo mv /etc/mysql /etc/mysql_old_backup
- 安装:
       https://www.jianshu.com/p/a355bbf11d07
- 查看密码:
       cat /var/log/mysqld.log | grep password
- 登录: sudo mysql -uroot -p
- 修改密码: ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'new password';