Using MySQL/MariaDB

Start/Stop MySQL/MariaDB service

[RHEL] for MariaDB:

service mariadb start
service mariadb stop

[RHEL] for MySQL:

service mysqld start
service mysqld stop

[SLES] and [Ubuntu]:

service mysql start
service mysql stop

[SLE15] :

systemctl start mariadb
systemctl stop mariadb

Basic MySQL/MariaDB commands

Refer to https://www.mariadb.org/ for the latest documentation.

  • Using mysql, connect to the xcat database:

    mysql -u root -p
    
  • List the hosts and users which managed by this xcat MN:

    MariaDB> SELECT host, user FROM mysql.user;
    
  • List the databases:

    MariaDB> SHOW DATABASES;
    
  • Use the xcatdb:

    MariaDB> use xcatdb;
    
  • List all the tables:

    MariaDB [xcatdb]> SHOW TABLES;
    
  • Show the entries in the nodelist table:

    MariaDB [xcatdb]> select * from nodelist;
    
  • Quit mysql:

    MariaDB [xcatdb]> quit;