RE: One inst has 39 columns- the other 40
Thanks all -- it was a version problem. My sysprog person is going to re down load from Oracle. Thanks again for all the wonderful help. -Original Message- From: Reindl Harald [mailto:h.rei...@thelounge.net] Sent: Thursday, March 22, 2012 4:25 AM To: mysql@lists.mysql.com Subject: Re: One inst has 39 columns- the other 40 Am 22.03.2012 05:41, schrieb Brown: > 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. logically is it version-dependent that is why you have to run "mysql_upgrade -u root -p" after updates > pluginchar(64)YES exists only on recent mysql versions as example 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
Re: One inst has 39 columns- the other 40
On 22/03/2012 04:41, Brown, Charles wrote: Look man, there has to be someone out there that can tell me why one user table has 5 extra columns. As far as I can see, plenty of people already have told you. Is it version related or my sysprog person missed out on a step. Yes, it's related to your version. You probably have different versions of MySQL on different nodes of the cluster. Your sysprog person has missed out the step of ensuring that all nodes are upgraded at the same time in order to maintain consistency. Its hard to believe that this problem is unique to my site. No, the problem is not unique to your site. It's an easy mistake to make. Please could you now give some indication of having read and understood this reply. Mark -- Sent from my Babbage Difference Engine 2 http://mark.goodge.co.uk -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
Re: One inst has 39 columns- the other 40
Am 22.03.2012 05:41, schrieb Brown: > 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. logically is it version-dependent that is why you have to run "mysql_upgrade -u root -p" after updates > pluginchar(64)YES exists only on recent mysql versions as example signature.asc Description: OpenPGP digital signature
Re: One inst has 39 columns- the other 40
um('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:r...@grib.nl]
>> Sent: Wednesday, March 21, 2012 5:08 AM
>> To: mysql@lists.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
>
--
 - michael dykman
 - mdyk...@gmail.com
 May the Source be with you.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql
Re: One inst has 39 columns- the other 40
#x27;,'Y') NO N
Repl_slave_priv enum('N','Y') NO N
Repl_client_privenum('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_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
-Original Message-
From: Rik Wasmus [mailto:r...@grib.nl]
Sent: Wednesday, March 21, 2012 5:08 AM
To: mysql@lists.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
RE: One inst has 39 columns- the other 40
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_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
-Original Message-
From: Rik Wasmus [mailto:r...@grib.nl]
Sent: Wednesday, March 21, 2012 5:08 AM
To: mysql@lists.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
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
Re: One inst has 39 columns- the other 40
Am 21.03.2012 06:27, schrieb Brown: > I have two mysql instances in my mysql cluster. I noticed that their > MysSQL.user tables do not have the same number of columns. Their USER table > attributes are not the same. One instance has 39 columns while the other has > 42 columns. Can someone please help me here. Could it be because I'm running > mysql cluster? Can someone help me. i saw the same question days before why repeating? > Thanks > > This message is intended only for the use of the Addressee and > may contain information that is PRIVILEGED and CONFIDENTIAL. > can you please remive this bulls**it if you send to mailing-lists? signature.asc Description: OpenPGP digital signature
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. - Original Message - > From: "Charles Brown" > To: "Charles Brown" , mysql@lists.mysql.com > Sent: Wednesday, 21 March, 2012 6:27:17 AM > Subject: RE: One inst has 39 columns- the other 40 > > I have two mysql instances in my mysql cluster. I noticed that their > MysSQL.user tables do not have the same number of columns. Their > USER table attributes are not the same. One instance has 39 columns > while the other has 42 columns. Can someone please help me here. > Could it be because I'm running mysql cluster? Can someone help me. -- 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
RE: One inst has 39 columns- the other 40
I have two mysql instances in my mysql cluster. I noticed that their MysSQL.user tables do not have the same number of columns. Their USER table attributes are not the same. One instance has 39 columns while the other has 42 columns. Can someone please help me here. Could it be because I'm running mysql cluster? Can someone help me. Thanks 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
Re: One inst has 39 columns- the other 40
- Original Message - > From: "Charles Brown" > > I have two mysql instances in my mysql cluster. I noticed that their > MysSQL.user tables do not have the same number of columns. Their > USER table attributes are not the same. One instance has 39 columns > while the other has 42 columns. Can someone please help me here. > Could it be because I'm running mysql cluster? Can someone help me. I take it you are indeed talking about NDB cluster ? The MySQL instances in your NDB cluster are really just SQL-to-NDB translator, so running NDB has nothing to do with the layout of your mysql.* table structure. The most likely cause is simply different versions of MySQL on the nodes, followed by not having run the mysql_upgrade script after you upgraded the software. It's not a /major/ problem, really, but it is good to have the correct layout so you can assing all the available privileges. See "man mysql_upgrade" for more information. -- 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
