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

While accessing MySQL in Interworx many of you got this error.

[arunlal@lintechops]# mysql
ERROR 1045 (28000): Access denied for user 'iworx'@'localhost' (using password: NO)

This is due the password was empty on password field /root/.my.cnf

cat /root/.my.cnf 
[client]
user=iworx
password=

Please use the following command to find the password for the user iworx

grep rootdsn /home//interworx/iworx.ini

password should be username:password

iworx:password@unix   >> In this format

Add the password in /root/.my.cnf

cat /root/.my.cnf 
[client]
user=iworx
password=xxxxxxxxx

Now you can able to access the Mysql without any issue.

Post navigation

Leave a Reply