Same User for all databases

[chunguy]

Hi friends,

I need to use the same User for all databases.

How can I do this?

 

[Aspegic]

Such a useraccount already exists. It's called da_admin. You can find the password in /usr/local/directadmin/conf/mysql.conf
If you want to use another account instead, you can use the da_admin user to modify the privileges of another account to give it access to all database, or create a new account specifically for that purpose (see phpMyAdmin docs on how to modify privileges).

 

[chatwizrd]

I wouldnt suggest using the admin login. Best bet is to create a secondary user with fewer privledges.

 

[Aspegic]

If you mean the da_admin login then I completely agree. It's better not to use the da_admin account for normal database operations. Much better to create a separate useraccount for that purpose.