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]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
