From within LJMU
To connect to the universities mySQL database server using SQLyog , first startup the SQLyog application, once opened you will be presented with the make connection screen as follows :
If the connection screens fields are blank then , press the new button and give your connection a name, once done in the mySQL Host Address field enter :
mysql.cms.livjm.ac.uk
In the username and password fields enter your standard university username and your password that you recieved while making your Unix/mySQL account.
Please note that MySQL has it's own username/password system which is different from Windows/Linux.If you dont have a password Contact your technical staff if you are unsure about your account details.
In MySQL each user has their own database, which by convention has the same name as your username. You should type your username into the Databases(s) field, and leave all other fields at there default values.
If you have connected successfully you should now be able to see your default database container, within this you can create new tables or run SQL queries.
Please note that you cannot create new databases only tables.
Should this fail contact the Technical Staff to make sure that you have a MySQL account
Last modified: 04-Dec-08