[BlueOnyx:16425] Re: 5208R - Adding mysql Database to a site

[Michael Stauber]

Hi Dirk,

Ok, let us look at the logfile:

CREATE DATABASE `vsite_uBGeUik_db`;
GRANT SELECT, INSERT, UPDATE, DELETE, FILE, CREATE, DROP, INDEX, ALTER,
CREATE TEMPORARY TABLES, CREATE VIEW, SHOW VIEW, CREATE ROUTINE, ALTER
ROUTINE, EXECUTE ON `vsite_uBGeUik_db`.* TO `vsite_uBGeUik`@`localhost`;
GRANT USAGE ON * . * TO `vsite_uBGeUik`@`localhost` IDENTIFIED BY
\'QUkx4cx\' WITH MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0
MAX_UPDATES_PER_HOUR 0;
FLUSH PRIVILEGES;

Now that looks perfect to me.

> Database is created
> User is created
> 
> But User have no rights for its database:
> 
> Benutzer mit Zugriff auf "vsite_uBGeUik_db"  
> root  127.0.0.1 global  ALL PRIVILEGES   Ja  Rechte ändern Rechte ändern 
> root  localhost global  ALL PRIVILEGES   Ja  Rechte ändern Rechte ändern 
> root  localhost.localdomain global  ALL PRIVILEGES   Ja  Rechte ändern Rechte ändern

Could this just be a display problem of phpMyAdmin?

Please do this: Login to the GUI as "admin". Go to Vsite management.
Click on the Vsite in question. Then under "Programs" click
"phpMyAdmin". That will log you in to the DB of that Vsite with the
login credentials of the Vsite. That way you can see directly what the
siteAdmin would see if he's logged in directly.

The "phpMyAdmin" now works with different privileges. Under "Server
Management" and "Personal Profile" admin or systemAdministrators use it
with full access. Under "Vsite Management" it now uses the privileges of
the Vsite instead.

-- 
With best regards

Michael Stauber