Linux MySQL 修改root密码和设置权限
如果遇到以下问题,或者使用 Navicat 连接不上Mysql(修改权限),请尝试一下操作。
Access denied for user 'root'@'localhost' (using password: YES)
修改密码
[root@localhost ~]# vim /etc/my.cnf
在[mysqld]下添加
skip-grant-tables
跳过密码登录mysql。
使用
[root@localhost ~]# mysql -u root -p
登录,然后回车,进入mysql命令行。
mysql -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 2
Server version: 5.6.43 MySQL Community Server (GPL)
Copyright (c) 2000, 2019, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or