赞
踩
问题:DataGrip 测试链接时出现下图情况
根据字面意思,mysql的root密码错了。
解决过程
1. mysql_secure_installation
2.
要求输入当前密码,输入的是第一张图报错的密码,验证成功,继续下一步。
3.
这里询问是否更改密码,输入Y
输入的还是原来的密码
4.
询问是否移除匿名用户,输入Y。
5.
询问是否禁止root的远程连接,输入n。
6.
询问是否删除test数据库,输入n。
7.
询问是否现在重新加载权限表 这里不小心按到ctrl+C。
8.此时再测试链接,成功。(文章第一张图是别人的,所以ip不一样)
完整的INFO
- [root@master ~]# mysql_secure_installation
-
- NOTE: RUNNING ALL PARTS OF THIS SCRIPT IS RECOMMENDED FOR ALL MariaDB
- SERVERS IN PRODUCTION USE! PLEASE READ EACH STEP CAREFULLY!
-
- In order to log into MariaDB to secure it, we'll need the current
- password for the root user. If you've just installed MariaDB, and
- you haven't set the root password yet, the password will be blank,
- so you should just press enter here.
-
- Enter current password for root (enter for none):
- ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
- Enter current password for root (enter for none):
- OK, successfully used password, moving on...
-
- Setting the root password ensures that nobody can log into the MariaDB
- root user without the proper authorisation.
-
- You already have a root password set, so you can safely answer 'n'.
-
- Change the root password? [Y/n] Y
- New password:
- Re-enter new password:
- Password updated successfully!
- Reloading privilege tables..
- ... Success!
-
-
- By default, a MariaDB installation has an anonymous user, allowing anyone
- to log into MariaDB without having to have a user account created for
- them. This is intended only for testing, and to make the installation
- go a bit smoother. You should remove them before moving into a
- production environment.
-
- Remove anonymous users? [Y/n] Y
- ... Success!
-
- Normally, root should only be allowed to connect from 'localhost'. This
- ensures that someone cannot guess at the root password from the network.
-
- Disallow root login remotely? [Y/n] n
- ... skipping.
-
- By default, MariaDB comes with a database named 'test' that anyone can
- access. This is also intended only for testing, and should be removed
- before moving into a production environment.
-
- Remove test database and access to it? [Y/n] n
- ... skipping.
-
- Reloading the privilege tables will ensure that all changes made so far
- will take effect immediately.
-
- Reload privilege tables now? [Y/n] ^C
- Aborting!
-
- Cleaning up...
Copyright © 2003-2013 www.wpsshop.cn 版权所有,并保留所有权利。