Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Root account wont work in MySQL
- mysql> GRANT ALL ON *.* TO 'root'@'%'
- -> IDENTIFIED BY '[password]'
- -> WITH GRANT OPTION;
- ERROR 1045 (28000): Access denied for user 'root'@'%' (using password: YES)
- mysql>
- mysql> show grants for root
- -> ;
- +-----------------------------------------------------------------------------------------------------+
- | Grants for root@% |
- +-----------------------------------------------------------------------------------------------------+
- | GRANT USAGE ON *.* TO 'root'@'%' IDENTIFIED BY PASSWORD '*738393F115A47ACE272D98F4719B8491A2B8296F' |
- | GRANT ALL PRIVILEGES ON `sometable`.* TO 'root'@'%' WITH GRANT OPTION |
- | GRANT ALL PRIVILEGES ON `Test`.* TO 'root'@'%' WITH GRANT OPTION |
- +-----------------------------------------------------------------------------------------------------+
- 3 rows in set (0.00 sec)
- mysql> select user();
- mysql> select * from mysql.userG
- mysql> select * from mysql.userG
- *************************** 1. row ***************************
- Host: localhost
- User: root
- Password: xxxxxxxxxxxxxxx
- 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
- ssl_type:
- ssl_cipher:
- x509_issuer:
- x509_subject:
- max_questions: 0
- max_updates: 0
- max_connections: 0
- max_user_connections: 0
Add Comment
Please, Sign In to add comment