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]