Error: 1064 SQLSTATE: 42000 (ER_PARSE_ERROR)
Message: %s near ‘%s’ at line %d
Error #1064 means that MySQL can’t understand your command. To fix it:
- Read the error message. It tells you exactly where in your command MySQL got confused.
- Check the manual. By comparing against what MySQL expected at that point, the problem is often obvious.
- Check for reserved words. If the error occurred on an object identifier, check that it isn’t a reserved word (and, if it is, ensure that it’s properly quoted).
- 57If you get a too many connections error,Error: 1040 SQLSTATE: 08004 (ER_CON_COUNT_ERROR), when you try to connect to the mysqld server, this means that all available connections are in use by other clients. To increase the concurrent connections what are allowed to connect to the server, change the max_connections system…
- 4890% of the time, this error is due either to the MySQL Server not running, or else firewall configuration on the Windows server blocking access on port 3306 (or whatever port your MySQL instance is configured to use). Error: 2003 (CR_CONN_HOST_ERROR) Message: Can't connect to MySQL server on '%s' (%d)