Hi community,
it seems that I have all privileges on the RDBMS while mysql.user and mysql.db shows different
information:
MySQL [mysql]> select * from user where user=‘root’ and host =‘%’\G
*************************** 1. row ***************************
Host: %
User: root
Select_priv: N
Insert_priv: N
Update_priv: N
Delete_priv: N
Create_priv: N
Drop_priv: N
Reload_priv: N
Shutdown_priv: N
Process_priv: N
File_priv: N
Grant_priv: N
References_priv: N
Index_priv: N
Alter_priv: N
Show_db_priv: N
Super_priv: N
Create_tmp_table_priv: N
Lock_tables_priv: N
Execute_priv: N
Repl_slave_priv: N
Repl_client_priv: N
Create_view_priv: N
Show_view_priv: N
Create_routine_priv: N
Alter_routine_priv: N
Create_user_priv: N
Event_priv: N
Trigger_priv: N
Create_tablespace_priv: N
ssl_type:
ssl_cipher:
x509_issuer:
x509_subject:
max_questions: 0
max_updates: 0
max_connections: 0
max_user_connections: 0
plugin: mysql_native_password
authentication_string: *(edited)
password_expired: N
password_last_changed: 2022-09-23 10:10:52
password_lifetime: NULL
account_locked: N
Create_role_priv: N
Drop_role_priv: N
Password_reuse_history: NULL
Password_reuse_time: NULL
Password_require_current: NULL
User_attributes: NULL
1 row in set (0.017 sec)
MySQL [mysql]> show processlist;
±-------±----------------±---------------------±------±--------±--------±-----------------------±-----------------+
| Id | User | Host | db | Command | Time | State | Info |
±-------±----------------±---------------------±------±--------±--------±-----------------------±-----------------+
| 5 | event_scheduler | localhost | NULL | Daemon | 1729439 | Waiting on empty queue | NULL |
| 159677 | root | 127.0.0.1:35238 | NULL | Sleep | 1 | | NULL |
| 386435 | root | 127.0.0.1:52824 | NULL | Sleep | 0 | | NULL |
| 387904 | root | (edited):3784 | NULL | Sleep | 6706 | | NULL |
| 389371 | root | 127.0.0.1:55316 | NULL | Sleep | 1 | | NULL |
| 389374 | root | (edited):51228 | mysql | Query | 0 | init | show processlist |
| 389390 | root | 127.0.0.1:60060 | NULL | Sleep | 1 | | NULL |
±-------±----------------±---------------------±------±--------±--------±-----------------------±-----------------+
7 rows in set (0.017 sec)
We are using MySQL 8.0 from google Cloud.
The output of “show processlist” shows that only ‘root’@‘%’ from mysql.user matches our source.
gcloud sql instances list
NAME DATABASE_VERSION LOCATION TIER PRIMARY_ADDRESS PRIVATE_ADDRESS STATUS
valentin MYSQL_8_0 europe-west1-d db-n1-standard-1 (ip address omitted) - RUNNABLE
Does anybody have any advice?
Thanks in advance!
Best regards,
Valentin