Skip to content

Latest commit

 

History

History
61 lines (33 loc) · 1.02 KB

mysql_using.rst

File metadata and controls

61 lines (33 loc) · 1.02 KB

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;