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 -------------------------------------------------------------------- mail2web - Check your email from the web at http://mail2web.com/ . -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]