List:General Discussion« Previous MessageNext Message »
From:Charles Brown Date:March 22 2012 4:37am
Subject:tables do not have the same number of columns.
View as plain text  
 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. 

	Host	char(60)	NO			
	User	char(16)	NO			
	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_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_priv	enum('N','Y')	NO		N	
	Super_priv	enum('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_priv	enum('N','Y')	NO		N	
	Create_routine_priv	enum('N','Y')	NO		N	
	Alter_routine_priv	enum('N','Y')	NO		N	
	Create_user_priv	enum('N','Y')	NO		N	
	ssl_type	enum('','ANY','X509','SPECIFIED')	NO			
	ssl_cipher	blob	NO			
	x509_issuer	blob	NO			
	x509_subject	blob	NO			
	max_questions	int(11) unsigned	NO		0	
	max_updates	int(11) unsigned	NO		0	
	max_connections	int(11) unsigned	NO		0	
	max_user_connections	int(11) unsigned	NO		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_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_priv	enum('N','Y')	NO		N
Super_priv	enum('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_priv	enum('N','Y')	NO		N
Create_routine_priv	enum('N','Y')	NO		N
Alter_routine_priv	enum('N','Y')	NO		N
Create_user_priv	enum('N','Y')	NO		N
Event_priv	enum('N','Y')	NO		N
Trigger_priv	enum('N','Y')	NO		N
Create_tablespace_priv	enum('N','Y')	NO		N
ssl_type	enum('','ANY','X509','SPECIFIED')	NO		
ssl_cipher	blob	NO		
x509_issuer	blob	NO		
x509_subject	blob	NO		
max_questions	int(11) unsigned	NO		0
max_updates	int(11) unsigned	NO		0
max_connections	int(11) unsigned	NO		0
max_user_connections	int(11) unsigned	NO		0
plugin	char(64)	YES		
authentication_string	text	YES		




********************************************
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 prohibited.

If you have received this communication in error, please erase
all copies of the message and its attachments and notify us
immediately.

Thank you.
********************************************
Thread
date comparison querySimon Wilkinson16 Mar
  • Re: date comparison queryBaron Schwartz16 Mar
  • Re: date comparison queryhsv17 Mar
    • One inst has 39 columns- the other 40Charles Brown18 Mar
      • Re: One inst has 39 columns- the other 40Johan De Meersman19 Mar
  • One inst has 39 columns- the other 40Charles Brown19 Mar
  • RE: One inst has 39 columns- the other 40Charles Brown21 Mar
    • Re: One inst has 39 columns- the other 40Johan De Meersman21 Mar
      • Re: One inst has 39 columns- the other 40Rik Wasmus21 Mar
        • RE: One inst has 39 columns- the other 40Charles Brown22 Mar
          • Re: One inst has 39 columns- the other 40Nuno Tavares22 Mar
            • Re: One inst has 39 columns- the other 40Michael Dykman22 Mar
          • Re: One inst has 39 columns- the other 40Reindl Harald22 Mar
            • RE: One inst has 39 columns- the other 40Charles Brown22 Mar
          • Re: One inst has 39 columns- the other 40Mark Goodge22 Mar
    • Re: One inst has 39 columns- the other 40Reindl Harald21 Mar
      • tables do not have the same number of columns. Charles Brown22 Mar
        • Re: tables do not have the same number of columns.Johan De Meersman22 Mar