MySQL

MariaDB MySQL 8 MySQL 5.7

To change the password for a MySQL user, run mysqladmin -u user_name_here -p password new_password_here Or … Change MySQL user passwordRead more

When i try to create MySQL user on a server, i get following error mysql> GRANT … MySQL Your password does not satisfy the current policy requirementsRead more

Amazon Linux 2 come with MariaDB by default. To install MySQL 5.7, install repository with sudo … How to Install MySQL 5.7 on Amazon LinuxRead more

When restoring a MySQL 8 database backup on a MariaDB server, I get the following error … MySQL Unknown collation: ‘utf8mb4_0900_ai_ci’Read more

To check and repair all databases in a database run mysqlcheck -A –auto-repair -u root -p … Repair MySQL database with mysqlcheckRead more

To rename a MySQL database table, login to phpMyAdmin or MySQL command line, then select the … How to rename a MySQL database tableRead more

On a server running MySQL 8 and PHP 7.3, I get the following error boby@sok-01:~$ php … MySQL 8 server requested authentication method unknown to the clientRead more

If you forget the MySQL root password on MySQL 8.0 server, you can follow the instruction … How to Reset Root Password in MySQL 8.0Read more

On transferring a Magento website Database running on MySQL 5.7.34 to MariaDB 10.2.39, I get the … Magento catalog_product_relation MySQL ErrorRead more