> I have recently installes mysql -4.0.0.1 on my redhat 7.1 machine . After > installing when enter into mysql it gives me message " Access denied for > user [EMAIL PROTECTED] host .......using password yes" > > i have tried all the options like > > #mysql -u root -h localhost > #mysql -u root -h localhost -p > #mysql -u root -h localhost -p mysql > #mysql -u root -h localhost test -p > #mysql -u root -h localhost test > #mysql -u root > #mysql -u root mysql > > but none of the option is working at all. > > Please any idea how i can change the root password or enter the mysql after > fresh installation
First disalbe the root passwd: To remove password simply type: # mysqladmin -p password '' Enter password: # It will ask the passwd, enter the password you set previously, After that you can run mysql binary. I will not show any error messages and you can play with mysql. # mysql Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 22 to server version: 3.23.54-log Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql> thanks --mathan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]