linux下载mysql修改密码
时间: 2023-12-05 14:40:51 浏览: 27
以下是Linux下载MySQL并修改密码的步骤:
1. 下载MySQL安装包,可以从MySQL官网下载:https://dev.mysql.com/downloads/mysql/
2. 解压安装包并安装MySQL:
```shell
# 解压安装包
tar -zxvf mysql-VERSION.tar.gz
cd mysql-VERSION
# 安装MySQL
cmake .
make
sudo make install
```
3. 启动MySQL服务:
```shell
sudo /usr/local/mysql/support-files/mysql.server start
```
4. 登录MySQL:
```shell
mysql -u root -p
```
5. 修改密码:
```shell
# 若已知密码,需要修改密码
SET PASSWORD FOR 'root'@'localhost' = PASSWORD('new_password');
# 若忘记密码,可以通过以下步骤重置密码
# 停止MySQL服务
sudo /usr/local/mysql/support-files/mysql.server stop
# 以跳过权限验证的方式启动MySQL服务
sudo /usr/local/mysql/bin/mysqld_safe --skip-grant-tables &
# 以root用户登录MySQL
mysql -u root
# 修改密码
use mysql;
update user set authentication_string=password('new_password') where user='root'; flush privileges;
exit;
# 重启MySQL服务
sudo /usr/local/mysql/support-files/mysql.server restart
```