Server: 127.0.0.1 »Database: mysql »Table: user"Users and global privileges"
Showing rows 0 - 5 (6 total, Query took 0.0002 seconds.)
SELECT * FROM `user`
[ Inline ] [ Edit ] [ Explain SQL ] [ Create PHP Code ] [ Refresh ]

Sort by key:

Full texts Host User Password Select_priv Insert_priv Update_priv Delete_priv Create_priv Drop_priv Reload_priv Shutdown_priv Process_priv File_priv Grant_priv References_priv Index_priv Alter_priv Show_db_priv Super_priv Create_tmp_table_priv Lock_tables_priv Execute_priv Repl_slave_priv Repl_client_priv Create_view_priv Show_view_priv Create_routine_priv Alter_routine_priv Create_user_priv Event_priv Trigger_priv Create_tablespace_priv ssl_type ssl_cipher x509_issuer x509_subject max_questions max_updates max_connections max_user_connections plugin authentication_string password_expired
Edit Edit Copy Copy Delete Delete
DELETE FROM `mysql`.`user` WHERE `user`.`Host` = \'localhost\' AND `user`.`User` = \'root\'
localhost root 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 [BLOB - 0 B][BLOB - 0 B][BLOB - 0 B]0 0 0 0 N
Edit Edit Copy Copy Delete Delete
DELETE FROM `mysql`.`user` WHERE `user`.`Host` = \'127.0.0.1\' AND `user`.`User` = \'root\'
127.0.0.1 root 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 [BLOB - 0 B][BLOB - 0 B][BLOB - 0 B]0 0 0 0 N
Edit Edit Copy Copy Delete Delete
DELETE FROM `mysql`.`user` WHERE `user`.`Host` = \'::1\' AND `user`.`User` = \'root\'
::1 root 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 [BLOB - 0 B][BLOB - 0 B][BLOB - 0 B]0 0 0 0 N
Edit Edit Copy Copy Delete Delete
DELETE FROM `mysql`.`user` WHERE `user`.`Host` = \'localhost\' AND `user`.`User` = \'\'
localhost N N N N N N N N N N N N N N N N N N N N N N N N N N N N N [BLOB - 0 B][BLOB - 0 B][BLOB - 0 B]0 0 0 0 NULLN
Edit Edit Copy Copy Delete Delete
DELETE FROM `mysql`.`user` WHERE `user`.`Host` = \'localhost\' AND `user`.`User` = \'pma\'
localhost pma N N N N N N N N N N N N N N N N N N N N N N N N N N N N N [BLOB - 0 B][BLOB - 0 B][BLOB - 0 B]0 0 0 0 N
Edit Edit Copy Copy Delete Delete
DELETE FROM `mysql`.`user` WHERE `user`.`Host` = \'localhost\' AND `user`.`User` = \'nectar\'
localhost nectar *FEFB4ED942E1DFEC26B695845494332F33A0EB7F 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 [BLOB - 0 B][BLOB - 0 B][BLOB - 0 B]0 0 0 0 mysql_native_password N
With selected: With selected:

Query results operations Print view Print view Print view (with full texts) Print view (with full texts) Export Export Display chart Display chart Create view Create view

Bookmark this SQL query Bookmark this SQL query