mysql and weird problems

[linkinhost]

hi, i have just installed directadmin and am getting following error with mysql - Error connecting to MySQL: Access denied for user: 'da_admin@localhost' (Using password: YES)

also i dont know if this is related but i get the error Error connecting to MySQL: Access denied for user: 'root@localhost' (Using password: YES) when i try to access mysql via ssh

 

[fusionictnl]

Error connecting to MySQL: Access denied for user: 'da_admin@localhost' (Using password: YES)

Password correct ? check the /var/log/messages when restarting Mysql to see if there's any error.

You can lookup your password: /usr/local/directadmin/conf/mysql.conf (or something in that area )

also i dont know if this is related but i get the error Error connecting to MySQL: Access denied for user: 'root@localhost' (Using password: YES) when i try to access mysql via ssh

User "root" isn't used in DA, so there's no user "root" in MySQL.

 

[linkinhost]

i know their will be no user root, but i did have mysql instaled and working before i installed directadmin so i thought i may still be able to get in that way

 

[linkinhost]

i checked the mysql.conf file as you suggested and it was coreect, and i am still having the same problem - any ideas?

 

[fusionictnl]

check the /var/log/messages when restarting Mysql to see if there's any error.

 

[linkinhost]

no messages relating to mysql in their at all - http://www.linkingames.net/messages - you might see something i dont

 

[jmstacey]

A 404 page

Have you tried these instructions?
http://help.directadmin.com/item.php?id=45
They may be of some help.

Even though DA does not use root there is still a root user as noted in the above instructions.

 

[linkinhost]

that page helped, its working now - thanks for the help all

 

[Turbo M]

none of those commands worked for me.

I have freebsd

 

[Turbo M]

anyone?

 

[jmstacey]

Well.... What exactly are you having trouble with? The exact same problem? Is MySQL running. Can you access mysql and databases in it though phpmyadmin or the command line?

 

[Turbo M]

I actually found someone to help me out that is experienced with this since I have no experience at all.

The problem on the first post on this thread is the exact problem I have and I need to run those commands to fix it. The thing is those commands wouldn't run, seems like the server is setup differently. For example it says "use mysql" and that would be an invalid command but "mysql" would work.