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. using Notepad++ (must install hex view plugin) open the my.ini file in HEX view

2. remove the HEX character ef bb bf then save the my.ini file

3. try restart the MYSQL80

source : https://madbray.com/mysql80-service-started-and-then-stopped-fixed/

Read More

MySQL : mysql_connect(): Too many connections

Issue:

mysql_connect(): Too many connections

Solutions:

1. 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).
2. 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 do the live change.

Source: http://stackoverflow.com/questions/730953/how-to-fix-mysql-connect-too-many-connections

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.html

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 corrupted

Solution :

#mysql_upgrade -p

Source :

• 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-corrupted/

Read More