2009/12/8 Bharath Kumar <[email protected]> > I have configured mysql in RHEL5. service mysqld is fine. When I tried to > create a database, it shows me the following error : > > [r...@mail ~]# mysqladmin -u root --password mypasswd > Enter password: (the same password typed) > mysqladmin: connect to server at 'localhost' failed > error: 'Access denied for user 'root'@'localhost' (using password: YES)' > > There is a problem sometimes when you install it for the first time. What you have to do then is start the MySQL daemon in safe mode. Follow the following steps 1. Stop the Mysql service $ /etc/init.d/mysql stop 2. Start MySQL daemon in safe mode $ mysqld_safe --skip-grant-tables 3. Now login to mysql with root user with NO password $mysql -u root 4. Now you will get the mysql prompt, and can alter the users in the mysql database as u please
NOTE: This is a workaround if you cannot recover the password otherwise -- Thanks & Regards Varrun Ramani Amrita University '10 Web: varrunr.wordpress.com _______________________________________________ To unsubscribe, email [email protected] with "unsubscribe <password> <address>" in the subject or body of the message. http://www.ae.iitm.ac.in/mailman/listinfo/ilugc
