MySQL

Mysql database replication

by

Moodle MySQL Replication using PHPMyAdmin The phpMyAdmin that is bundled with cPanel doesn’t include user management so the following commands needed to be run to give the replication user the correct permissions: Setting up the Master , add the slave replication user. The IP below is the slave IP. mysql -e “GRANT REPLICATION CLIENT ON … Read more

Mysql Remote access on plesk

by

edit /etc/my.cnf to show the following… Where, * bind-address : local IP address to bind to. If you wish mysql listen on all IPs, don’t use this option. * skip-networking : Don’t listen for TCP/IP connections at all. All interaction with mysqld must be made via Unix sockets. This option is highly recommended for systems … Read more

InnoDB registration as a STORAGE ENGINE failed

by

nano /var/lib/mysql/server.com.err There are two solutions to this particular problem: 1. Restore the my.cnf file to its original state, with an innodb_log_file_size equal to the actual size of the existing InnoDB log files. 2. Rename or move both the ./ib_logfile0 and ./ib_logfile1 files, and then start the MySQL server. The ./ib_logfile0 and ./ib_logfile1 files are … Read more

Delete mysql-bin files safely

by

The file mysql-bin.index keeps a list of all binary logs mysqld has generated and auto-rotated. The mechanisms for cleaning out the binlogs in conjunction with mysql-bin.index are: PURGE BINARY LOGS TO ‘binlogname’; PURGE BINARY LOGS BEFORE ‘datetimestamp’; These will clear all binary logs before the binlog or timestamp you just specified. For example, if you … Read more

Install Mysqli on WHM/cPanel

by

To install mysqli using EachApache: 1. Login to WHM as ‘root’ user. 2. Either search for “EasyApache” or go to Software > EasyApache 3. Scroll down and select a build option (Default) 4. Click Start “Start customizing based on profile” 5. Select the version of Apache and click “Next Step”. 6. Select the version of … Read more

Migration Error Plesk Windows Server

by

Migration check in plesk shows this error: The ‘max_allowed_packet’ parameter on the source database server is 16777216, which is bigger than on the destination server, where it is 1048576 RDP the the server. The file is at C:Program Files (x86)ParallelsPleskDatabasesMySQLDatamy.ini Add this to it: