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 … Read more
Error: 1008 SQLSTATE: HY000 (ER_DB_DROP_EXISTS) Message: Can’t dropp database ‘%s’; database doesn’t exist
MySQL Error: 1040 SQLSTATE: 08004 (ER_CON_COUNT_ERROR) If 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 … Read more
What is database? Database is an organized collection of information about an entity having controlled redundancy and serves multiple applications. DBMS (database management system) is an application software that is developed to create and manipulate the data in database. A query language can easily access a data in a database. SQL (Structured Query Language) is … Read more
JavaScript provides full control to handle loops and switch statements. There may be a situation when you need to come out of a loop without reaching at its bottom. There may also be a situation when you want to skip a part of your code block and start the next iteration of the look. To … Read more
The for…in loop is used to loop through an object’s properties. As we have not discussed Objects yet, you may not feel comfortable with this loop. But once you understand how objects behave in JavaScript, you will find this loop very useful. Syntax for (variablename in object){ statement or block to execute } In each … Read more
The ‘for’ loop is the most compact form of looping. It includes the following three important parts − The loop initialization where we initialize our counter to a starting value. The initialization statement is executed before the loop begins. The test statement which will test if a given condition is true or not. If the … Read more
While writing a program, you may encounter a situation where you need to perform an action over and over again. In such situations, you would need to write loop statements to reduce the number of lines. JavaScript supports all the necessary loops to ease down the pressure of programming. The while Loop The most basic … Read more
90% 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)
Error: 1045 SQLSTATE: 28000 (ER_ACCESS_DENIED_ERROR) Message: Access denied for user ‘%s’@’%s’ (using password: %s) This occurs when the user has no access to database server and user is trying to connect the database server. Suggestions: Check the mysql user rights Check the database access rights Check the users IP