MySQL Database is not letting me login for the first time with a blank password.
Posted: 2012/04/30 00:06:49
I installed MySQL and MySQL-server and have followed the steps here - http://www.howtoforge.com/installing-apache2-with-php5-and-mysql-support-on-centos-6.0-lamp
The problem I am facing is that when you open it up for the first time it will ask you for a password, which is to be left blank because, of course, it has not been created yet, but when I try to do mysql_secure_installation it doesn't let me by with no password like it should.
Instead I get this:
In order to log into MySQL to secure it, we'll need the current
password for the root user. If you've just installed MySQL, and
you haven't set the root password yet, the password will be blank,
so you should just press enter here.
Enter current password for root (enter for none):
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
I am 99% sure that I never created a password for it before especially considering this is the first time I installed it.
So far I haven't been able to find anything else that could be wrong with it and I have tried to remove all of the files and reinstall them but I can't get every file deleted.
If anyone knows an easy (or not so easy) way to fix this it would be appreciated.
The problem I am facing is that when you open it up for the first time it will ask you for a password, which is to be left blank because, of course, it has not been created yet, but when I try to do mysql_secure_installation it doesn't let me by with no password like it should.
Instead I get this:
In order to log into MySQL to secure it, we'll need the current
password for the root user. If you've just installed MySQL, and
you haven't set the root password yet, the password will be blank,
so you should just press enter here.
Enter current password for root (enter for none):
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
I am 99% sure that I never created a password for it before especially considering this is the first time I installed it.
So far I haven't been able to find anything else that could be wrong with it and I have tried to remove all of the files and reinstall them but I can't get every file deleted.
If anyone knows an easy (or not so easy) way to fix this it would be appreciated.