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.