Hi Dave
tha' sounds great. i 'll try to do the same immediately.
thanks for your help.
suomi
Logan, David (SST - Adelaide) wrote:
Hi suomi,
From my understanding (and I have just performed it myself about 2 hours
ago on one of my servers), I stopped the server, took a backup of the
data directories, built the new server and put it in place (same as your
rpm step), started the server, ran the fix script as
/usr/local/mysql/bin/mysql_fix_privilege_tables
--basedir=/usr/local/mysql --user=root --password=xxxxxx --verbose
It ran ok. I stopped and started the server and away it went with no
problems.
Regards
---------------------------------------------------------------
********** _/ ********** David Logan
******* _/ ******* ITO Delivery Specialist - Database
***** _/ ***** Hewlett-Packard Australia Ltd
**** _/_/_/ _/_/_/ **** E-Mail: [EMAIL PROTECTED]
**** _/ _/ _/ _/ **** Desk: +618 8408 4273
**** _/ _/ _/_/_/ **** Mobile: 0417 268 665
***** _/ ******
****** _/ ******** Postal: 148 Frome Street,
******** _/ ********** Adelaide SA 5001
Australia
i n v e n t
---------------------------------------------------------------
-----Original Message-----
From: suomi [mailto:[EMAIL PROTECTED]
Sent: Thursday, 9 February 2006 6:47 PM
To: Logan, David (SST - Adelaide)
Cc: mysql@lists.mysql.com
Subject: Re: Failed to upgrade from 4.1.16 to 5.0.18
Hi Dave
i did so, but probably in the wrong moment. i got "Access denied" when i
run the script.
you mean that this should have been the very first step after the
upgrade.
suomi
Logan, David (SST - Adelaide) wrote:
Hi,
Did you run the bin/mysql_fix_privilege_tables script? This is
documented in the upgrade procedures on the website under the
installation chapter.
Regards
---------------------------------------------------------------
********** _/ ********** David Logan
******* _/ ******* ITO Delivery Specialist - Database
***** _/ ***** Hewlett-Packard Australia Ltd
**** _/_/_/ _/_/_/ **** E-Mail: [EMAIL PROTECTED]
**** _/ _/ _/ _/ **** Desk: +618 8408 4273
**** _/ _/ _/_/_/ **** Mobile: 0417 268 665
***** _/ ******
****** _/ ******** Postal: 148 Frome Street,
******** _/ ********** Adelaide SA 5001
Australia
i n v e n t
---------------------------------------------------------------
-----Original Message-----
From: suomi [mailto:[EMAIL PROTECTED]
Sent: Thursday, 9 February 2006 6:04 PM
To: mysql@lists.mysql.com
Subject: Failed to upgrade from 4.1.16 to 5.0.18
Hi listers
1.
i did the upgrad as i usually did so far:
/etc/init.d/mysql stop
rpm -U MySQL-server-standard-5.0.18-0.rhel3.i386.rpm
rpm -U MySQL-client-standard-5.0.18-0.rhel3.i386.rpm
rpm -U MySQL-shared-standard-5.0.18-0.rhel3.i386.rpm
from then on: no chance to enter the database via whatever interface:
always Access denied for user .... on host ...
2.
i checked to see, whether the mysql userid had sufficient access
privileges to all database files: all access was ok.
i also checked the error log myhost.mydomain.tld.err: no hint why
access
was denied.
3.
i then went back to 4.1.16, entered the database (no problem) and for
the root user created the long password and intentionally did a flush
privileges.
4.
then i re-did the above (under 1) upgrade steps again to the same
event:
Access denied.
5.
i then took the procedure described in
http://dev.mysql.com/doc/refman/5.0/en/resetting-permissions.html
while in the procedure, when i wanted to enter the flush privileges,
again access denied.
6.
i checked to see, whether there is some upgrade procedure to follow,
where privilege tables are upgraded (as from 3 to 4), and i found none.
i read the README even more carefully: nothing found.
7.
back to 4.1.16
which essential step did i omitt?
suomi
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]