Why MySQL tweaking? We all need fast, reliable and secure environment for our online space. Almost all websites has its own databases to store its data. MySQL is one of the most widely using relational database service to manage user…
MySql
How to know the MySQL uptime from commandline – 3 Methods
MySQL uptime. In some situations, we need to check the uptime for MySQL in your server. We can not afford the downtime of a database engine. As a system engineer you must know the linux command-line options to find the…
Managing MySQL database backup
How to create/restore MySQL databases’ dump/backup of all the databases? Yes!! this is an important section in MySQL administration, and every Linux SysAdmins should know about it. Because, creating backups are such an important task for a SysAdmin. In MySQL, the…
How to enable remote MySQL for an IP address on a cPanel server via CSF
Enable remote mysql In CSF, there is an option to allow IP address in a file which is ‘csf.allow’ that allows connections from external. Please do follow the steps here for enabling remote MySQL for an IP address on a…
How to enable MySQLi extension on web-server
How to enable MySQLi? Before going to enable it on the server, I will share some ideas about MySQLi. Then, I should explain how we can enable MySQLi on a cpanel server and How we can check if MySQLi is already enabled or…
How to change the database user password – cPanel?
Changing the database user password using bash script? Change the database user password, need simple solution!! The MySQL community has depreciated “old_passwords” option since MySQL 5.6 version. So we won’t be able to recollect the password from an old password…
How to change default time zone in MySQL?
Is it possible to change the time zone in MySQL? Yes we can change the default time zone in MySQL via command-line. We can’t change the time zone for a single DB, it’s a global change. To change this feature, you must…