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.
=09Host char(60) NO =09
=09User char(16) NO =09
=09Password char(41) NO =09
=09Select_priv enum('N','Y') NO N=09
=09Insert_priv enum('N','Y') NO N=09
=09Update_priv enum('N','Y') NO N=09
=09Delete_priv enum('N','Y') NO N=09
=09Create_priv enum('N','Y') NO N=09
=09Drop_priv enum('N','Y') NO N=09
=09Reload_priv enum('N','Y') NO N=09
=09Shutdown_priv enum('N','Y') NO N=09
=09Process_priv enum('N','Y') NO N=09
=09File_priv enum('N','Y') NO N=09
=09Grant_priv enum('N','Y') NO N=09
=09References_priv enum('N','Y') NO N=09
=09Index_priv enum('N','Y') NO N=09
=09Alter_priv enum('N','Y') NO N=09
=09Show_db_priv enum('N','Y') NO N=09
=09Super_priv enum('N','Y') NO N=09
=09Create_tmp_table_priv enum('N','Y') NO N=09
=09Lock_tables_priv enum('N','Y') NO N=09
=09Execute_priv enum('N','Y') NO N=09
=09Repl_slave_priv enum('N','Y') NO N=09
=09Repl_client_priv enum('N','Y') NO N=09
=09Create_view_priv enum('N','Y') NO N=09
=09Show_view_priv enum('N','Y') NO N=09
=09Create_routine_priv enum('N','Y') NO N=09
=09Alter_routine_priv enum('N','Y') NO N=09
=09Create_user_priv enum('N','Y') NO N=09
=09ssl_type enum('','ANY','X509','SPECIFIED') NO =09
=09ssl_cipher blob NO =09
=09x509_issuer blob NO =09
=09x509_subject blob NO =09
=09max_questions int(11) unsigned NO 0=09
=09max_updates int(11) unsigned NO 0=09
=09max_connections int(11) unsigned NO 0=09
=09max_user_connections int(11) unsigned NO 0=09
Another user table
Host char(60) NO PRI=09
User char(16) NO PRI=09
Password char(41) NO =09
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 =09
ssl_cipher blob NO =09
x509_issuer blob NO =09
x509_subject blob NO =09
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 =09
authentication_string text YES =09
********************************************
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.
********************************************
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql