plainblack.com
Username Password
search
Bookmark and Share
Subscribe

Adding a database link

To add a new database link, choose "Databases" from the Admin Console or Toolbar.

The default WebGUI SQL privileges are select, describe and show. These all correspond to the select grant in MySQL. You need to grant your user the privileges in your linked database. For example, to grant privileges to an user of a new MySQL database:

GRANT select ON mydb.table TO newuser IDENTIFIED BY 'password';
flush privileges;

To setup the database, you'll need to specify the DNS. E.g. -

dbi:mysql:www_mywebsite_com:localhost

If an error occurs during connection to the newly linked database, the phrase 'Error' will show in the database list next to the database name. Check the webgui.log file for more details.

Keywords: database mysql

Search | Most Popular | Recent Changes | Wiki Home
© 2018 Plain Black Corporation | All Rights Reserved