Your server is working very slowly, making your websites hosted on your server work very slowly like a snail. The culprit? MySQL is greedily …
Optimizing MySQL/MariaDB RAM Usage: Resource Efficiency Guide Read More »
Binary log MySQL’s Official website defines the binary log as follows: The binary log contains “events” that describe database changes such as table creation …
Why does the database crash!? What can we do if it does? Database corruption can be due to many scenarios, like when a query …
Ever came across an error like these: Notice: SQL safe mode in effect – ignoring host/user/password information in [path]/adodb-mysql.inc.php on line 343 mysql_connect(): SQL …
You can view the MySQL root password in the file /root/.my.cnf. # cat /root/.my.cnf [client] pass=”sdd568c~M” user=root Want to reset the root password for …
Error #1 “Starting MySQL. ERROR! Manager of pid-file quit without updating file.” Solution: If you’re getting the above error while starting mysql, check the …
