Adding users to MySQL DB

user1102

New member
Joined
Nov 27, 2003
Messages
2
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!
 
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.
 
it shouldbe your first root password, although if that fails try your latest.

Chris
 
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
 
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
 
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
 
Back
Top