Service Check

The MySQL service runs on host dcsdb.lnf.infn.it. To check if it's running, there are two ways:

1. Using PHPMyAdmin:
   1. Open the PHPMyAdmin web application at this URL: http://danteweb.lnf.infn.it/phpmyadmin/
   2. Try to access with root user and dcs root password:
      
      Figure 1 - PHPMyAdmin login screen
      
      
   3. If there are no errors, the database service is running properly; otherwise, try to check service with command line client (it could be an apache web server problem); 
      
      
2. Using command line client:
   1. Access via ssh to dcsdb.lnf.infn.it as dante user;
      
      

   2. run mysql client with following command:

      [dante@danteweb ~]$ mysql -u root -p

      And enter dcs root password:
      

      Figure 2 - MySQL client output after login
      
      
   3. If the server respond like the previous image (Figure 2), the service is running properly. You can exit with the quit command on mysql client terminal; otherwise, try to reboot mysql service;

Service Stop

 WARNING: Many control system programs relies on this service. BE CAREFUL WHEN STOPPING THIS SERVICE 

To stop MySQL service, run the following command as root user:

[root@danteweb ~]# systemctl stop mariadb.service

Service Start

To start MySQL service, run the following command as root user:

[root@danteweb ~]# systemctl start mariadb.service

Service Restart

To restart MySQL service, run the following command as root user:

[root@danteweb ~]# systemctl restart mariadb.service