MySQL Cluster

MySQL Cluster

MariaDB Replication MariaDB galera cluster https://www.percona.com/software/mysql-database/percona-xtradb-cluster Disable MySQL Replication on Slave

MySQL

How to Reset Root Password in MySQL 8.0

If you forget the MySQL root password on MySQL 8.0 server, you can follow the instruction here to reset the

MySQL

MySQL 8 server requested authentication method unknown to the client

On a server running MySQL 8 and PHP 7.3, I get the following error [email protected]:~$ php 1.php PHP Warning: mysqli_connect():

MySQL

How to rename a MySQL database table

To rename a MySQL database table, login to phpMyAdmin or MySQL command line, then select the database, run following SQL

MySQL

Repair MySQL database with mysqlcheck

To check and repair all databases in a database run Forcefully optimize all tables, automatically fixing table errors that may

MySQL Unknown collation: ‘utf8mb4_0900_ai_ci’

MySQL Unknown collation: ‘utf8mb4_0900_ai_ci’

When restoring a MySQL backup taken on MySQL 8 server, i get following error To fix this error, open the

MySQL

How to Install MySQL 5.7 on Amazon Linux

Amazon Linux 2 come with MariaDB by default. To install MySQL 5.7, install repository with Install MySQL 5.7 with Set

MySQL

MySQL Your password does not satisfy the current policy requirements

When i try to create MySQL user on a server, i get following error This is due to MySQL validate

Change MySQL user password

Change MySQL user password

To change the password for a MySQL user, run Or via SQL See MySQL

MySQL MariaDB

MySQL Install

How to Install MySQL 5.7 on Oracle Linux 7

MySQL

Reset MySQL root password on Bitnami server

To reset MySQL root password on Bitnami server, first check MySQL server version you are running. Create a file Add

MariaDB Change Open Files Limit

MariaDB Change Open Files Limit

When using systemctl, you can set value for open_files_limit in my.cnf file. Default installation of MariaDB 10 have open_files_limit set