Using the MySQL database on the MSS
The MySQL database is pre-integrated into the My sCool Server and is read to use for teaching database design and related programming.
MySQL version
The My sCool Server ships with MySQL Community Server 5.6.36.
MySQL administration
A computer laboratory admin or a teacher may start using it by setting up student accounts via the phpMyAdmin web administration console.
Web based
It is accessible over the local network via a browser at the following address -
http://{server|<serverip>}:81/phpmyadminIt can also be invoked directly via Applications -> Programming -> phpMyAdmin on any MSS client.
Detailed documentation for usage of phpMyAdmin is accessible by clicking on the "?" icon in the menu accessible after login -
Via the Terminal
Alternatively one may create a Remmina session into the server followed by typing in a Terminal -
mysql -u root -P 33306 -h server -p
Default password for root user is myskool.
It is highly recommended that this be reset to something secure and access should only be kept with the lab admin or a teacher.
User access
Once the users have been created they may access the MySQL server by using the below methods -
Via the Browser
It is accessible over the local network via a browser at the following address -
http://{server|<serverip>}:81/phpmyadminIt can also be invoked directly via Applications -> Programming -> phpMyAdmin on any MSS client.
Login with the user credentials created for you by the admin or your teacher.
Via the Terminal
mysql -u <username> -P 33306 -h {server|<serverip>} -pFor example, the user student1 needs to type the following in the terminal followed by the assigned password when prompted -
mysql -u student1 -P 33306 -h server -p
Please note that the above is applicable to MSS systems shipped post March, 2021. To have this feature activated on systems shipped prior to March, 2021, do contact support.
Related Articles
Teaching Python programming using the MSS
Python programming on the MSS Programming in Python can be taught on the My sCool Server right out-of-the-box. It comes pre-installed with Python 2.7.x and Python 3.6.x. You may teach or practise via one of the following tools - Terminal IDLE ...Can the MSS be built on a Raspberry Pi or can a RPi be used as a client system?
Yes, surely, the My sCool Server can be built on a Raspberry Pi. It is a wonderful platform which is a hacker's dream come true and virtually anything is achievable and on a daily basis new limits are being set. The MSS 2.0 platform now supports the ...Are there any recommended publishers or books to effectively teach using the MSS?
The My sCool Server has a very generic design with respect to the software tools packaged into it. We have found it to be well equipped and supportive of the instructions given in computer subject books prescribed by various state boards such as that ...Do I need to learn anything additional to start using the server?
No, once the server is connected to the network and all systems have been booted over the network, the experience of the desktop environment is almost the same as that detailed in most of the textbooks. Hence to get up and running, the accompanying ...How can the teachers teach using Linux when they are only used to Windows?
The My sCool Server opens the doors for teachers to adopt a more creative and collaborative mode of teaching by shattering age old myths around Linux and introducing them to its user friendly side. Hence, we see this as a great opportunity for the ...