On a MySQL server, the error log keeps getting the following error message 221024 17:50:03 InnoDB: ERROR: the age of the last checkpoint is X, InnoDB: which exceeds the log group capacity 9433498. InnoDB: If you are using big BLOB or TEXT rows, you must set the InnoDB: combined size of log files at least … Read more
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
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
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
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
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
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
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
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
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
To export a MySQL database table as an XML document, you can use mysqldump command like mysqldump DB_NAME TABLE_NAME –xml phpMyAdmin table export feature also gives the option to save Data in multiple formats. Back to MySQL
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