mysql输入密码登不上

# 停止MySQL服务
sudo systemctl stop mysql

# 以跳过权限表的方式启动MySQL
sudo mysqld_safe --skip-grant-tables &

# 登录MySQL
mysql -u root

# 在MySQL命令行中重置密码
USE mysql;
UPDATE user SET authentication_string=PASSWORD('new_password') WHERE User='root';
FLUSH PRIVILEGES;
EXIT;

# 重启MySQL服务
sudo systemctl start mysql

-- 检查用户权限
SHOW GRANTS FOR 'username'@'localhost';

-- 授予登录权限
GRANT ALL PRIVILEGES ON *.* TO 'username'@'localhost' IDENTIFIED BY 'password' WITH GRANT OPTION;
FLUSH PRIVILEGES;

# 检查bind-address设置
grep bind-address /etc/mysql/my.cnf

# 修改bind-address设置
sudo nano /etc/mysql/my.cnf
# 修改bind-address为127.0.0.1或0.0.0.0
bind-address = 127.0.0.1

# 检查MySQL服务状态
sudo systemctl status mysql

# 检查防火墙设置
sudo ufw status
sudo ufw allow 3306