Server: mysql wampserver »Database: mysql »Table: user"Users and global privileges"
Showing rows 0 - 3 (4 total, Query took 0.0005 sec)
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
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