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]
