On 9/2/25 12:58 PM, Joe wrote:
On Tue, 2 Sep 2025 08:10:28 -0500 Kent West<[email protected]> wrote:On 9/1/25 11:33 AM, Joe wrote:On Mon, 1 Sep 2025 07:04:17 -0500 Kent West<[email protected]> wrote:I'm just toying around, learning a lot, with Apache2, phpmyadmin, mariadb, SQL in general ... absolutely don't know what I'm doing. But I've gotten some basics accomplished; I've created a 'pma' user in mariadb to tinker with mariadb, and have gotten ppmyadmin to open in Firefox and show my databases, and have discovered that I can see who my users in mariadb are with a SQL command like 'SELECT user FROM mysql.user;'. I wanted to browse the navigation tree in the left-hand pane of the phpmyadmin web page, to see if I could directly see the users in the mysql.user table (understanding that "mysql.user" is a "path" to the "mysql" database, and the "user" table within that db). But the "user" table is not there. I spent considerable time last night and this morning with two AIs (Gemini, and duck.ai) trying to make this table visible (the AI's insist the table is there, but simply not visible for some reason), but nothing they suggested made the table visible in the navigation tree, although the data in that table is accessible via SQL (either through the phpmyadmin GUI, or the mariadb cli client, or the mycli client). (The AIs also insist I should not manipulate the user table directly, which is why it's hidden, but I'm not worried about manipulating that data; I just want to see the table there instead of just accepting that it's there; besides, if I hork up my mariadb/Apache2/phpmyadmin setup, nothing is lost; this is a throw-away setup for my learning.) The AIs seem to think this is Debian-specific behavior. Why can't I see this table in the navigation tree, and how do I force the system to let me see it there?The first question is: what user are you?I created a user, "pma", who has "ALL PRIVILEGES", who I am logged into in phpmyadmin. As mentioned, he can query the "user" table, and he can see it with a SQL "SHOW TABLES;" command in the SQL "Show Query box"; he just can't see it from within the phpmyadmin GUI navigation tree.OK, in my phpmyadmin tree I'm seeing 30 tables in the mysql database, including user. This still looks like privileges at the moment. When you view any table in database mysql and enter: select * from `user` in the phpmyadmin SQL box, are the privileges for root and pma identical? Are both shown with Host as localhost? The User names and password hashes should be different, but nothing else.
Interesting that you see `user` in your phpmyadmin navigation tree. Yes, as far as I can see, the two users have identical privs. |||SELECT <http://localhost/phpmyadmin/url.php?url=https://dev.mysql.com/doc/refman/8.0/en/select.html> * FROM `mysql`.`user` WHERE `User` IN <http://localhost/phpmyadmin/url.php?url=https://dev.mysql.com/doc/refman/8.0/en/comparison-operators.html%23function_in> ('root', 'pma'); |
|| Full texts <http://localhost/phpmyadmin/index.php>Host <http://localhost/phpmyadmin/index.php?route=/sql&db=mysql&table=user&sql_query=SELECT+%2A+FROM+%60mysql%60.%60user%60+WHERE+%60User%60+IN+%28%27root%27%2C+%27pma%27%29+%0AORDER+BY+%60user%60.%60Host%60+ASC+&sql_signature=b23c7fb8affd2fb93d36dc6abc3629ebeba766491fa54415bced50fafffb8a94&session_max_rows=25&is_browse_distinct=0> User <http://localhost/phpmyadmin/index.php?route=/sql&db=mysql&table=user&sql_query=SELECT+%2A+FROM+%60mysql%60.%60user%60+WHERE+%60User%60+IN+%28%27root%27%2C+%27pma%27%29+%0AORDER+BY+%60user%60.%60User%60+ASC+&sql_signature=3cd2ce814226dbb9e872f80a2139d3625b266419e6ac19bea3a92ca77812130d&session_max_rows=25&is_browse_distinct=0> Password <http://localhost/phpmyadmin/index.php?route=/sql&db=mysql&table=user&sql_query=SELECT+%2A+FROM+%60mysql%60.%60user%60+WHERE+%60User%60+IN+%28%27root%27%2C+%27pma%27%29+%0AORDER+BY+%60user%60.%60Password%60+ASC+&sql_signature=2035320f3ca41b65f54b15db8c15f5e28f58afbe68ff8b92dbfb99e9f9bf6b59&session_max_rows=25&is_browse_distinct=0> Select_priv <http://localhost/phpmyadmin/index.php?route=/sql&db=mysql&table=user&sql_query=SELECT+%2A+FROM+%60mysql%60.%60user%60+WHERE+%60User%60+IN+%28%27root%27%2C+%27pma%27%29+%0AORDER+BY+%60user%60.%60Select_priv%60+ASC+&sql_signature=66cec5e0634776373712d95b623645969e3b879a38d0ce1cc19785b82d45699d&session_max_rows=25&is_browse_distinct=0> Insert_priv <http://localhost/phpmyadmin/index.php?route=/sql&db=mysql&table=user&sql_query=SELECT+%2A+FROM+%60mysql%60.%60user%60+WHERE+%60User%60+IN+%28%27root%27%2C+%27pma%27%29+%0AORDER+BY+%60user%60.%60Insert_priv%60+ASC+&sql_signature=869ee8d659413a984b549c681616d3e94742bb628187fe01235142e3c8116851&session_max_rows=25&is_browse_distinct=0> Update_priv <http://localhost/phpmyadmin/index.php?route=/sql&db=mysql&table=user&sql_query=SELECT+%2A+FROM+%60mysql%60.%60user%60+WHERE+%60User%60+IN+%28%27root%27%2C+%27pma%27%29+%0AORDER+BY+%60user%60.%60Update_priv%60+ASC+&sql_signature=e61185331e729db1ac5342961ce8ad70a6835f95713ce31e79c06d4692e683c9&session_max_rows=25&is_browse_distinct=0> Delete_priv <http://localhost/phpmyadmin/index.php?route=/sql&db=mysql&table=user&sql_query=SELECT+%2A+FROM+%60mysql%60.%60user%60+WHERE+%60User%60+IN+%28%27root%27%2C+%27pma%27%29+%0AORDER+BY+%60user%60.%60Delete_priv%60+ASC+&sql_signature=4bd871eddd14ee20160b633fada73d211107007acf97454365a9c4318696a681&session_max_rows=25&is_browse_distinct=0> Create_priv <http://localhost/phpmyadmin/index.php?route=/sql&db=mysql&table=user&sql_query=SELECT+%2A+FROM+%60mysql%60.%60user%60+WHERE+%60User%60+IN+%28%27root%27%2C+%27pma%27%29+%0AORDER+BY+%60user%60.%60Create_priv%60+ASC+&sql_signature=4024cdf6acf55d9280bb4ba9795128e18ab9add60f26610309f12010e0fb2d14&session_max_rows=25&is_browse_distinct=0> Drop_priv <http://localhost/phpmyadmin/index.php?route=/sql&db=mysql&table=user&sql_query=SELECT+%2A+FROM+%60mysql%60.%60user%60+WHERE+%60User%60+IN+%28%27root%27%2C+%27pma%27%29+%0AORDER+BY+%60user%60.%60Drop_priv%60+ASC+&sql_signature=402724fa5a1dd47d9ce7ee4adf971d9fbccb2f6cca8d0c6fe421b42996ba3486&session_max_rows=25&is_browse_distinct=0> Reload_priv <http://localhost/phpmyadmin/index.php?route=/sql&db=mysql&table=user&sql_query=SELECT+%2A+FROM+%60mysql%60.%60user%60+WHERE+%60User%60+IN+%28%27root%27%2C+%27pma%27%29+%0AORDER+BY+%60user%60.%60Reload_priv%60+ASC+&sql_signature=fe02b657175304f958c6b4e8465c1205ececabf7932afdd75748114960df1906&session_max_rows=25&is_browse_distinct=0> Shutdown_priv <http://localhost/phpmyadmin/index.php?route=/sql&db=mysql&table=user&sql_query=SELECT+%2A+FROM+%60mysql%60.%60user%60+WHERE+%60User%60+IN+%28%27root%27%2C+%27pma%27%29+%0AORDER+BY+%60user%60.%60Shutdown_priv%60+ASC+&sql_signature=721488c72221385ed6bc0da7727dacaa725ba5ee46ebf9f283ec7c1130465c86&session_max_rows=25&is_browse_distinct=0> Process_priv <http://localhost/phpmyadmin/index.php?route=/sql&db=mysql&table=user&sql_query=SELECT+%2A+FROM+%60mysql%60.%60user%60+WHERE+%60User%60+IN+%28%27root%27%2C+%27pma%27%29+%0AORDER+BY+%60user%60.%60Process_priv%60+ASC+&sql_signature=1090726e01bdafced7eca91c52b514ee8d7f433a010f757e29c1c8fad44ed06a&session_max_rows=25&is_browse_distinct=0> File_priv <http://localhost/phpmyadmin/index.php?route=/sql&db=mysql&table=user&sql_query=SELECT+%2A+FROM+%60mysql%60.%60user%60+WHERE+%60User%60+IN+%28%27root%27%2C+%27pma%27%29+%0AORDER+BY+%60user%60.%60File_priv%60+ASC+&sql_signature=96de3cebdd13f3bff45cbb67ce26765bda1dc087ff68612f309ee1a13b51e717&session_max_rows=25&is_browse_distinct=0> Grant_priv <http://localhost/phpmyadmin/index.php?route=/sql&db=mysql&table=user&sql_query=SELECT+%2A+FROM+%60mysql%60.%60user%60+WHERE+%60User%60+IN+%28%27root%27%2C+%27pma%27%29+%0AORDER+BY+%60user%60.%60Grant_priv%60+ASC+&sql_signature=5e1f590cba165c58c7d4fe35a9c5339d3d3f52571a75e72d4ee3952099ce48f9&session_max_rows=25&is_browse_distinct=0> References_priv <http://localhost/phpmyadmin/index.php?route=/sql&db=mysql&table=user&sql_query=SELECT+%2A+FROM+%60mysql%60.%60user%60+WHERE+%60User%60+IN+%28%27root%27%2C+%27pma%27%29+%0AORDER+BY+%60user%60.%60References_priv%60+ASC+&sql_signature=ddff34f3aef09c68db1599d59f7eda965ff12ebe0f59254f44f1cf7acec32d9f&session_max_rows=25&is_browse_distinct=0> Index_priv <http://localhost/phpmyadmin/index.php?route=/sql&db=mysql&table=user&sql_query=SELECT+%2A+FROM+%60mysql%60.%60user%60+WHERE+%60User%60+IN+%28%27root%27%2C+%27pma%27%29+%0AORDER+BY+%60user%60.%60Index_priv%60+ASC+&sql_signature=74ad5508c92189d9af32d89e3b8b0aac96c6d62e79bf68fde5c876041e03514e&session_max_rows=25&is_browse_distinct=0> Alter_priv <http://localhost/phpmyadmin/index.php?route=/sql&db=mysql&table=user&sql_query=SELECT+%2A+FROM+%60mysql%60.%60user%60+WHERE+%60User%60+IN+%28%27root%27%2C+%27pma%27%29+%0AORDER+BY+%60user%60.%60Alter_priv%60+ASC+&sql_signature=e50ff9444a1b27906af381d0eabf6f09de667648df71e619573a1a023c6b483c&session_max_rows=25&is_browse_distinct=0> Show_db_priv <http://localhost/phpmyadmin/index.php?route=/sql&db=mysql&table=user&sql_query=SELECT+%2A+FROM+%60mysql%60.%60user%60+WHERE+%60User%60+IN+%28%27root%27%2C+%27pma%27%29+%0AORDER+BY+%60user%60.%60Show_db_priv%60+ASC+&sql_signature=23fb9a279a5b8ca8389e9e17a970abf7dd532efeef4cd47beac5bfc0e348acd5&session_max_rows=25&is_browse_distinct=0> Super_priv <http://localhost/phpmyadmin/index.php?route=/sql&db=mysql&table=user&sql_query=SELECT+%2A+FROM+%60mysql%60.%60user%60+WHERE+%60User%60+IN+%28%27root%27%2C+%27pma%27%29+%0AORDER+BY+%60user%60.%60Super_priv%60+ASC+&sql_signature=9c2771cef774085e725ea1105c17521b29b60c2a97cec1daef721075995ca3cb&session_max_rows=25&is_browse_distinct=0> Create_tmp_table_priv <http://localhost/phpmyadmin/index.php?route=/sql&db=mysql&table=user&sql_query=SELECT+%2A+FROM+%60mysql%60.%60user%60+WHERE+%60User%60+IN+%28%27root%27%2C+%27pma%27%29+%0AORDER+BY+%60user%60.%60Create_tmp_table_priv%60+ASC+&sql_signature=03271336af46769ebe904ebed94002df35f5d55462e920cbc010a10841330b9a&session_max_rows=25&is_browse_distinct=0> Lock_tables_priv <http://localhost/phpmyadmin/index.php?route=/sql&db=mysql&table=user&sql_query=SELECT+%2A+FROM+%60mysql%60.%60user%60+WHERE+%60User%60+IN+%28%27root%27%2C+%27pma%27%29+%0AORDER+BY+%60user%60.%60Lock_tables_priv%60+ASC+&sql_signature=6c0c380c583352b0a67f5fe4216ee3aea642f3d5a4b3d9f603da698ad4a7a160&session_max_rows=25&is_browse_distinct=0> Execute_priv <http://localhost/phpmyadmin/index.php?route=/sql&db=mysql&table=user&sql_query=SELECT+%2A+FROM+%60mysql%60.%60user%60+WHERE+%60User%60+IN+%28%27root%27%2C+%27pma%27%29+%0AORDER+BY+%60user%60.%60Execute_priv%60+ASC+&sql_signature=006ed399f00a0caac9c9567df9a02d67a335f9bf3fe0d595177b174c6d730c92&session_max_rows=25&is_browse_distinct=0> Repl_slave_priv <http://localhost/phpmyadmin/index.php?route=/sql&db=mysql&table=user&sql_query=SELECT+%2A+FROM+%60mysql%60.%60user%60+WHERE+%60User%60+IN+%28%27root%27%2C+%27pma%27%29+%0AORDER+BY+%60user%60.%60Repl_slave_priv%60+ASC+&sql_signature=985f3369719a8c1177310408bee4d4a4c7d2f157a5500a9af948aa11059d85d1&session_max_rows=25&is_browse_distinct=0> Repl_client_priv <http://localhost/phpmyadmin/index.php?route=/sql&db=mysql&table=user&sql_query=SELECT+%2A+FROM+%60mysql%60.%60user%60+WHERE+%60User%60+IN+%28%27root%27%2C+%27pma%27%29+%0AORDER+BY+%60user%60.%60Repl_client_priv%60+ASC+&sql_signature=ffdf7a4cbc60884bdf2d2c5386d1cc2503b1676b6244bae33a98a9f8fc512207&session_max_rows=25&is_browse_distinct=0> Create_view_priv <http://localhost/phpmyadmin/index.php?route=/sql&db=mysql&table=user&sql_query=SELECT+%2A+FROM+%60mysql%60.%60user%60+WHERE+%60User%60+IN+%28%27root%27%2C+%27pma%27%29+%0AORDER+BY+%60user%60.%60Create_view_priv%60+ASC+&sql_signature=3f871f161b099e8a511e91237ecbcad30a0eed7744c8eef8541933d674a0da35&session_max_rows=25&is_browse_distinct=0> Show_view_priv <http://localhost/phpmyadmin/index.php?route=/sql&db=mysql&table=user&sql_query=SELECT+%2A+FROM+%60mysql%60.%60user%60+WHERE+%60User%60+IN+%28%27root%27%2C+%27pma%27%29+%0AORDER+BY+%60user%60.%60Show_view_priv%60+ASC+&sql_signature=e2a3bc3ea6e00e4013524e14626693d965679620dad36982cc53f79517c2a16c&session_max_rows=25&is_browse_distinct=0> Create_routine_priv <http://localhost/phpmyadmin/index.php?route=/sql&db=mysql&table=user&sql_query=SELECT+%2A+FROM+%60mysql%60.%60user%60+WHERE+%60User%60+IN+%28%27root%27%2C+%27pma%27%29+%0AORDER+BY+%60user%60.%60Create_routine_priv%60+ASC+&sql_signature=c840a70bdb748ca9da02d94d9c839d46bc03f2b53ce5b60f456ee5d518863863&session_max_rows=25&is_browse_distinct=0> Alter_routine_priv <http://localhost/phpmyadmin/index.php?route=/sql&db=mysql&table=user&sql_query=SELECT+%2A+FROM+%60mysql%60.%60user%60+WHERE+%60User%60+IN+%28%27root%27%2C+%27pma%27%29+%0AORDER+BY+%60user%60.%60Alter_routine_priv%60+ASC+&sql_signature=277bf33fa038686f59e393057ffbf33119a3309f914b66256f2f5df5cb698daa&session_max_rows=25&is_browse_distinct=0> Create_user_priv <http://localhost/phpmyadmin/index.php?route=/sql&db=mysql&table=user&sql_query=SELECT+%2A+FROM+%60mysql%60.%60user%60+WHERE+%60User%60+IN+%28%27root%27%2C+%27pma%27%29+%0AORDER+BY+%60user%60.%60Create_user_priv%60+ASC+&sql_signature=225a09b8d36c9420cbbbd0d451ff9b3dc490df9345c0f88544121a9e69aea36c&session_max_rows=25&is_browse_distinct=0> Event_priv <http://localhost/phpmyadmin/index.php?route=/sql&db=mysql&table=user&sql_query=SELECT+%2A+FROM+%60mysql%60.%60user%60+WHERE+%60User%60+IN+%28%27root%27%2C+%27pma%27%29+%0AORDER+BY+%60user%60.%60Event_priv%60+ASC+&sql_signature=a4d01bc83814f67336460ab950f0270e2ac4e411f52db7c493dbdcb6c1359be0&session_max_rows=25&is_browse_distinct=0> Trigger_priv <http://localhost/phpmyadmin/index.php?route=/sql&db=mysql&table=user&sql_query=SELECT+%2A+FROM+%60mysql%60.%60user%60+WHERE+%60User%60+IN+%28%27root%27%2C+%27pma%27%29+%0AORDER+BY+%60user%60.%60Trigger_priv%60+ASC+&sql_signature=576e158f671e2fa1e27a11f6b01a974b9b518b90b346435596e5c7e47c08aa56&session_max_rows=25&is_browse_distinct=0> Create_tablespace_priv <http://localhost/phpmyadmin/index.php?route=/sql&db=mysql&table=user&sql_query=SELECT+%2A+FROM+%60mysql%60.%60user%60+WHERE+%60User%60+IN+%28%27root%27%2C+%27pma%27%29+%0AORDER+BY+%60user%60.%60Create_tablespace_priv%60+ASC+&sql_signature=b123dc676bbe1902ef21cc6744fdfc37d8a5bd18080f6c0ad8ddcd04ee482edb&session_max_rows=25&is_browse_distinct=0> Delete_history_priv <http://localhost/phpmyadmin/index.php?route=/sql&db=mysql&table=user&sql_query=SELECT+%2A+FROM+%60mysql%60.%60user%60+WHERE+%60User%60+IN+%28%27root%27%2C+%27pma%27%29+%0AORDER+BY+%60user%60.%60Delete_history_priv%60+ASC+&sql_signature=d1516436b212722e8ca581e794add0cba65ecc0368938355b253b3d187a6a9e1&session_max_rows=25&is_browse_distinct=0> ssl_type <http://localhost/phpmyadmin/index.php?route=/sql&db=mysql&table=user&sql_query=SELECT+%2A+FROM+%60mysql%60.%60user%60+WHERE+%60User%60+IN+%28%27root%27%2C+%27pma%27%29+%0AORDER+BY+%60user%60.%60ssl_type%60+ASC+&sql_signature=d21435ef4c819d5254be1c1906e7de8366bc5806126070dbab860eee76c69a2a&session_max_rows=25&is_browse_distinct=0> ssl_cipher <http://localhost/phpmyadmin/index.php?route=/sql&db=mysql&table=user&sql_query=SELECT+%2A+FROM+%60mysql%60.%60user%60+WHERE+%60User%60+IN+%28%27root%27%2C+%27pma%27%29+%0AORDER+BY+%60user%60.%60ssl_cipher%60+ASC+&sql_signature=d3783a784b1968a3b94d6f7afd28d9793c1535f0c85d844f8bbacda194dce0b3&session_max_rows=25&is_browse_distinct=0> x509_issuer <http://localhost/phpmyadmin/index.php?route=/sql&db=mysql&table=user&sql_query=SELECT+%2A+FROM+%60mysql%60.%60user%60+WHERE+%60User%60+IN+%28%27root%27%2C+%27pma%27%29+%0AORDER+BY+%60user%60.%60x509_issuer%60+ASC+&sql_signature=c9617dc6134f426b8b7950e54477011809bc91bce585e1a9b14af51c3c2d18ef&session_max_rows=25&is_browse_distinct=0> x509_subject <http://localhost/phpmyadmin/index.php?route=/sql&db=mysql&table=user&sql_query=SELECT+%2A+FROM+%60mysql%60.%60user%60+WHERE+%60User%60+IN+%28%27root%27%2C+%27pma%27%29+%0AORDER+BY+%60user%60.%60x509_subject%60+ASC+&sql_signature=dd24d8f63ef30bc11e21dfc532fe1909955d6a2ddc092154ca15401867a28262&session_max_rows=25&is_browse_distinct=0> max_questions <http://localhost/phpmyadmin/index.php?route=/sql&db=mysql&table=user&sql_query=SELECT+%2A+FROM+%60mysql%60.%60user%60+WHERE+%60User%60+IN+%28%27root%27%2C+%27pma%27%29+%0AORDER+BY+%60user%60.%60max_questions%60+ASC+&sql_signature=5f6db6c100ebf73e7f6cffa0344c4e17be8e6e14f8f572345f7cd7c5e3102657&session_max_rows=25&is_browse_distinct=0> max_updates <http://localhost/phpmyadmin/index.php?route=/sql&db=mysql&table=user&sql_query=SELECT+%2A+FROM+%60mysql%60.%60user%60+WHERE+%60User%60+IN+%28%27root%27%2C+%27pma%27%29+%0AORDER+BY+%60user%60.%60max_updates%60+ASC+&sql_signature=49acfaabf0c36c8715aa6d29d82837b00400417102bc17f9a9db9cb404376c80&session_max_rows=25&is_browse_distinct=0> max_connections <http://localhost/phpmyadmin/index.php?route=/sql&db=mysql&table=user&sql_query=SELECT+%2A+FROM+%60mysql%60.%60user%60+WHERE+%60User%60+IN+%28%27root%27%2C+%27pma%27%29+%0AORDER+BY+%60user%60.%60max_connections%60+ASC+&sql_signature=f619d23fbf1ba9c738412c0113e40d2981abd5d1d850120b820ae43aeee4938c&session_max_rows=25&is_browse_distinct=0> max_user_connections <http://localhost/phpmyadmin/index.php?route=/sql&db=mysql&table=user&sql_query=SELECT+%2A+FROM+%60mysql%60.%60user%60+WHERE+%60User%60+IN+%28%27root%27%2C+%27pma%27%29+%0AORDER+BY+%60user%60.%60max_user_connections%60+ASC+&sql_signature=6c7a77e576f32faddcd0728759b1eff5b011e5472f09b08f676d9e4bdb12adc6&session_max_rows=25&is_browse_distinct=0> plugin <http://localhost/phpmyadmin/index.php?route=/sql&db=mysql&table=user&sql_query=SELECT+%2A+FROM+%60mysql%60.%60user%60+WHERE+%60User%60+IN+%28%27root%27%2C+%27pma%27%29+%0AORDER+BY+%60user%60.%60plugin%60+ASC+&sql_signature=b284bc46efdbe33b73bac06342e87977025138c8981c4e53d30f677a67326720&session_max_rows=25&is_browse_distinct=0> authentication_string <http://localhost/phpmyadmin/index.php?route=/sql&db=mysql&table=user&sql_query=SELECT+%2A+FROM+%60mysql%60.%60user%60+WHERE+%60User%60+IN+%28%27root%27%2C+%27pma%27%29+%0AORDER+BY+%60user%60.%60authentication_string%60+ASC+&sql_signature=ea9bea15f08a5aee1f5c9d9a5d1e1cf9b4fffdda8293596bab7fa4723487ef99&session_max_rows=25&is_browse_distinct=0> password_expired <http://localhost/phpmyadmin/index.php?route=/sql&db=mysql&table=user&sql_query=SELECT+%2A+FROM+%60mysql%60.%60user%60+WHERE+%60User%60+IN+%28%27root%27%2C+%27pma%27%29+%0AORDER+BY+%60user%60.%60password_expired%60+ASC+&sql_signature=56337c6a0da7b283efdce7cdd599b0a23f8d6c0055b3175a6b8eab859ddf46f4&session_max_rows=25&is_browse_distinct=0> is_role <http://localhost/phpmyadmin/index.php?route=/sql&db=mysql&table=user&sql_query=SELECT+%2A+FROM+%60mysql%60.%60user%60+WHERE+%60User%60+IN+%28%27root%27%2C+%27pma%27%29+%0AORDER+BY+%60user%60.%60is_role%60+ASC+&sql_signature=cdb9aa80c0366f538082f8e416e1398822e11790fa07cf7d219a9ab0830c4abc&session_max_rows=25&is_browse_distinct=0> default_role <http://localhost/phpmyadmin/index.php?route=/sql&db=mysql&table=user&sql_query=SELECT+%2A+FROM+%60mysql%60.%60user%60+WHERE+%60User%60+IN+%28%27root%27%2C+%27pma%27%29+%0AORDER+BY+%60user%60.%60default_role%60+ASC+&sql_signature=3bc67b67b3bc0062d8128955c24f74956742179ce0a6177e7848141fd3085333&session_max_rows=25&is_browse_distinct=0> max_statement_time <http://localhost/phpmyadmin/index.php?route=/sql&db=mysql&table=user&sql_query=SELECT+%2A+FROM+%60mysql%60.%60user%60+WHERE+%60User%60+IN+%28%27root%27%2C+%27pma%27%29+%0AORDER+BY+%60user%60.%60max_statement_time%60+ASC+&sql_signature=4ee84dd281b2923463dae109f142cfecc75cca3547b44587791a088b5b1634e5&session_max_rows=25&is_browse_distinct=0> Edit Edit <http://localhost/phpmyadmin/index.php?route=/table/change&db=mysql&table=user&where_clause=%60user%60.%60Host%60+%3D+%27localhost%27+AND+%60user%60.%60User%60+%3D+%27root%27&where_clause_signature=f5edf6a333f8386b32e1aa8afb186f7823f765e970e821cc936aa3074f477013&clause_is_unique=1&sql_query=SELECT+%2A+FROM+%60mysql%60.%60user%60+WHERE+%60User%60+IN+%28%27root%27%2C+%27pma%27%29%3B&sql_signature=004eaa03f7544127d31d830acfe49b7a27e6696a0e57edcbde25195e2136f7aa&goto=index.php%3Froute%3D%2Fsql&default_action=update> Copy Copy <http://localhost/phpmyadmin/index.php?route=/table/change&db=mysql&table=user&where_clause=%60user%60.%60Host%60+%3D+%27localhost%27+AND+%60user%60.%60User%60+%3D+%27root%27&where_clause_signature=f5edf6a333f8386b32e1aa8afb186f7823f765e970e821cc936aa3074f477013&clause_is_unique=1&sql_query=SELECT+%2A+FROM+%60mysql%60.%60user%60+WHERE+%60User%60+IN+%28%27root%27%2C+%27pma%27%29%3B&sql_signature=004eaa03f7544127d31d830acfe49b7a27e6696a0e57edcbde25195e2136f7aa&goto=index.php%3Froute%3D%2Fsql&default_action=insert> Delete Delete <http://localhost/phpmyadmin/index.php> localhost root <http://localhost/phpmyadmin/index.php?route=/server/privileges&username=root&hostname=localhost> invalid Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y
0 0 0 0 mysql_native_password invalid
N N
0.000000
Edit Edit
<http://localhost/phpmyadmin/index.php?route=/table/change&db=mysql&table=user&where_clause=%60user%60.%60Host%60+%3D+%27localhost%27+AND+%60user%60.%60User%60+%3D+%27pma%27&where_clause_signature=be34038c90622b71fc4438229ef267b8ab6dfa57167cc77c073d0e8eee74d708&clause_is_unique=1&sql_query=SELECT+%2A+FROM+%60mysql%60.%60user%60+WHERE+%60User%60+IN+%28%27root%27%2C+%27pma%27%29%3B&sql_signature=004eaa03f7544127d31d830acfe49b7a27e6696a0e57edcbde25195e2136f7aa&goto=index.php%3Froute%3D%2Fsql&default_action=update>
Copy Copy
<http://localhost/phpmyadmin/index.php?route=/table/change&db=mysql&table=user&where_clause=%60user%60.%60Host%60+%3D+%27localhost%27+AND+%60user%60.%60User%60+%3D+%27pma%27&where_clause_signature=be34038c90622b71fc4438229ef267b8ab6dfa57167cc77c073d0e8eee74d708&clause_is_unique=1&sql_query=SELECT+%2A+FROM+%60mysql%60.%60user%60+WHERE+%60User%60+IN+%28%27root%27%2C+%27pma%27%29%3B&sql_signature=004eaa03f7544127d31d830acfe49b7a27e6696a0e57edcbde25195e2136f7aa&goto=index.php%3Froute%3D%2Fsql&default_action=insert>
Delete Delete <http://localhost/phpmyadmin/index.php> localhost pma
<http://localhost/phpmyadmin/index.php?route=/server/privileges&username=pma&hostname=localhost>
*20B6C940622623300FC066ED9B3F7A78D8E94E88 Y Y Y Y Y Y Y Y Y Y
Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y
0 0 0 0 mysql_native_password
*20B6C940622623300FC066ED9B3F7A78D8E94E88 N N
0.000000
