Mysql root

[ircman]

What is the Mysql root password set for ?

Because when i try to login as root it say access denied.

And when installing DA I did not chose the password for it

Cedric

 

[ProWebUK]

cat /usr/local/directadmin/scripts/setup.txt

Chris

 

[ircman]

I still get this:

[14:34:47]:/home/ircman #mysql -u da_admin -p
Enter password:
ERROR 1045: Access denied for user: 'da_admin@localhost' (Using password: YES)



Cedric

 

[ircman]

Ok fixed i found the problem.

Cedric

 

[itman21]

Hi, I have the same as below.

[root@server root]# mysql -u da_admin -p
Enter password:
ERROR 1045: Access denied for user: 'da_admin@localhost' (Using password: YES)
[root@server root]#

now, I used below in setup.txt

mysql=******
mysqluser=da_admin
adminname=admin
adminpass=******

but it still returns above error. In DA installation, I resinstalled DA onto existing DA. Will this be the cause ? But login phpMyAdmin using da_admin and **** is okay.

How do I get this straightened out?

Thanks

SUn Joo

 

[ProWebUK]

Apart from step 1 replace any instances of root with da_admin

(use the unix guide not windows aswell!)

Chris

 

[blacknight]

MySQL expects "root" NOT "da_admin"

 

[ProWebUK]

MySQL expects "root" NOT "da_admin"

A DA install sets root as da_admin as far as i'm aware - and that is what you use.

 

[DirectAdmin Support]

Hello,

There is still a "root" mysql user. The password for "root" is defined as "mysql=" in the setup.txt. "da_admin" is essentially root and has it's password defined as "adminpass=" in the setup.txt. To confirm, just have a look in /usr/local/directadmin/conf/mysql.conf

John

 

[Stormbox]

Hi,
I have just install DA with Cpanel running on it.
but somehow i'm not able to login to mysql
trying new password (setup.txt) or the old password i set using cpanel,
they are not able to access.

please advised.