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

[Dirk Estenfeld]

Michael,

no unfortunately it is not only a display error. I double checked this.
Additional to the server in my last post I installed a new server also with 5208R and I have the same issue with this server.
I create a MySQL database in the GUI.
- database created
- user created
- user have no access to the database :(

Regards,
Dirk



-----------------------------------------------
Black Point Arts Internet Solutions GmbH - Hanauer Landstrasse 423a - 60314 Frankfurt

-----------------------------------------------
-----Ursprüngliche Nachricht-----
Von: blueonyx-bounces at mail.blueonyx.it [mailto:blueonyx-bounces at mail.blueonyx.it] Im Auftrag von Michael Stauber
Gesendet: Freitag, 7. November 2014 00:39
An: BlueOnyx General Mailing List
Betreff: [BlueOnyx:16425] Re: 5208R - Adding mysql Database to a site

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
_______________________________________________
Blueonyx mailing list
Blueonyx at mail.blueonyx.it
http://mail.blueonyx.it/mailman/listinfo/blueonyx