MySQL 8 Your password does not satisfy the current policy requirements

When transferring a website from one Cpanel server to another server running MySQL 8, I got the following error message Cpanel::Exception::Database::Error/(XID u99as8) The system received an error from the “MySQL” database “mysql”: 1819 (Your password does not satisfy the current policy requirements) The error is due to validate_password component. https://dev.mysql.com/doc/mysql-secure-deployment-guide/8.0/en/secure-deployment-password-validation.html Method 1 Edit mysql configuration … Read more

Change MySQL root password in Webuzo

Webuzo stores MySQL root password in file /var/webuzo/my.conf If you changed MySQL/MariaDB root password outside of Webuzo, you need to update this file. You may also need to modify the file /root/.my.cnf This is only for command line access. To change the MySQL root password on Webuzo, login to the Webuzo control panel at https://your-server-ip:2005/ … Read more

Change MariaDB user password

MariaDB

To change the MariaDB root password, log in to MySQL as the user root mysql -u root -p Enter your current password when prompted. Use the following command to change the root password SET PASSWORD FOR ‘root’@’localhost’ = PASSWORD(‘NEW_PW_HERE’); Replace NEW_PW_HERE with your new MySQL root password. Change a user password SET PASSWORD FOR ‘USER_HERE’@’localhost’ … Read more

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.* TO USER_NAME@’localhost’ IDENTIFIED BY ‘PASSWORD’; In the above SQL statement DB_NAME = name of the database to which you need to give read-only access. USER_NAME = username of the read-only user PASSWORD = … Read more

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] [Server] /usr/sbin/mysqld (mysqld 8.0.29-0ubuntu0.20.04.3) starting as process 265880 [System] [MY-013576] [InnoDB] InnoDB initialization has started. [System] [MY-013577] [InnoDB] InnoDB initialization has ended. [ERROR] [MY-011292] [Server] Plugin mysqlx reported: ‘Preparation of I/O interfaces failed, … Read more

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: rpmts_HdrFromFdno: Header V4 RSA/SHA256 Signature, key ID 3a79bd29: NOKEY Retrieving key from file:///etc/pki/rpm-gpg/RPM-GPG-KEY-mysql The GPG keys listed for the “MySQL 5.7 Community Server” repository are already installed but they are not correct for … Read more

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 and install MySQL repository rpm -ivh http://repo.mysql.com/mysql-community-release-el7-5.noarch.rpm Next, you can install the MySQL server by running the command yum install mysql-community-server Enable MySQL to start on boot systemctl enable mysqld Start MySQL with … Read more

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 [~]$ mysql new_db < wordpress-2021-12-19-b51f8a6.sql ERROR 1071 (42000) at line 745 in file: 'wordpress-2021-12-19-b51f8a6.sql': Specified key was too long; max key length is 767 bytes user@host [~]$ MySQL version 5.6 and older versions have ... Read more

Disable MySQL Replication on Slave

MySQL MariaDB

To disable MySQL Replication on the Slave server, first, edit MySQL configuration file, usually in /etc/mysql folder, remove entries like server-id = 2 log_bin = /var/log/mysql/mariadb-bin log_bin_index = /var/log/mysql/mariadb-bin.index relay_log = /var/lib/mysql/relay-bin relay_log_index = /var/lib/mysql/relay-bin.index binlog_format=row Also, remove any entries starting with master- replicate- Stop slave with command STOP SLAVE; Stop replication with RESET SLAVE; … Read more

MySQL ERROR 1114 (HY000) at line 2137: The table ‘X’ is full

MySQL MariaDB

When restoring a MySQL database, I get the following error root@localhost:~# mysql -u sok_user -p’serverok123′ sok_db < parkingcupid.sql ERROR 1114 (HY000) at line 2137: The table 'field_data_field_monthly_price' is full root@localhost:~ How to fix ERROR 1114 (HY000) table is full? First, check if the disk on the server is full. df -h In my case server ... Read more