Access denied for user da_admin

luizccm

luizccm

Verified User
Joined
Oct 24, 2004
Messages
41
Location
Brazil, Brasilia D.F
Hello,
I reinstalled directadmin, but I preserved the folder mysql where has all the banks. After of this process, I do not manage to create no bank and receive the message that follows below. Try to follow the procedure informed to link below, running a file with the commands, but I receive the information that (Grant: command not found). Already I also ran the command
(mysql -uda_admin -p) but I receive the message (ERROR 1045 (28000): Access denied is user 'da_admin'@'localhost' (using password: YES)). Am informing the password that consists in the file mysql.conf
Thanks,
Luiz:(

http://help.directadmin.com/item.php?id=45

Error connecting to MySQL: Access denied for user 'da_admin'@'localhost' (using password: YES)
 
When are you running the command "(mysql -uda_admin -p)"

That is incorrect, you should be running "mysql -uroot -p" per the instructions.
 
zEitEr said:
I do not see anything bad in using da_admin user. It already has all superuser privileges.

@luizccm

Perhaps, you need to set da_user's password using any guide, that you can find in internet. E.x. http://www.cyberciti.biz/faq/mysql-change-root-password/

Than you should put correct password for da_admin in /usr/local/directadmin/conf/mysql.conf
Click to expand...

The directions he posted (http://help.directadmin.com/item.php?id=45) are exactly how to reset the root and the da_admin passwords. ;)
 
Hello,
thank you very much by the orientations. I did a new installation of rirectadmin, with a new database, and the problem was solved. I migrated the old banks for the new folder of mysql. The problem was inside the folder of mysql old. When it changed returned the old folder of mysql the problem returned as well.
Thanks,
Luiz:)
 
That is because when you copy the old mysql database table to the new server/installation, it overwrites the existing passwords. So you need to reset the passwords.

It could also be that the mysql table is corrupt/missing.

How are you migrating the databases?
 
Hello,
I simply created the database with the same name of antibo, I accessed the old through SSH, gave the command cp -R *.* /var/lib/mysql/topgyn_xxxx , inside the folder of the old bank and copied into of the folder of the bank new, preserving only the file (db.opt) of the bank new. Is this correct procedure?
Thanks,
Luiz:confused:
 
You must log in or register to reply here.
Back
Top