On Saturday 10 April 2004 08:15 am, [EMAIL PROTECTED] wrote: > hi > > I have redhat 7.2 running on my server with plesk > i forgot mysql password for user root > so i reset it by following way > > services mysqld stop > safe_mysqld --skip-grant-tables & > mysqladmin -u root fulsh-privileges password newpassword > > services mysqld restart. > > now i can logon to mysql by root user > > but i can not create and modify databases > it gives an error access denied for user [EMAIL PROTECTED] > > i do not know how to recover root privileges > > please help me
I had the same problem a few weeks ago with RH 9. I backed up the databases in /var/lib/mysql and then removed the RH mysqld rpms. I then downloaded the latest binary installer (4.0.18) from http://www.mysql.com and followed the directions to install it. Everything works fine now, and when privileges get screwed up (yes, believe it or not, I screwed them up again while trying to 'secure' my db), I can rerun the script that sets up the mysql table and things are back to normal. Best of luck, Brad -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]