Install MariaDB 10.2 on DirectAdmin

by Mohamad Zulfahmy | 27/03/2018 | Linux

First go to custombuild directory

cd /usr/local/directadmin/custombuild

Set option.conf by running this command

./build set mariadb 10.2
./build set mysql_inst mariadb

Build MariaDB

./build mariadb

Reset MySQL Root Password

by Mohamad Zulfahmy | 27/03/2018 | Linux

First stop the mysql service

service mysqld stop
or 
systemctl mysqld stop

Start mysql with safe mode

sudo mysqld_safe --skip-grant-tables

Log into MySQL as root:

mysql -u root

Change to the mysql database, which handles the settings for MySQL itself:

use mysql;

Update the password for the root user:

update user set password=PASSWORD("newpassword") where User='root';

Refresh the MySQL user privileges:

flush privileges;

Exit MySQL:

exit

Restart mysql back and retry to login with new password

mysql -u root -p

Enable Slow Log on MySQL/MariaDB

by Mohamad Zulfahmy | 26/03/2018 | Linux

First enable the MySQL slow query log in the MySQL configuration file my.cnf

CentOS/RHEL Based

vi /etc/my.cnf

Debian/Ubuntu Based

vi /etc/mysql/my.cnf

Add the records below at the end of the **mysqld** section:

[mysqld]
slow_query_log = 1
log-slow-queries = /var/log/mysql-slow.log
long_query_time = 1

Create slow log file

# touch /var/log/mysql-slow.log
# chown mysql:mysql /var/log/mysql-slow.log

Restart MySQL service

CentOS/RHEL

service mysqld restart

Debian/Ubuntu

service mysql restart

If MariaDB installed

service mariadb restart

Tail the slow log file

tail -f /var/log/mysql-slow.log