Username Password
Bookmark and Share

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. -


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
© 2022 Plain Black Corporation | All Rights Reserved