--Boundary_(ID_psusrPlWflHgQAdNSHZmdg)
Content-type: text/plain; charset=iso-8859-1
Content-transfer-encoding: 7BIT
I set up MySQL and when I try to start it it fails telling me that I need to run 'mysql_upgrade'. When I run 'mysql_upgrade' it runs 'mysqlcheck' which is supposed to only be run when the server works ...
--Boundary_(ID_psusrPlWflHgQAdNSHZmdg)--
compukat@videotron.ca (michel) writes:
> I set up MySQL and when I try to start it it fails telling me that I
> need to run 'mysql_upgrade'.
Show us the full error output and provide information on the version
of MySQL you are using.
> When I run 'mysql_upgrade' it runs
> 'mysqlcheck' which is supposed to only be run when the server works
> ...
No, mysql_upgrade does call mysqlcheck to see if things need
adjusting. Look at the documentation
http://dev.mysql.com/doc/refman/5.1/en/mysql-upgrade.html
Look at http://dev.mysql.com/doc/refman/5.1/en/upgrade.html which
gives information on upgrading MySQL. However be careful as IMO this
documentation can be a bit confusing and is incomplete. Nevertheless
it's a good starting point.
If however you don't think you are upgrading then you need to provide
more information on how you are installing MySQL so we can determine
why MySQL thinks that it needs to do an upgrade. My guess would be
that you have multiple mysql binaries on your server and are not
running the version you expect.
Simon
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org
Simon,
I might have it fixed! I tried /home/qsys/mysql-5.1.32/libexec/mysqld and I
would get
/home/qsys/mysql-5.1.32/libexec/mysqld: Table 'mysql.plugin' doesn't exist
090510 0:19:54 [ERROR] Can't open the mysql.plugin table. Please run
mysql_upgrade to create it.
090510 0:19:54 [ERROR] Fatal error: Can't open and lock privilege tables:
Table 'mysql.host' doesn't exist
From reading around I tried running
/home/qsys/mysql-5.1.32/bin/mysql_install_db
/home/qsys/mysql-5.1.32/libexec/mysqld
and now I get
090510 0:32:38 [Note] Event Scheduler: Loaded 0 events
090510 0:32:38 [Note] /home/qsys/mysql-5.1.32/libexec/mysqld: ready for
connections.
Version: '5.1.32' socket: '/home/qsys/mysql-5.1.32/mysql.sock' port: 3305
Source distribution
I would suggest that the developers team might change the error messages
----- Original Message -----
From: "Simon J Mudd"
To:
Sent: Sunday, May 10, 2009 5:20 AM
Subject: Re: Still going in cicrles
> compukat@videotron.ca (michel) writes:
>
>> I set up MySQL and when I try to start it it fails telling me that I
>> need to run 'mysql_upgrade'.
>
> Show us the full error output and provide information on the version
> of MySQL you are using.
>
>> When I run 'mysql_upgrade' it runs
>> 'mysqlcheck' which is supposed to only be run when the server works
>> ...
>
> No, mysql_upgrade does call mysqlcheck to see if things need
> adjusting. Look at the documentation
> http://dev.mysql.com/doc/refman/5.1/en/mysql-upgrade.html
>
> Look at http://dev.mysql.com/doc/refman/5.1/en/upgrade.html which
> gives information on upgrading MySQL. However be careful as IMO this
> documentation can be a bit confusing and is incomplete. Nevertheless
> it's a good starting point.
>
> If however you don't think you are upgrading then you need to provide
> more information on how you are installing MySQL so we can determine
> why MySQL thinks that it needs to do an upgrade. My guess would be
> that you have multiple mysql binaries on your server and are not
> running the version you expect.
>
> Simon
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
> http://lists.mysql.com/mysql?unsub=compukat@videotron.ca
>
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org
compukat@videotron.ca (michel) writes:
> I might have it fixed! I tried /home/qsys/mysql-5.1.32/libexec/mysqld
> and I would get
>
> /home/qsys/mysql-5.1.32/libexec/mysqld: Table 'mysql.plugin' doesn't exist
>
> 090510 0:19:54 [ERROR] Can't open the mysql.plugin table. Please run
> mysql_upgrade to create it.
>
> 090510 0:19:54 [ERROR] Fatal error: Can't open and lock privilege
> tables: Table 'mysql.host' doesn't exist
So you had built the binaries by didn't have an initial mysql database
created?
> From reading around I tried running
>
> /home/qsys/mysql-5.1.32/bin/mysql_install_db
>
> /home/qsys/mysql-5.1.32/libexec/mysqld
>
> and now I get
>
> 090510 0:32:38 [Note] Event Scheduler: Loaded 0 events
>
> 090510 0:32:38 [Note] /home/qsys/mysql-5.1.32/libexec/mysqld: ready
> for connections.
>
> Version: '5.1.32' socket: '/home/qsys/mysql-5.1.32/mysql.sock' port:
> 3305 Source distribution
This looks correct.
>
>
>
> I would suggest that the developers team might change the error messages.
Indeed, I'll create a bug report for this.
http://bugs.mysql.com/44765
Simon
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org
Simon, I am totally new to MySQL and followed some instructions from the
internet. Here is the install script I put together that seems to work.
cd /home/qsys
gzip -cd /home/qsys/mysql-5.1.32.tar.gz | tar xf -
mv /home/qsys/mysql-5.1.32 /home/qsys/mysql-5.1.32.source
cd /home/qsys/mysql-5.1.32.source
../configure --help --verbose
../configure --prefix=/home/qsys/mysql-5.1.32 --with-unix-socket-path=/home/qsys/mysql-5.1.32/mysql.sock
--with-tcp-port=3305
make
make install
cd /home/qsys/mysql-5.1.32
mkdir /home/qsys/mysql-5.1.32/var # create the directory to generate
test file alpha.lower.test
/home/qsys/mysql-5.1.32/bin/mysql_install_db
/home/qsys/mysql-5.1.32/libexec/mysqld --general-log=Enable \
--log-output=FILE \
--general_log=/home/qsys/MySQL.log \
--log-error=/home/qsys/MySQL.log \
--bind-address=91.203.57.197
----- Original Message -----
From: "Simon J Mudd"
To:
Sent: Sunday, May 10, 2009 8:03 AM
Subject: Re: Still going in cicrles
> compukat@videotron.ca (michel) writes:
>
>> I might have it fixed! I tried /home/qsys/mysql-5.1.32/libexec/mysqld
>> and I would get
>>
>> /home/qsys/mysql-5.1.32/libexec/mysqld: Table 'mysql.plugin' doesn't
>> exist
>>
>> 090510 0:19:54 [ERROR] Can't open the mysql.plugin table. Please run
>> mysql_upgrade to create it.
>>
>> 090510 0:19:54 [ERROR] Fatal error: Can't open and lock privilege
>> tables: Table 'mysql.host' doesn't exist
>
> So you had built the binaries by didn't have an initial mysql database
> created?
>
>> From reading around I tried running
>>
>> /home/qsys/mysql-5.1.32/bin/mysql_install_db
>>
>> /home/qsys/mysql-5.1.32/libexec/mysqld
>>
>> and now I get
>>
>> 090510 0:32:38 [Note] Event Scheduler: Loaded 0 events
>>
>> 090510 0:32:38 [Note] /home/qsys/mysql-5.1.32/libexec/mysqld: ready
>> for connections.
>>
>> Version: '5.1.32' socket: '/home/qsys/mysql-5.1.32/mysql.sock' port:
>> 3305 Source distribution
>
> This looks correct.
>>
>>
>>
>> I would suggest that the developers team might change the error messages.
>
> Indeed, I'll create a bug report for this.
>
> http://bugs.mysql.com/44765
>
> Simon
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
> http://lists.mysql.com/mysql?unsub=compukat@videotron.ca
>
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org
--_a2076ef7-37af-452b-853d-2156bcce3868_
Content-Type: text/plain; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
starting MYSQL
%MYSQL_HOME%\bin>mysqld --log-output=3DFILE --log-error=3DMySQL.log=20
--result-file=3Dresults.log
--perform some minor operation
mysql -u username -p root DBNAME
mysql>show databases=3B
mysql>use database=3B
mysql>show tables=3B
please display the results of these operations of %MYSQL_HOME%\data\MySQL.l=
og=20
Martin=20
______________________________________________=20
Note de d=E9ni et de confidentialit=E9
Ce message est confidentiel et peut =EAtre privil=E9gi=E9. Si vous n'=EAtes=
pas le destinataire pr=E9vu=2C nous te demandons avec bont=E9 que pour sat=
isfaire informez l'exp=E9diteur. N'importe quelle diffusion non autoris=E9e=
ou la copie de ceci est interdite. Ce message sert =E0 l'information seule=
ment et n'aura pas n'importe quel effet l=E9galement obligatoire. =C9tant d=
onn=E9 que les email peuvent facilement =EAtre sujets =E0 la manipulation=
=2C nous ne pouvons accepter aucune responsabilit=E9 pour le contenu fourni=
..
> From: compukat@videotron.ca
> To: mysql@lists.mysql.com
> Subject: Re: Still going in cicrles
> Date: Sun=2C 10 May 2009 08:13:48 -0400
>=20
> Simon=2C I am totally new to MySQL and followed some instructions from th=
e=20
> internet. Here is the install script I put together that seems to work.
>=20
>=20
> cd /home/qsys
> gzip -cd /home/qsys/mysql-5.1.32.tar.gz | tar xf -
>=20
> mv /home/qsys/mysql-5.1.32 /home/qsys/mysql-5.1.32.source
>=20
> cd /home/qsys/mysql-5.1.32.source
>=20
> ./configure --help --verbose
>=20
> ./configure --prefix=3D/home/qsys/mysql-5.1.32 --with-unix-socket-path=3D=
/home/qsys/mysql-5.1.32/mysql.sock=20
> --with-tcp-port=3D3305
>=20
> make
>=20
> make install
>=20
> cd /home/qsys/mysql-5.1.32
>=20
> mkdir /home/qsys/mysql-5.1.32/var # create the directory to gener=
ate=20
> test file alpha.lower.test
>=20
> /home/qsys/mysql-5.1.32/bin/mysql_install_db
>=20
> /home/qsys/mysql-5.1.32/libexec/mysqld --general-log=3DEnable \
>=20
> --log-output=3DFILE \
>=20
> --general_log=3D/home/qsys/MySQL.log \
>=20
> --log-error=3D/home/qsys/MySQL.log \
>=20
> --bind-address=3D91.203.57.197
>=20
>=20
>=20
>=20
>=20
>=20
> ----- Original Message -----=20
> From: "Simon J Mudd"
> To:
> Sent: Sunday=2C May 10=2C 2009 8:03 AM
> Subject: Re: Still going in cicrles
>=20
>=20
> > compukat@videotron.ca (michel) writes:
> >
> >> I might have it fixed! I tried /home/qsys/mysql-5.1.32/libexec/mysqld
> >> and I would get
> >>
> >> /home/qsys/mysql-5.1.32/libexec/mysqld: Table 'mysql.plugin' doesn't=20
> >> exist
> >>
> >> 090510 0:19:54 [ERROR] Can't open the mysql.plugin table. Please run
> >> mysql_upgrade to create it.
> >>
> >> 090510 0:19:54 [ERROR] Fatal error: Can't open and lock privilege
> >> tables: Table 'mysql.host' doesn't exist
> >
> > So you had built the binaries by didn't have an initial mysql database
> > created?
> >
> >> From reading around I tried running
> >>
> >> /home/qsys/mysql-5.1.32/bin/mysql_install_db
> >>
> >> /home/qsys/mysql-5.1.32/libexec/mysqld
> >>
> >> and now I get
> >>
> >> 090510 0:32:38 [Note] Event Scheduler: Loaded 0 events
> >>
> >> 090510 0:32:38 [Note] /home/qsys/mysql-5.1.32/libexec/mysqld: ready
> >> for connections.
> >>
> >> Version: '5.1.32' socket: '/home/qsys/mysql-5.1.32/mysql.sock' port:
> >> 3305 Source distribution
> >
> > This looks correct.
> >>
> >>
> >>
> >> I would suggest that the developers team might change the error messag=
es.
> >
> > Indeed=2C I'll create a bug report for this.
> >
> > http://bugs.mysql.com/44765
> >
> > Simon
> >
> >
> > --=20
> > MySQL General Mailing List
> > For list archives: http://lists.mysql.com/mysql
> > To unsubscribe:=20
> > http://lists.mysql.com/mysql?unsub=3Dcompukat@videotron.ca
> >=20
>=20
>=20
> --=20
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/mysql?unsub=3Dmgainty@hotmail.c=
om
>=20
____________________________________________________________ _____
Hotmail=AE has a new way to see what's up with your friends.
http://windowslive.com/Tutorial/Hotmail/WhatsNew?ocid=3DTXT_ TAGLM_WL_HM_Tut=
orial_WhatsNew1_052009=
--_a2076ef7-37af-452b-853d-2156bcce3868_--
--_9dde41c5-c8d9-478b-ac73-10eef0b52faf_
Content-Type: text/plain; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
providing accurate information would've helped the op in this situation
i agree!
thanks=2C
Martin=20
______________________________________________=20
Disclaimer and Confidentiality/Verzicht und Vertraulichkeitanmerkung/Note d=
e d=E9ni et de confidentialit=E9
This message is confidential. If you should not be the intended receiver=2C=
then we ask politely to report. Each unauthorized forwarding or manufactur=
ing of a copy is inadmissible. This message serves only for the exchange of=
information and has no legal binding effect. Due to the easy manipulation =
of emails we cannot take responsibility over the the contents.
Diese Nachricht ist vertraulich. Sollten Sie nicht der vorgesehene Empfaeng=
er sein=2C so bitten wir hoeflich um eine Mitteilung. Jede unbefugte Weiter=
leitung oder Fertigung einer Kopie ist unzulaessig. Diese Nachricht dient l=
ediglich dem Austausch von Informationen und entfaltet keine rechtliche Bin=
dungswirkung. Aufgrund der leichten Manipulierbarkeit von E-Mails koennen w=
ir keine Haftung fuer den Inhalt uebernehmen.
Ce message est confidentiel et peut =EAtre privil=E9gi=E9. Si vous n'=EAtes=
pas le destinataire pr=E9vu=2C nous te demandons avec bont=E9 que pour sat=
isfaire informez l'exp=E9diteur. N'importe quelle diffusion non autoris=E9e=
ou la copie de ceci est interdite. Ce message sert =E0 l'information seule=
ment et n'aura pas n'importe quel effet l=E9galement obligatoire. =C9tant d=
onn=E9 que les email peuvent facilement =EAtre sujets =E0 la manipulation=
=2C nous ne pouvons accepter aucune responsabilit=E9 pour le contenu fourni=
..
> To: mysql@lists.mysql.com
> Subject: Re: Still going in cicrles
> From: sjmudd@pobox.com
> Date: Sun=2C 10 May 2009 14:03:15 +0200
>=20
> compukat@videotron.ca (michel) writes:
>=20
> > I might have it fixed! I tried /home/qsys/mysql-5.1.32/libexec/mysqld
> > and I would get
> >=20
> > /home/qsys/mysql-5.1.32/libexec/mysqld: Table 'mysql.plugin' doesn't ex=
ist
> >=20
> > 090510 0:19:54 [ERROR] Can't open the mysql.plugin table. Please run
> > mysql_upgrade to create it.
> >=20
> > 090510 0:19:54 [ERROR] Fatal error: Can't open and lock privilege
> > tables: Table 'mysql.host' doesn't exist
>=20
> So you had built the binaries by didn't have an initial mysql database
> created?
>=20
> > From reading around I tried running
> >=20
> > /home/qsys/mysql-5.1.32/bin/mysql_install_db
> >=20
> > /home/qsys/mysql-5.1.32/libexec/mysqld
> >=20
> > and now I get
> >=20
> > 090510 0:32:38 [Note] Event Scheduler: Loaded 0 events
> >=20
> > 090510 0:32:38 [Note] /home/qsys/mysql-5.1.32/libexec/mysqld: ready
> > for connections.
> >=20
> > Version: '5.1.32' socket: '/home/qsys/mysql-5.1.32/mysql.sock' port:
> > 3305 Source distribution
>=20
> This looks correct.
> >=20
> >=20
> >=20
> > I would suggest that the developers team might change the error message=
s.
>=20
> Indeed=2C I'll create a bug report for this.
>=20
> http://bugs.mysql.com/44765
>=20
> Simon
>=20
>=20
> --=20
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/mysql?unsub=3Dmgainty@hotmail.c=
om
>=20
____________________________________________________________ _____
Hotmail=AE goes with you.=20
http://windowslive.com/Tutorial/Hotmail/Mobile?ocid=3DTXT_TA GLM_WL_HM_Tutor=
ial_Mobile1_052009=
--_9dde41c5-c8d9-478b-ac73-10eef0b52faf_--