Server: localhost:3306 »Database: mysql »Table: user"Users and global privileges"
Showing rows 0 - 4 (5 total, Query took 0.0020 sec)
SELECT *
FROM `user`
LIMIT 0 , 30
[ 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
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
Edit Edit Copy Copy Delete Delete
DELETE FROM `mysql`.`user` WHERE `user`.`Host` = \'linux\' AND `user`.`User` = \'root\'
linux 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
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
Edit Edit Copy Copy Delete Delete
DELETE FROM `mysql`.`user` WHERE `user`.`Host` = \'linux\' AND `user`.`User` = \'\'
linux 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
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
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