From: Nuno Tavares (nuno.tavaresdri.pt)
Date: Thu Mar 22 2012 - 00:03:22 CDT

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

Charles,

You should run "SELECT version" on both nodes. It looks like you have
different version' schemas.

-NT

Em 22-03-2012 04:41, Brown, Charles escreveu:
> Look man, there has to be someone out there that can tell me why one user table has 5 extra columns. Is it version related or my sysprog person missed out on a step. Its hard to believe that this problem is unique to my site.
>
> 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
>
> ----
> 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
>
>
>
>
> -----Original Message-----
> From: Rik Wasmus [mailto:rikgrib.nl]
> Sent: Wednesday, March 21, 2012 5:08 AM
> To: mysqllists.mysql.com
> Subject: Re: One inst has 39 columns- the other 40
>
>> You keep repeating that, and I already replied to it the first time.
>> If my answer isn't acceptable, spamming the question isn't going to
>> make it better - or make people more inclined to help you, for that matter.
>
> I concur
> --
> Rik Wasmus
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/mysql
>
> ********************************************
> 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

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