Welcome to WebmasterWorld Guest from 3.92.28.84

Forum Moderators: open

Message Too Old, No Replies

How do you add an extra user to mysql using plesk?

Plesk - adding an extra user to mysql

     
10:50 am on Dec 15, 2007 (gmt 0)

Full Member

10+ Year Member

joined:Mar 7, 2003
posts:301
votes: 0


Using PLESK:
I have the databases and users-
mysite_data1 with user mysite_user1
mysite_data2 with user mysite_user2

I would like to add the user mysite_user2 to the database mysite_data1
When I try to add the user mysite_user2 to mysite_data1 it tells me the user already exists.

Any ideas?

9:16 pm on Dec 18, 2007 (gmt 0)

Senior Member

WebmasterWorld Senior Member 10+ Year Member

joined:Feb 27, 2001
posts: 2548
votes: 0


Instead of adding the user you need to grant them permissions to the database you want them to have permissions to. Not sure how to do this in plesk.
2:48 am on Dec 24, 2007 (gmt 0)

Full Member

10+ Year Member

joined:Mar 7, 2003
posts:301
votes: 0


Any ideas how to grant these permissions? I've hear their are some scripts you can run but haven't found them...

Thanks