From: Johan De Meersman (vegivamptuxera.be)
Date: Thu Mar 22 2012 - 04:46:08 CDT

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

*plonk*

----- Original Message -----
> From: "Charles Brown" <CBrownBMI.com>
> To: "Reindl Harald" <h.reindlthelounge.net>
> Cc: "MySql" <mysqllists.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.
>
> 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.
> ********************************************
>

--
Bier met grenadyn
Is als mosterd by den wyn
Sy die't drinkt, is eene kwezel
Hy die't drinkt, is ras een ezel

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]