single db user for all databases under a domain???

[whilelord]

Hi Everyone,

I am new to Plesk control panel and i wonder something:

How can i set the same user for all my databases under the same domain? I am now planning to move my existing website from another hosting company which uses Ensim and i have this problem right now. How can i set the same db user for all databases under the same domain?

Please help me.

Thanks!

 

[pedropadron]

hello there

first of all, make sure that your domain limits allow you to create more than one database

then you can access Database Management
create a new user, and after that you can create a database assigned to him

to create another database under the same user, you can always access Database Management again and click on the username you have created. then you can create another database

you can also login to your dbwebadmin and create another database, if your domain limits are ok

hope it helps
sorry for my bad english

Pedro Padron

 

[jspilon]

Originally posted by pedropadron
hello there

first of all, make sure that your domain limits allow you to create more than one database

then you can access Database Management
create a new user, and after that you can create a database assigned to him

to create another database under the same user, you can always access Database Management again and click on the username you have created. then you can create another database

you can also login to your dbwebadmin and create another database, if your domain limits are ok

hope it helps
sorry for my bad english

Pedro Padron

Pedro which version of plesk are you using ?

Cause I have 7.5.4 and there is no such things as

domain->db->user->databases

its

domain->db->database->users

 

[jspilon]

Originally posted by whilelord
Hi Everyone,

I am new to Plesk control panel and i wonder something:

How can i set the same user for all my databases under the same domain? I am now planning to move my existing website from another hosting company which uses Ensim and i have this problem right now. How can i set the same db user for all databases under the same domain?

Please help me.

Thanks!

You can achieve that by granting access to the user through mysql directly... see mysql.org documentation

 

[whilelord]

Thanks for the answers.

I use Plesk 7.5.4 and i can access to users of a db only:

domain > databases > db users

For each new db, i have to create a new db user by clicking "add new db user" under new database.

jspilon, you have mentioned that i need to grant that user to access all databases. To do this, i need to login to mysql admin with root user, am i wrong? How can i know my root user password?

Thanks!