Our new MySQL server is mysql.labranet.jamk.fi
Students can create their own mysql user by going to https://mysql.labranet.jamk.fi (only available from LabraNet workstations or over VPN), authenticating with their LabraNet login, and pushing a button. The page then tells you your new mysql password, and you can also reset your password from there if you’ve forgotten it.
If you want to change the password to one of your own liking, or to drop your database, you need to do it with mysql commands.
The mysql server on mysql.labranet.jamk.fi is accessible from student.labranet.jamk.fi, and from LabraNet workstations.
Existing databases on student.labranet.jamk.fi will continue to operate at least for now, but you’re advised to migrate them over to the new server.
LabraNet users can have MySQL database on student server. First step is to login to student server. Once you have logged in, your mysql-database will be created at night 0:00AM.
After 0:00AM, do the following:
[12345@student ~]# more ~/.mysql_instructions.txt
* MySQL password is located there
[12345@student ~]# mysql -u 12345 -p
* MySQL password is asked
Users can only use their MySQL database
mysql> use 12345
If you loose your MySQL-password or accidentaly delete .mysql_instructions.txt file and you can’t remember your password do the following:
SSH to student.labranet.jamk.fi
Type mysqlpasswd, the new password will be generated to your home-folder with filename .mysql_instructions.txt