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...
Home » MySQL
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...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...Incompatible with sql_mode=only_full_group_by [Fix]
While migrating a client website from one WHM/cPanel to another WHM/cPanel, I got an SQL error “Incompatible with sql_mode=only_full_group_by“. Below...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...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....Fix Unknown collation utf8mb4_unicode_ci [WP Migration]
Do you get an error Unknown collation utf8mb4_unicode_ci while migrating your WordPress database? No worries, this tutorial will explain how...