Archive for the ‘MYSQL’ Category

MYSQL Error #2002

While accessing PhpMyAdmin getting the following error.
MYSQL Error #2002 – showing server is not responding or local MySQL server’s socket is not correctly configured.
Reason :-
The mysql socket file is missing from the /tmp directory
Fix :-
1. Create a symbolic link from the original mysql socket file to /tmp
[root@test ~]# ln -s /var/lib/mysql/mysql.sock /tmp
OR
2. Restart MySQL [...]

Leave a Comment

MySQL Error Codes- Part II

MySQL Error Codes, continued from earlier post:
Error: 1026 SQLSTATE: HY000 ER_ERROR_ON_WRITE Message: Error writing file ‘%s’ errno: %d
Error: 1027 SQLSTATE: HY000 ER_FILE_USED Message: ‘%s’ is locked against change
Error: 1028 SQLSTATE: HY000 ER_FILSORT_ABORT Message: Sort aborted
Error: 1029 SQLSTATE: HY000 ER_FORM_NOT_FOUND Message: View ‘%s’ doesn’t exist for ‘%s’
Error: 1030 SQLSTATE: HY000 ER_GET_ERRNO Message: Got error %d from [...]

Leave a Comment

MySQL Error Codes

MySQL Error Codes- You may receive an error message while using MySQL extention mysqli or PDO, check out this table which will help you to debug your applications.There could be two type of error, the first might be server errors and the second is client errors. The error messages are listed the source in the [...]

Leave a Comment

Mysqlaccess

The mysqlaccess script provides information that can be useful in detect problems with user access to a given database. However before you process for this script you should make sure that you must always do a ‘mysqladmin reload’ after making changes to the MySQL database tables.
Mysqlaccess script support the following option. You may use either [...]

Leave a Comment

Common Errors Using MySQL Programs

Here is the list of some common errors that users often encounter when running MySQL programs.
Common Errors-MySQL Programs
B.5.2.1. : Access denied
B.5.2.2. : Can’t connect to [local] MySQL server
B.5.2.3. : Lost connection to MySQL server
B.5.2.4. : Client does not support authentication protocol
B.5.2.5. : Password Fails When Entered Interactively
B.5.2.6. : Host ‘host_name’ is blocked
B.5.2.7. : Too [...]

Leave a Comment

How to Delete MySQL Database ?

There are many ways to delete data from a database in MySQL but You’ll need special privilege to create or to delete a MySQL database. In case you want to delete MySQL database here are the process by which you can delete the MySQL database from your web hosting account.
Follow these Steps to delete [...]

Leave a Comment

Mysql Dump Timer-MySQL database

Mysqldump program is used to dump the contents of a MySQL database and allow the transfer of a MySQL database and MySQL tables between different MySQL servers. The SQL statements can be redirected to a file though you should be sure that there is no activity going on while you do. Firewalls will not block [...]

Leave a Comment

SQL Query Analyzer-Keyword Shortcut Part I

The following lists of keyword shortcuts for SQL Query Analyzer should be helpful to you, the list contains (CTRL+) combination shortcut for SQL Query Analyzer, you would find these shortcut very handy and will surely save your time.
CTRL+O — [...]

Leave a Comment