148.216.95.41 / mysql wampserver / mysql / user

Table: user"Users and global privileges"

#	Name	Type	Collation	Attributes	Null	Default	Action
1	Host	char(60)	utf8_bin		No		Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
2	User	char(16)	utf8_bin		No		Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
3	Password	char(41)	latin1_bin		No		Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
4	Select_priv	enum('N', 'Y')	utf8_general_ci		No	N	Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
5	Insert_priv	enum('N', 'Y')	utf8_general_ci		No	N	Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
6	Update_priv	enum('N', 'Y')	utf8_general_ci		No	N	Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
7	Delete_priv	enum('N', 'Y')	utf8_general_ci		No	N	Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
8	Create_priv	enum('N', 'Y')	utf8_general_ci		No	N	Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
9	Drop_priv	enum('N', 'Y')	utf8_general_ci		No	N	Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
10	Reload_priv	enum('N', 'Y')	utf8_general_ci		No	N	Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
11	Shutdown_priv	enum('N', 'Y')	utf8_general_ci		No	N	Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
12	Process_priv	enum('N', 'Y')	utf8_general_ci		No	N	Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
13	File_priv	enum('N', 'Y')	utf8_general_ci		No	N	Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
14	Grant_priv	enum('N', 'Y')	utf8_general_ci		No	N	Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
15	References_priv	enum('N', 'Y')	utf8_general_ci		No	N	Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
16	Index_priv	enum('N', 'Y')	utf8_general_ci		No	N	Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
17	Alter_priv	enum('N', 'Y')	utf8_general_ci		No	N	Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
18	Show_db_priv	enum('N', 'Y')	utf8_general_ci		No	N	Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
19	Super_priv	enum('N', 'Y')	utf8_general_ci		No	N	Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
20	Create_tmp_table_priv	enum('N', 'Y')	utf8_general_ci		No	N	Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
21	Lock_tables_priv	enum('N', 'Y')	utf8_general_ci		No	N	Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
22	Execute_priv	enum('N', 'Y')	utf8_general_ci		No	N	Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
23	Repl_slave_priv	enum('N', 'Y')	utf8_general_ci		No	N	Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
24	Repl_client_priv	enum('N', 'Y')	utf8_general_ci		No	N	Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
25	Create_view_priv	enum('N', 'Y')	utf8_general_ci		No	N	Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
26	Show_view_priv	enum('N', 'Y')	utf8_general_ci		No	N	Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
27	Create_routine_priv	enum('N', 'Y')	utf8_general_ci		No	N	Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
28	Alter_routine_priv	enum('N', 'Y')	utf8_general_ci		No	N	Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
29	Create_user_priv	enum('N', 'Y')	utf8_general_ci		No	N	Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
30	Event_priv	enum('N', 'Y')	utf8_general_ci		No	N	Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
31	Trigger_priv	enum('N', 'Y')	utf8_general_ci		No	N	Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
32	Create_tablespace_priv	enum('N', 'Y')	utf8_general_ci		No	N	Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
33	ssl_type	enum('', 'ANY', 'X509', 'SPECIFIED')	utf8_general_ci		No		Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
34	ssl_cipher	blob			No	None	Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
35	x509_issuer	blob			No	None	Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
36	x509_subject	blob			No	None	Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
37	max_questions	int(11)		UNSIGNED	No	0	Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
38	max_updates	int(11)		UNSIGNED	No	0	Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
39	max_connections	int(11)		UNSIGNED	No	0	Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
40	max_user_connections	int(11)		UNSIGNED	No	0	Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
41	plugin	char(64)	utf8_bin		Yes		Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
42	authentication_string	text	utf8_bin		Yes	NULL	Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
43	password_expired	enum('N', 'Y')	utf8_general_ci		No	N	Change	Drop	Primary Unique Index Spatial Fulltext Distinct values

Check AllWith selected:

Print view

Propose table structure

Move columns

Action	Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
Edit	Drop	PRIMARY	BTREE	Yes	No	Host		A	No
User	4	A	No

Information

Space usage
Data	212	B
Index	2	KiB
Total	2.2	KiB

Row statistics
Format	dynamic
Collation	utf8_bin
Rows	4
Row length	53 B
Row size	565 B
Creation	Mar 14, 2014 at 01:30 PM
Last update	May 01, 2014 at 09:06 AM