mySQL root password?

D

dotdoms

Verified User
Joined
Oct 28, 2006
Messages
45
Hello,

I got 2 problems, while I guess one occurs out of the other...

I had DA - team set up DA on my server (using Debian), but now I don´t know what the mysql root password is. Do they use a standard password? Or if not does there exist any way to reset the root password and DA still not breaking or the current data in the mySQL tables?

Now my primary problem is that I cannot login to the mySQL on my DA-administered server from another server, since it says that my other host isn´t allowed to access the mySQL db on my DA-server... Now basically I would also be pleased to get input on how to allow other servers to access a certain DB on my DA-server (but I fear I need to know about the root password then, don´t I?)

thx in advance,
best regards, dd
 
Password is stored in /usr/local/directadmin/conf/mysql.conf.
 
can´t find it there... can only find that:

mysqlconf=/usr/local/directadmin/conf/mysql.conf

and in that file there is no username "root" but "XXXX"

what would be the vars name for the password? :)


ADDON: tried "XXXX" and was able to change privileges... works fine... thx a lot :)
 
Last edited:
da_admin is created by DA automatically during the installation. It has full privileges and can be consider as "MySQL root".
If you want to have a MySQL user named "root", you should create it by yourself.
 
You must log in or register to reply here.
Back
Top