How to create MySQL read only user
To create a MySQL database user with read-only access to a database, use the following command In the above SQL
MySQL Could not create unix socket lock file
When trying to reset MySQL 8 user root password, I got the following error message in the log file (/var/log/mysql/error.log).
MySQL 5.7 Community Server GPG keys already installed but they are not correct
On a CentOS 7 server, when updating software packages with the yum update command, it fails with the following error
How to install MySQL 5.7 on CentOS 7 Server
To install MySQL 5.7 on CentOS 7 server, install the repository import MySQL GPG key with Install MySQL with the
How to install MySQL 5.6 on CentOS 7
CentOS 7 come with MariaDB, a drop-in replacement for MySQL. In some cases, you need to install the Oracle MySQL
MySQL Specified key was too long; max key length is 767 bytes
When restoring a MySQL database, I got the error “Specified key was too long; max key length is 767 bytes”.
How to Install MySQL 5.7 on Oracle Linux 7
Oracle Linux 7 comes with MySQL yum repository pre-installed. By Default MySQL 8 repository is enabled. You can disable MySQL
Can’t create table `catalog_product_relation` (errno: 140 “Wrong create options”)
When I try to restore the MySQL database of a Magento 1.x site on MariaDB 10.3.32 (source MySQL 5.7.36), I
Disable MySQL Replication on Slave
To disable MySQL Replication on the Slave server, first, edit MySQL configuration file, usually in /etc/mysql folder, remove entries like
Export MySQL Database table as an XML Document
To export a MySQL database table as an XML document, you can use mysqldump command like phpMyAdmin table export feature
MySQL show processlist
To see currently running MySQL processes, login to MySQL server, run in MySQL command prompt, run the command To see
MySQL Backup
MySQL Backup mysqldump MySQL backup all databases MySQL Backup using mysqldump Plesk MySQL Daily Backup Script MySQL Backup Tricks Extract