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]

Reply via email to