Error connecting to MySQL: Access denied for user 'da_admin'@'localhost'

I don't know now:confused:

but i can login to phpmyadmin

or use command

mysql -uda_admin -p
 
Last edited:
but i can login to phpmyadmin

or use command

mysql -uda_admin -p
Click to expand...
Do you mean "cant" ?

If you know the correct info to login you need to ensure it's the same as what you see here; /usr/local/directadmin/conf/mysql.conf

If you don't know the login info you need to reset it and update the mysql.conf file
 
im pulling my hair out...

I get this error:
Error connecting to MySQL: Access denied for user 'da_admin'@'localhost' (using password: NO)

on the MySQL management screen

Ive followed the tutorial many times (http://help.directadmin.com/item.php?id=45) and I can get into phpMyAdmin as da_admin perfectly. ive set the password to mysql.conf and still nothing...

I've done that tutorial like over 5-6 times and it isnt helping. can someone help me?
 
No one knows the solution because its "using password: NO" ?
 
cat /usr/local/directadmin/conf/mysql.conf

copy the password listed, and USE the password when attempting to connect to mysql.
 
Then just reset the mysql root password. There are guides on mysql.com how to do it.
 
daveyw said:
SSH based;

Then hit enter and write the MySQL pass listed in '/usr/local/directadmin/conf/mysql.conf'.
Click to expand...


password exists in .conf file and da_admin is set in system with the same password.

Error connecting to MySQL: Access denied for user 'da_admin'@'localhost' (using password: NO)
 
Last edited:
Then the script calling it is not set to use a password. Fix it.
 
Where are you trying to connect to MySQL?
With a PHP script (or something else) or what?

It seems (many times told) that the script you are using isn't using any password or isn't set.

Check the config files or something where the MySQL settings are listed if you filled in any MySQL login information.
 
daveyw said:
Where are you trying to connect to MySQL?
With a PHP script (or something else) or what?

It seems (many times told) that the script you are using isn't using any password or isn't set.

Check the config files or something where the MySQL settings are listed if you filled in any MySQL login information.
Click to expand...

what is "/usr/local/directadmin/conf/mysql.conf" for ??

actually I'm talking about DirectAdmin as talked before.
 
Its used for the database creation and deletion with the database manager in directadmin.
 
scsi said:
Its used for the database creation and deletion with the database manager in directadmin.
Click to expand...

I think you can't understand what I say.
Let me explain well :

In my new server's DirectAdmin , in MySQL related sections , there is an error I said before :

Code: 
Error connecting to MySQL:
Access denied for user 'da_admin'@'localhost' (using password: [B]NO[/B])

(focus on "NO")

Password is set in /usr/local/directadmin/conf/mysql.conf

Code: 
user=da_admin
passwd=[I]MYPASSWORD[/I]

da_admin user is created and can login with the MYPASSWORD

What's the problem ?
 
Where exactly do you get the MySQL error message?
In directadmin self (domain.tld:2222) or with a script running on a directadmin box?
 
You must log in or register to reply here.
Back
Top