Connecting to a MySQL database server

Depending on the authentication method set in config/auth.php configuration file, you will be either presented with the browser’s built-in authentication authentication dialog, or the login screen for MyWebSQL. In either case, you will have to use the credentials that you usually use to connect to the database server, or given to you if you are connecting to someone else’s server.

If you are running the database server on a different port than the default (3306 for MySQL), you will need to edit the ‘config/auth.php’ or ‘config/servers.php’ file in MyWebSQL installation folder and change the line that defines the server name and include the port along with the server name. For example, if your MySQL server is running on port 3307, change the default line into the following to make it work:

For the file ‘config/auth.php’:
define(‘AUTH_SERVER’, ‘localhost:3307’);

For the file ‘config/servers.php’:
$SERVER_LIST = array(
‘Localhost MySQL’ => array(
‘host’ => ‘localhost:3307’,
….

Once successfully authenticated, you will be either shown a list of databases that the connected user has access to, or the main MyWebSQL interface, if there is only one database that the user has access to. If you have selected a database and want to change the database to another one, simply select it from the combo box provided on the main screen with the list of database names. Your session will start using the newly selected database from then on.