Adding users to MySQL DB

[user1102]

Hi,

I would like to be able to add a user to a mySQL database that already exists on another mySQL database. Right now, I get an error stating that the user already exists and the the process fails.

Please let me know how to do this. I'm trying to migrate a forum database from one system to another and the importer requires that both databases have the same user.


Thanks!

[user1102]

Nervermind.
I found the threads relating to this question.

Although, I can't seem to log-in as "da_admin" with the original password, as is suggested.

[ProWebUK]

it shouldbe your first root password, although if that fails try your latest.

Chris

[FarCry]

da actualy makes up a new root password to mysql...

To get your da_admin password, as root view /usr/local/directadmin/conf/mysql.conf

[DirectAdmin Support]

Also remember that the da_admin user is esentially a root mysql user and that the mysql root password should be stored in /usr/local/directadmin/setup.txt if you havn't already deleted the file.

John

[teedee]

if you havn't already deleted the file.


Should we delete this file ???

TeeDee

[DirectAdmin Support]

Hello,

You can, just be sure that you've recorded all information from it, as it's the only source for getting the mysql root password. The file should be root:root 600, so nobody should be able to read it anyway.


John