Linux – ERROR 1045 (28000): Access denied for user ‘root’@’localhost’ (using password: NO)

centoslinuxMySQLPHPUbuntu

So at first I was getting this error when trying to create databases for use in phpmyadmin. ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)

I looked in several places and a buddy of mine told me to just attempt to re install mysql since I just re-installed the server yesterday.

So I decided to re install mysql, and now I can't even run the installer without getting this error: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)

I had also got the 'root'@'localhost' error when trying to install a script with the database I created. This is the error I get when I had tried to install the script:
Running Centos 6

enter image description here

PHP 5.3.3 (Script I am using is Ioncubed, and PHP 5.4, I don't need it).

EDIT:

If you are going to question about why don't I look around first, I have looked around! I ain't having luck finding others who had the type of issue as I did.

EDIT 2:

I successfully installed MySQL now. I felt like going back and giving it another go and the installer went fine. But I still get the root@localhost error provided in the image above. I already checked to make sure the config wasn't magically using "root"@"localhost".

Best Answer

Configuration of the database does use root@localhost, and that password was chosen when you installed it for the first time. It is not the system's root password. MySQL root and system's root are different accounts with possible different passwords.

Try to remember and try to guess it by using mysql -u root -p to try. If no luck, search Google for how to remove MySQL configuration and start anew.

Related Solutions

Linux – thesql start ERROR 1045 (28000): Access denied for user ‘root’@’localhost’ (using password no) in OpenSuse 12.1

maybe you should use systemctl to start the mysql server daemon

sudo systemctl start mysql.service

Also if you want to add the server to the suse standard runlevels you should use:

sudo systemctl enable mysql.service

Next up you must execute mysql_secure_installation as root.

sudo mysql_secure_installation

here you must follow the steps and enter the password for the root mysql user. note that this is not the root user of your linux box.

Now simply use the mysql client. Simply issue

mysql

^^And remember you are on suse. Something sugested like rcscript start would not work because suse is using systemd now.

Thesql how to fix Access denied for user ‘root’@’localhost’

Follow the steps below.

Start the MySQL server instance or daemon with the --skip-grant-tables option (security setting).
```
$ mysqld --skip-grant-tables
```

Execute these statements.

$ mysql -u root mysql
$mysql> UPDATE user SET Password=PASSWORD('my_password') where USER='root';
$mysql> FLUSH PRIVILEGES;

If you face the unknown field Password error above use:

update user set authentication_string=password('my_password') where user='root';

Finally, restart the instance/daemon without the --skip-grant-tables option.
```
$ /etc/init.d/mysql restart
```

You should now be able to connect with your new password.

$ mysql -u root -p

Enter password: my_password

Fix for MySQL “Unable to lock ibdata1” error

sudo mv /usr/local/mysql/data/ibdata1 /usr/local/mysql/data/ibdata1.bak
sudo mv /usr/local/mysql/data/ib_logfile0 /usr/local/mysql/data/ib_logfile0.bak
sudo mv /usr/local/mysql/data/ib_logfile1 /usr/local/mysql/data/ib_logfile1.bak
sudo cp -a /usr/local/mysql/data/ibdata1.bak /usr/local/mysql/data/ibdata1
sudo cp -a /usr/local/mysql/data/ib_logfile0.bak /usr/local/mysql/data/ib_logfile0
sudo cp -a /usr/local/mysql/data/ib_logfile1.bak /usr/local/mysql/data/ib_logfile1
sudo /etc/init.d/mysql restart

Best Answer

Related Solutions

Linux – thesql start ERROR 1045 (28000): Access denied for user ‘root’@’localhost’ (using password no) in OpenSuse 12.1

Thesql how to fix Access denied for user ‘root’@’localhost’

Fix for MySQL “Unable to lock ibdata1” error

Related Question