Re: tables do not have the same number of columns.
*plonk*
- Original Message -
From: Charles Brown cbr...@bmi.com
To: Reindl Harald h.rei...@thelounge.net
Cc: MySql mysql@lists.mysql.com
Sent: Thursday, 22 March, 2012 5:37:00 AM
Subject: tables do not have the same number of columns.
I have two mysql instances in my mysql cluster. I noticed that their
MysSQL.user tables do not have the same number of columns. See below
for their attributes. Is anyone out there has any idea why these
tables are not the same? Can someone help me.
Hostchar(60)NO
Userchar(16)NO
Passwordchar(41)NO
Select_priv enum('N','Y') NO N
Insert_priv enum('N','Y') NO N
Update_priv enum('N','Y') NO N
Delete_priv enum('N','Y') NO N
Create_priv enum('N','Y') NO N
Drop_priv enum('N','Y') NO N
Reload_priv enum('N','Y') NO N
Shutdown_priv enum('N','Y') NO N
Process_privenum('N','Y') NO N
File_priv enum('N','Y') NO N
Grant_priv enum('N','Y') NO N
References_priv enum('N','Y') NO N
Index_priv enum('N','Y') NO N
Alter_priv enum('N','Y') NO N
Show_db_privenum('N','Y') NO N
Super_priv enum('N','Y') NO N
Create_tmp_table_priv enum('N','Y') NO N
Lock_tables_privenum('N','Y') NO N
Execute_privenum('N','Y') NO N
Repl_slave_priv enum('N','Y') NO N
Repl_client_privenum('N','Y') NO N
Create_view_privenum('N','Y') NO N
Show_view_priv enum('N','Y') NO N
Create_routine_priv enum('N','Y') NO N
Alter_routine_priv enum('N','Y') NO N
Create_user_privenum('N','Y') NO N
ssl_typeenum('','ANY','X509','SPECIFIED') NO
ssl_cipher blobNO
x509_issuer blobNO
x509_subjectblobNO
max_questions int(11) unsignedNO 0
max_updates int(11) unsignedNO 0
max_connections int(11) unsignedNO 0
max_user_connectionsint(11) unsignedNO 0
Another user table
Host char(60)NO PRI
User char(16)NO PRI
Password char(41)NO
Select_priv enum('N','Y') NO N
Insert_priv enum('N','Y') NO N
Update_priv enum('N','Y') NO N
Delete_priv enum('N','Y') NO N
Create_priv enum('N','Y') NO N
Drop_priv enum('N','Y') NO N
Reload_priv enum('N','Y') NO N
Shutdown_priv enum('N','Y') NO N
Process_priv enum('N','Y') NO N
File_priv enum('N','Y') NO N
Grant_privenum('N','Y') NO N
References_priv enum('N','Y') NO N
Index_privenum('N','Y') NO N
Alter_privenum('N','Y') NO N
Show_db_priv enum('N','Y') NO N
Super_privenum('N','Y') NO N
Create_tmp_table_priv enum('N','Y') NO N
Lock_tables_priv enum('N','Y') NO N
Execute_priv enum('N','Y') NO N
Repl_slave_priv enum('N','Y') NO N
Repl_client_priv enum('N','Y') NO N
Create_view_priv enum('N','Y') NO N
Show_view_privenum('N','Y') NO N
Create_routine_priv enum('N','Y') NO N
Alter_routine_privenum('N','Y') NO N
Create_user_priv enum('N','Y') NO N
Event_privenum('N','Y') NO N
Trigger_priv enum('N','Y') NO N
Create_tablespace_privenum('N','Y') NO N
ssl_type enum('','ANY','X509','SPECIFIED') NO
ssl_cipherblobNO
x509_issuer blobNO
x509_subject blobNO
max_questions int(11) unsignedNO 0
max_updates int(11) unsignedNO 0
max_connections int(11) unsignedNO 0
max_user_connections int(11) unsignedNO 0
pluginchar(64)YES
authentication_string textYES
This message is intended only for the use of the Addressee and
may contain information that is PRIVILEGED and CONFIDENTIAL.
If you are not the intended recipient, you are hereby notified
that any dissemination of this communication is strictly
tables do not have the same number of columns.
I have two mysql instances in my mysql cluster. I noticed that their
MysSQL.user tables do not have the same number of columns. See below for their
attributes. Is anyone out there has any idea why these tables are not the same?
Can someone help me.
Hostchar(60)NO
Userchar(16)NO
Passwordchar(41)NO
Select_priv enum('N','Y') NO N
Insert_priv enum('N','Y') NO N
Update_priv enum('N','Y') NO N
Delete_priv enum('N','Y') NO N
Create_priv enum('N','Y') NO N
Drop_priv enum('N','Y') NO N
Reload_priv enum('N','Y') NO N
Shutdown_priv enum('N','Y') NO N
Process_privenum('N','Y') NO N
File_priv enum('N','Y') NO N
Grant_priv enum('N','Y') NO N
References_priv enum('N','Y') NO N
Index_priv enum('N','Y') NO N
Alter_priv enum('N','Y') NO N
Show_db_privenum('N','Y') NO N
Super_priv enum('N','Y') NO N
Create_tmp_table_priv enum('N','Y') NO N
Lock_tables_privenum('N','Y') NO N
Execute_privenum('N','Y') NO N
Repl_slave_priv enum('N','Y') NO N
Repl_client_privenum('N','Y') NO N
Create_view_privenum('N','Y') NO N
Show_view_priv enum('N','Y') NO N
Create_routine_priv enum('N','Y') NO N
Alter_routine_priv enum('N','Y') NO N
Create_user_privenum('N','Y') NO N
ssl_typeenum('','ANY','X509','SPECIFIED') NO
ssl_cipher blobNO
x509_issuer blobNO
x509_subjectblobNO
max_questions int(11) unsignedNO 0
max_updates int(11) unsignedNO 0
max_connections int(11) unsignedNO 0
max_user_connectionsint(11) unsignedNO 0
Another user table
Hostchar(60)NO PRI
Userchar(16)NO PRI
Passwordchar(41)NO
Select_priv enum('N','Y') NO N
Insert_priv enum('N','Y') NO N
Update_priv enum('N','Y') NO N
Delete_priv enum('N','Y') NO N
Create_priv enum('N','Y') NO N
Drop_priv enum('N','Y') NO N
Reload_priv enum('N','Y') NO N
Shutdown_priv enum('N','Y') NO N
Process_privenum('N','Y') NO N
File_priv enum('N','Y') NO N
Grant_priv enum('N','Y') NO N
References_priv enum('N','Y') NO N
Index_priv enum('N','Y') NO N
Alter_priv enum('N','Y') NO N
Show_db_privenum('N','Y') NO N
Super_priv enum('N','Y') NO N
Create_tmp_table_priv enum('N','Y') NO N
Lock_tables_privenum('N','Y') NO N
Execute_privenum('N','Y') NO N
Repl_slave_priv enum('N','Y') NO N
Repl_client_privenum('N','Y') NO N
Create_view_privenum('N','Y') NO N
Show_view_priv enum('N','Y') NO N
Create_routine_priv enum('N','Y') NO N
Alter_routine_priv enum('N','Y') NO N
Create_user_privenum('N','Y') NO N
Event_priv enum('N','Y') NO N
Trigger_privenum('N','Y') NO N
Create_tablespace_priv enum('N','Y') NO N
ssl_typeenum('','ANY','X509','SPECIFIED') NO
ssl_cipher blobNO
x509_issuer blobNO
x509_subjectblobNO
max_questions int(11) unsignedNO 0
max_updates int(11) unsignedNO 0
max_connections int(11) unsignedNO 0
max_user_connectionsint(11) unsignedNO 0
plugin char(64)YES
authentication_string textYES
This message
