First enable the MySQL slow query log in the MySQL configuration file my.cnf CentOS/RHEL Based [cc lang=”bash”]vi /etc/my.cnf[/cc] Debian/Ubuntu Based [cc lang=”bash”]vi /etc/mysql/my.cnf[/cc] Add the records below at the end of the [mysqld] section: [cc lang=”bash”]slow_query_log = 1 log-slow-queries = /var/log/mysql-slow.log long_query_time = 1[/cc] Create slow log file [cc lang=”bash”]# touch /var/log/mysql-slow.log # chown mysql:mysql ..
Category : Database
First update the server. [cc lang=”bash”]yum update -y ; yum upgrade -y[/cc] Install MariaDB and start the server (as root) yum install mariadb-server [cc lang=”bash”]systemctl start mariadb[/cc] To check MariaDB status [cc lang=”bash”]systemctl status mariadb[/cc] The output should be like this [cc lang=”bash”]Dec 01 19:06:20 centos-512mb-sfo2-01 systemd[1]: Started MariaDB database server.[/cc] To enable MariaDB on ..
First go to custombuild directory [cc lang=”bash”]cd /usr/local/directadmin/custombuild[/cc] Set option.conf by running this command [cc lang=”bash”]./build set mariadb 10.2 ./build set mysql_inst mariadb[/cc] Build MariaDB [cc lang=”bash”]./build ma..
Recently, there are with the Directadmin custombuild for MySQL. Below are an example of the error : Downloading mysql/MySQL-shared-5.6.38-1..x86_64.rpm… –2018-03-02 18:46:09– http://69.162.69.58/services/custombuild/all/mysql/5.6/5.6.38/64-bit/MySQL-shared-5.6.38-1..x86_64.rpm Connecting to 69.162.69.58:80… connected. HTTP request sent, awaiting response… 404 Not Found 2018-03-02 18:46:09 ERROR 404: Not Found. Downloaded file /usr/local/directadmin/custombuild/mysql/MySQL-shared-5.6.38-1..x86_64.rpm does not exist or is empty after download cwd is: /usr/local/directadmin/custombuild Fileserver ..
First stop the mysql service [cc lang=”bash”]service mysqld stop or systemctl mysqld stop[/cc] Start mysql with safe mode [cc lang=”bash”]sudo mysqld_safe –skip-grant-tables[/cc] Log into MySQL as root: [cc lang=”bash”]mysql -u root[/cc] Change to the mysql database, which handles the settings for MySQL itself: [cc lang=”bash”]use mysql;[/cc] Update the password for the root user: [cc lang=”bash”]update ..
Ticket Example : PHB-634-40172 Firstly, SSH into the server and check the error logs by typing tail -f /var/log/httpd/domains/mxm.com.my.error.log tail -f /var/log/httpd/domains/mxm.com.my.log Next, find the database username and password so that we are able to go into the selected domain databases. Execute the command below: [root@MXM-SG-SmartLite ~]# cat /usr/local/directadmin/conf/mysql.conf You will find the result below ..