All About MySQL

Posted on

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

  1. How to Create Daily Backup MySQL Database using Cron in Linux .
  2. How to Backup all existing database in MySQL Database Server.

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) .
  14. How to Solve MySQL Error Message : ERROR 1548 (HY000) at line 1: Cannot load from mysql.proc. The table is probably corrupted

Leave a Reply