MySQL Operations

Internal

• MariaDB
• MariaDB Configuration
• MySQL

Version

Connect to the database then execute:

SELECT VERSION();

Logs

/var/log/mariadb/

/var/log/mysql/

Data Directory

/var/lib/mysql

Runtime Directory

/var/run/mariadb

Change Root Password

/usr/bin/mysqladmin -u root password 'new-password'
/usr/bin/mysqladmin -u root -h now510.local password 'new-password'

Command Line Client

mysql Command Line Client

Subjects

• MySQL DDL Operations