All About MySQL

This is a page which contains list of articles related to MySQL Database Server  :

Tips for Access

  1. How to Access MySQL Database Server via Command Line .
  2. How to Remote Execute MySQL Query via Command Line .

Tips for Checking MySQL Version

How to Check MySQL Version in Linux via Command Line .

Tips for Backup MySQL Database

How to Create Daily Backup MySQL Database using Cron in Linux .

Tips for Retrieving Data

  1. How to Export MySQL Query Result to CSV via Command Line .
  2. How to Retrieve Result from Remote Executable MySQL Database Query to File .

Tips for Column Management

  1. How to Change Column Order in MySQL Database Server via Command Line.
  2. How to drop column in MySQL Database Server .

Tips for Table Management

  1. How to Create Additional Table for Many to Many Relationship in MySQL Database Server .
  2. How to Alter Table Add Field after Another Field MySQL Database Server via Command Line with Example .
  3. How to Alter Table Add Primary Key in MySQL Database Server via Command Line with Example .

Tips for Foreign Key

  1. How to Add Foreign Key in MySQL Database Server via Command Line .
  2. How to Drop Foreign Key in MySQL Database Server via Command Line .

Tips for Privileges Management

  1. How to Show Privileges in MySQL Database Server via Command Line .
  2. How to Show Privileges of a User in MySQL Database Server via Command Line .
  3. How to Revoke Privilege in MySQL Database Server .

Tips for User Management

How to Drop User in MySQL Database Server .

Tips for Showing Create Script

How to Show Create Script in MySQL Database Server via Command Line .

Error

  1. How to solve MySQL Error Message : ERROR 2002 (HY000): Can’t connect to local MySQL server through socket ‘/var/run/mysqld/mysqld.sock’ (2) .
  2. How to solve MySQL Error Message : There can be only one auto column and it must be defined as a key .
  3. How to solve MySQL Error Message Multiple primary key defined .
  4. How to get SQL Query history in MySQL .
  5. How to solve MySQL Database Generate ERROR 1064 (42000): You have an error in your SQL syntax Add Foreign Key .
  6. How to solve MySQL Error Message Cannot add or update a child row: a foreign key constraint fails .
  7. How to solve MySQL Error Failed to dump MySQL Database /tmp file permission denied .
  8. How to solve MySQL Error Cannot Change root Password MySQL using MySQL console .
  9. How to Solve MySQL Error Database generate ERROR 1452 (23000): Cannot add or update a child row: a foreign key constraint fails .
  10. How to Solve MySQL Error Database generate ERROR 1215 (HY000): Cannot add foreign key constraint .
  11. How to Solve MySQL Error Dumping Database on MySQL Database Definer does not Exist .
  12. How to Solve MySQL Error Message : ERROR 1114 (HY000) at line 4032: The table ‘table’ is full .
  13. How to Solve MySQL Error Message : ERROR 1010 (HY000): Error dropping database (can’t rmdir ‘./db’, errno: 39) .

Leave a Reply