- Updated February 12, 2025 MySQL: Recover Crashed innodb tables How Innodb crash can happen ? – Innodb table can crash if there is power lose for your dedicated server. – Force shutdown of MySQL service can end up in…
- Updated September 11, 2022 MariaDB Upgrade from 10.2 to 10.4 [alert] Before starting an upgrade please confirm that you have the backup of MySQL databases and users. Default backup is in the folder /backup/mysql [/alert] Verify if MariaDB 10.2 is…
- Updated March 14, 2022 How to connect MySQL database remotely How to connect MySQL database remotely – Open MySQL port 3306 or whitelist your IP in the firewall – Create remote MySQL user from MySQL manager in CWP * We…
- Updated February 15, 2022 MariaDB Upgrade to the new version [alert] Before starting an upgrade please confirm that you have the backup of MySQL databases and users. Default backup is in the folder /backup/mysql Also, make sure all your scripts/sites…
- Updated December 9, 2020 MariaDB Upgrade from 10.1 to 10.2 [alert] Before starting an upgrade please confirm that you have the backup of MySQL databases and users. Default backup is in the folder /backup/mysql [/alert] Verify if MariaDB 10.1 is…
- Updated June 5, 2019 How to install Adminer Database management Database management in a single PHP file website: https://www.adminer.org/ 1.Download Adminer from the downloads page cd /usr/local/cwpsrv/var/services/ mkdir adm;cd adm https://github.com/vrana/adminer/releases/download/v4.7.1/adminer-4.7.1.php mv adminer-4.7.1.php adminer.php cd /usr/local/cwpsrv/var/services/ chown cwpsvc:cwpsvc -R adm…
- Updated May 3, 2019 MySQL Error: Too many connections Error on the website or in cwp: ERROR 1040 (HY000): Too many connections PHP Warning: mysqli_connect(): (HY000/1040): Too many connections The default value for the maximum permitted number of simultaneous…
- Updated January 21, 2019 MySQL Manager NOT working MySQL Manager in CWP not working issues: – list of databases is not shown – can’t create new database – can’t create new user Most common issues are that you…
- Updated September 20, 2018 MySQL Login details You can find MySQL root password in the file /root/.my.cnf: Example from the ssh/shell cat /root/.my.cnf [client] password=ydVg5g3Wz2FH user=root ** MySQL root password in this case would be ydVg5g3Wz2F Users…
- Updated September 14, 2018 Import / Export MySQL Database How to import or export MySQL database with command line. This is also useful when working with big databases. Export database info file mysqldump DATABASE-NAME > FILE-NAME.sql Export database into…
- Updated October 19, 2022 Remote MySQL with SOCAT socket How to make a remote MySQL server with socket by using SOCAT. Remote MySQL advantages – move MySQL CPU usage from local CWP web server – move MySQL disk IO…
- Updated June 15, 2018 How to reset MySQL root password Instructions for reseting MySQL root password. MySQL root password on the CWP servers can be reset by using cwp scripts, usage: sh /scripts/mysql_pwd_reset or /scripts/mysql_pwd_reset This script will stop MySQL…
- Updated September 15, 2020 How to change MySQL Location How to Safely Change Location of the MySQL Data Directory (partition/disk) Most Used Cases are: – Useful for migration of the MySQL to SSD Disk and to get the best…
- Updated March 15, 2015 How to upgrade MySQL Server How Can I upgrade MySQL server? You can upgrade the MySQL server by using any official tutorial on the internet, its suggested to make a backup of all databases before…