Too many connections for neutron-db-manage [MySQL] While finalizing the installation of neutron on controller node, the operation to populate the database failed with Too many connections...
The GPG keys listed for the “MySQL 8.0 Community Server” repository are already installed [Fix] Well, I got this error message “The GPG keys listed for the MySQL 8.0 Community Server repository are already installed but...
Public Key Retrieval is not allowed – WSO2 MySQL Error I have been using WSO2 API Manager for almost a year to easily and securely expose APIs to both internal...
Error using GRANT with IDENTIFIED by password in MySQL Question: I have been using IDENTIFIED BY ‘password’ along with GRANT statement for years in many MySQL versions. However, the...
Error Access denied need PROCESS privilege [MySQL] I was trying to back up the database using the MySQL dump command, however, the command failed with an error...
Communications link failure Exception – WSO2 with MySQL [Fix] In this tutorial, we will discuss how to fix the communication link failure exception that occurs while integrating WSO2 with...
Configure WSO2 API Manager with MySQL Database In continuation to our previous article on “Installation of WSO2 API Manager on CentOS“, today we will discuss configuring WSO2...
Install MySQLnd extension for PHP 7.2.3 on PPC64LE with CentOS 7 I had installed PHP from source on PPC64LE with CentOS. I had enabled the MySQLi extension during configure options. For...
Error Cannot find OpenSSL’s [PHP Extension mysqlnd] While installing mysqlnd PHP extension, and when the configure script is executed, I encountered the error – Cannot find OpenSSL...
Access denied for user ‘root’@’localhost’ after installing MySQL [Fix] I Installed MySQL server (MariaDB 8.0) on my CentOS 7 using yum. Once started the service and when I tried...
mysqldump error access denied while using LOCK TABLES [Solved] Question: I have been using mysqldump to take a backup of my website. Today the command failed to execute with an...
Can’t exec mysql_config: No such file or directory at Makefile.PL [Fix] If you are getting an error “Can’t exec mysql_config: No such file or directory at Makefile.PL”, then here’s how you...
How to redirect output of MySQL source command to Log file? Here’s a question from one of our regular reader Mr. Waseem. He wants to know how to redirect output of...
Why mysql user has bash shell in /etc/passwd? If you install MySQL on Linux, then a new user account called ‘mysql‘ will be created for running mysqld service....
Secure WordPress MySQL database with restricted privileges Since hacking is on the rise and we have seen in recent times many WordPress websites are getting hacked daily, it...
ImportError: No module named MySQLdb [Solved] Question: My Python script failed with an error message “ImportError: No module named MySQLdb” while performing MySQL operation. Here’s the complete...
How to Disable Secure_file_priv option in MySQL – Linux If you are getting an error “The MySQL server is running with the secure_file_priv option so it cannot execute this...
How to disable MySQL Password Validation plugin I had recently Installed MySQL v5.7 on Debian 8 Jessie. After the successful installation of MySQL, to improve the security of...
How to update GPG key for MySQL APT repository on Debian/Ubuntu? If you are getting an error “GPG error and Duplicate sources.list” while configuring MySQL repository for installing MySQL server version...