How to create MySQL read only user
To create a MySQL database user with read-only access to a database, use the following command GRANT SELECT, SHOW VIEW ON DB_NAME.*…
mysql
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). [System] [MY-010116]…
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 message. warning:…
How to install MySQL 5.7 on CentOS 7 Server
To install MySQL 5.7 on CentOS 7 server, install the repository rpm -ivh http://repo.mysql.com/mysql57-community-release-el7.rpm import MySQL GPG key with rpm –import https://repo.mysql.com/RPM-GPG-KEY-mysql-2022…
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 server. Download…
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”. user@host [~]$…
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 8 repository…
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 get the…
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 server-id =…
Export MySQL Database table as an XML Document
To export a MySQL database table as an XML document, you can use mysqldump command like mysqldump DB_NAME TABLE_NAME –xml phpMyAdmin table…
MySQL show processlist
To see currently running MySQL processes, login to MySQL server, run in MySQL command prompt, run the command show processlist; To see…
MySQL Backup
MySQL Backup Backup Services MySQL Backup Tricks MySQL Restore Errors MySQL Backup Errors Back to MySQL