话说我已经暗恋MySQL许久,终于在今天勇敢地向她表白,敲出了那句mysql -u -p,说了声:我爱你…
谁知:
[root@mysql3 ~]# mysql -uroot -psam123
Warning: Using a password on the command line interface can be insecure.
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
想说爱你不容易啊。MySQL拒绝了我,并说:你是个好人。密码错了?美女先把好人卡收回去,我再仔细想想。
没办法,想不起来了。使出skip-grant-tables大法吧,修改my.cnf,重启实例,手起码落,英俊潇洒,我想,MySQL一定已经迷上了我。
什么情况,看个究竟吧。
[root@mysql3 ~]# mysql
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 1
Server version: 5.6.41-log MySQL Community Server (GPL)
Copyright (c) 2000, 2018, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql> select user,host,password from mysql.user;
+------+-----------+----------+
| user | host | password |
+------+-----------+----------+
| root | % | sam123 |
| root | localhost | sam123 |
| root | 127.0.0.1 | sam123 |
| root | ::1 | sam123 |
+------+-----------+----------