1、如果不想每次都输入mysql –uroot –p登录
Vim /etc/my.cnf
【问题】修改完看不到表啦,只有两个表
以前也碰到过类似问题,以为不是以root身份登录的,所以想到跳过授权表修改root密码
linux忘记mysql密码处理方法,需要的朋友可以参考下。
linux忘记mysql密码处理方法:
# /etc/init.d/mysql stop
# mysqld_safe --user=mysql --skip-grant-tables --skip-networking &
# mysql -u root mysql
mysql> update user set password=password('newpassword') where user='root';
mysql> flush privileges;
mysql> quit
# /etc/init.d/mysql restart
# mysql -uroot -p
enter password: <输入新设的密码newpassword>
mysql>
可是还是不行
【问题原因以及解决方法】:、
跳过授权表是对的,真正原因是root读授权表时,会读里面的相关权限,而我开始自己手动创建的root用户,(把原来默认的都删除了),导致所有权限创建时默认都为no。
mysql> select User, Host, Password from mysql.user;
+------+-----------+-------------------------------------------+
| User | Host | Password |
+------+-----------+-------------------------------------------+
| root | 127.0.0.1 | *E6CC90B878B948C35E92B003C792C46C58C4AF40 |
| root | ::1 | *E6CC90B878B948C35E92B003C792C46C58C4AF40 |
| root | % | *E6CC90B878B948C35E92B003C792C46C58C4AF40 |
| app | gs_app_% | *5BCB3E6AC345B435C7C2E6B7949A04CE6F6563D3 |
+------+-----------+-------------------------------------------+
+------+-----------+-------------------------------------------+
| User | Host | Password |
+------+-----------+-------------------------------------------+
| root | 127.0.0.1 | *E6CC90B878B948C35E92B003C792C46C58C4AF40 |
| root | ::1 | *E6CC90B878B948C35E92B003C792C46C58C4AF40 |
| root | % | *E6CC90B878B948C35E92B003C792C46C58C4AF40 |
| app | gs_app_% | *5BCB3E6AC345B435C7C2E6B7949A04CE6F6563D3 |
+------+-----------+-------------------------------------------+
查看这个root用户的所有权限都存在,知识Host不对,改一下这个的Host为%,意思是让所有通过root登录的用户所有权限都有
*************************** 2. row ***************************
Host: ::1
User: root
Password: *E6CC90B878B948C35E92B003C792C46C58C4AF40
Select_priv: Y
Insert_priv: Y
Update_priv: Y
Delete_priv: Y
Create_priv: Y
Drop_priv: Y
Reload_priv: Y
Shutdown_priv: Y
Process_priv: Y
File_priv: Y
Grant_priv: Y
References_priv: Y
Index_priv: Y
Alter_priv: Y
Show_db_priv: Y
Super_priv: Y
Create_tmp_table_priv: Y
Lock_tables_priv: Y
Execute_priv: Y
Repl_slave_priv: Y
Repl_client_priv: Y
Create_view_priv: Y
Show_view_priv: Y
Create_routine_priv: Y
Alter_routine_priv: Y
Create_user_priv: Y
Event_priv: Y
Trigger_priv: Y
Create_tablespace_priv: Y
ssl_type:
ssl_cipher:
x509_issuer:
x509_subject:
max_questions: 0
max_updates: 0
max_connections: 0
max_user_connections: 0
plugin:
authentication_string:
问题解决!
- [root@sunshine zstest]# service mysql restart
- Shutting down MySQL.. [ OK ]
- Starting MySQL.... [ OK ]
- [root@sunshine zstest]# mysql
- ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
- [root@sunshine zstest]# mysql -uroot -p
- Enter password:
- Welcome to the MySQL monitor. Commands end with ; or \g.
- Your MySQL connection id is 2
- Server version: 5.5.19-log MySQL Community Server (GPL)
- Copyright (c) 2000, 2011, 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> show databases;
- +--------------------+
- | Database |
- +--------------------+
- | information_schema |
- | mysql |
- | performance_schema |
- | test |
- | zstest |
- +--------------------+
- 5 rows in set (0.02 sec)
转载于:https://blog.51cto.com/saadiya/791593