When i type the command # mysqladmin -p password '' > Enter password: > # it asks for password. I don't remember the password any more . So it gives the same message "Access denied for user [EMAIL PROTECTED] using password np"
what to do ----- Original Message ----- From: "mathan" <[EMAIL PROTECTED]> To: "sanjay gupta" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Wednesday, August 13, 2003 4:04 PM Subject: Re: Accessing Mysql after fresh installation > > > 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] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
