MySQL : MySQL80 Service Started and Then Stopped on Windows Server

issue : “The MySQL80 service on Local Computer started and then stopped. Some services stop automatically if they are not in use by other services or programs.”solutions: my.ini config file get HEX characters added to the beginning of the file. This causes the MySQL service to fail when it tries to start. The solution is to remove these HEX characters and then start the service again.1....

Read More

MySQL : mysql_connect(): Too many connections

Issue: mysql_connect(): Too many connections Solutions: directly connect to the mySQL server (via localhost), and perform the query: SET GLOBAL max_connections = 1024; to change the connection limit at runtime (no downtime). make your change permanent, and edit the /etc/mysql/my.cnf (or similar) and add the line max_connections = 1024; line within the [mysqld] section; then restart if you couldn't...

Read More

MYSQL : "Host is blocked because of many connection errors"

Error : "Host is blocked because of many connection errors" Solutions : #mysql -u root -p -e 'flush hosts' source : http://dev.mysql.com/doc/mysql/en/blocked-host.h...

Read More

MYSQL " Table 'mysql.servers' doesn't exist at ../web-lib-funcs.pl

Problems Table 'mysql.servers' doesn't exist at ../web-lib-funcs.pl Solution #mysql_upgrade -u root -p OR #mysql_upgrade -u root -h localhost -p --verbose --force Then Restart MySQL Server #/etc/init.d/mysqld Source : http://tonkersten.com/2012/08/126-mysql-backup-error/...

Read More

MySQL : Cannot load from mysql.proc. The table is probably corrupted

Error : Cannot load from mysql.proc. The table is probably corruptedSolution :#mysql_upgrade -pSource : http://www.robsearles.com/2011/02/fix-cannot-load-from-mysql-proc-the-table-is-probably-corrupted/ http://www.myguysolutions.com/2013/10/30/how-to-resolve-mysql-error-code-1548-cannot-load-from-mysql-proc-the-table-is-probably-corrupt...

Read More