MySQL on devweb #

For access to MySQL on devweb, please see the guidance on Requesting Access.

If you have requested MySQL access, you'll be given a database with the same name as your university DS username (e.g. xxy12345). You can connect from Linux (Cafe, Linux lab machines or CPU nodes - see Remote Compute) by running mysql -p -h devweb2024.cis.strath.ac.uk $database (where $database is your DS username).

On Windows lab machines, you can use the built-in SSH client to connect to cafe, where you'll be able to run the commands above; to do so, please launch Windows Terminal by clicking on the Start button and typing terminal and choosing the Terminal application. See Remote Compute for more information on connecting to cafe.

Alternatively, you can use the phpMyAdmin web interface to MySQL. Please note you need to use your MySQL password to login to phpMyAdmin, not your university DS password.

Changing your password #

You can change your password using using the following SQL statement (at the mysql prompt, replacing $username with your MySQL username):

ALTER USER $username IDENTIFIED BY 'newpassword';

Accessing MySQL from home / off-campus #

In order to access MySQL off-campus, you need to tunnel your connection via cafe (ssh) as follows (replacing $username with your DS username):

ssh -L 3306:devweb2024.cis.strath.ac.uk:3306 $username@cafe.cis.strath.ac.uk

You'll then by able to connect your local MySQL client or app to localhost:3306, which will be tunnelled to devweb2024 via cafe.

See Remote compute for more details.