[BlueOnyx:03389] Re: Shared MySQL - Vsite Deleted
Michael Stauber
mstauber at blueonyx.it
Thu Jan 21 12:56:11 -05 2010
Hi Dr. Blunt,
> ..I build the MySQL database for the WordPress (WP) installs at the
> $ mysql -u root... then I go to the GUI > security > phpMyAdmin >
> [database] > Privileges > and make sure I have the correct settings
> (e.g., GRANT) as I am a complete novice from the COMMAND line.
> Perhaps I am forgetting a step somewhere but I give several sites
> on the same BO access to the same database which in this case had
> 168 tables and 3 million + records.
Sorry, but that cannot be.
If you use the BlueOnyx GUI to create a MySQL database and user for a site,
then - and only THEN - is that MySQL database (and its user) under "GUI
control". And only in that case the GUI will delete this MySQL user and
database if that site is deleted.
It doesn't matter if PHP scripts from other sites are using that same database
or not.
Databases that are created manually (command line or phpMyAdmin) will not get
under "GUI management" all by themselves and therefore are not subjected to
deletion when a site is removed.
--
With best regards
Michael Stauber
More information about the Blueonyx
mailing list