I need two databases and a single user

[AlbertoPe]

1º Make a database "Prueba" & make user "usuario".

http://img843.imageshack.us/img843/5755/db2d.jpg

2º Make a second database "tabla2" but I can't use the user "Usuario".

http://img521.imageshack.us/img521/8586/db1n.jpg

The problem is that I need (my program) one user and two database.

Why in parallels can't make?

 

[Richard Grevers]

Have you been in to phpMyAdmin as admin and granted privileges over the second database to that user?

 

[bluik]

I think his point was that he pays good money for Parallels so that he does not need to do this on command line or at phpMyAdmin. It has been like this since forver. Some of the unbelievable things in Plesk I guess: a database user cannot "own" more than a single database.

If you do this at phpMyAdmin/mysql client and modify the mysql users table, it probably does not survive a pleskbackup/restore.

 

[AlbertoPe]

Yes bluik, I can make union with phpmyadmin but I think that is 'basic' make this in the Plesk.

Thank you

 

[IgorG]

Please fill detailed request http://forum.parallels.com/showthread.php?t=106113 and I will forward it to developers.

 

[Sergey L]

Hi, this is known feature request. We won't have it in upcoming version (11.0) yet, but should have it the version coming next to it.

 

[Alexey.Plotnitsky]

Since Plesk 11.5, which is in preview stage now,
a database user can access multiple databases. Customers can now create database user accounts. The created accounts can be of two types:

- User accounts which have access to only one particular database.
- Universal user accounts which have access to all databases.

When creating a database, customers can either create a new account for the database or use the existing one. In the earlier Panel versions, when Panel created a database, it also automatically added a database user account for accessing the database.

One can download Plesk 11.5 for evaluation, but it is not for production servers.
The download links are in Plesk 11.5 Preview thread