Recently on a VPS running Cyberpanel, MariaDB service failed with the error: Failed at step NAMESPACE spawning / bin / sh: Invalid argument For VPS based on the openvz that are using old kernel you need to edit the service file to fix the problem:...
Recently encountered a strange issue on client VPS that MySQL connections were working only when using localhost and not with 127.0.0.1 This was due to the fact that the client had enabled skip_name_resolve in his my.cnf file which...
By far MySQL is the most popular Relational database management system and knowing which MySQL version you are running can be important in some situations. Here are different ways to check the version of the MySQL server installed on your WHM/...
Here is how to check MySQL databases for malware: Open up PHPMyAdminLook for anything ‘weird’ It’s that simple. What’s ‘weird’ you ask? Well, anything that’s ‘not supposed to be in the database’...
A common occurrence I have noticed in MySQL apps is that MD5 values are stored as 32 byte values rather than 16. Just to ‘rehash’, an MD5 value is a 16 byte hexadecimal value, typically used as a unique fixed-length signature of a...
Running a DELETE FROM table query in a database with millions of records would lock the table and cause the website to halt. This is where LIMIT clause comes in handy. The following query will only delete the first 1000 rows that match: DELETE FROM...
To change MySQL root password in CyberPanel we need to update it’s configuration. CyberPanel stores MySQL root password into two files: /etc/cyberpanel/mysqlPassword/usr/local/CyberCP/CyberCP/settings.py mysqlPassword File contains the MySQL...
mysqldump command line tool is without doubt the most well known way to backup a MySQL database or multiple databases.
mysqladmin is a command line tool that allows you to do administrative tasks in MySQL without actually login to the MySQL console.
Recently I did security and pen-testing assessment of a web application written entirely in PHP, and some of the biggest issues I’ve come along were in-code vulnerabilities to 💉 SQL injections. To fix this, I recommended using prepared...