Category: MySQL-Tutorials

How to Drop all tables in a MySQL database

How to Drop all tables in a MySQL database

I’m doing some research in owncloud installation and every time i want to clear the database tables so that, i can go forward. Every time i used to drop the database and recreate it....

How to reset/clear and MySQL replication

How to reset/clear and MySQL replication

Here i’m going to explain, step’s to reset/clear MySQL (Master-Slave) replication. Two way of RESET is must be handle, so that it will reset/clear properly. Slave Server RESET Master Server RESET Tested Environment. Both...

How to Enable Remote Access To MySQL Database Server

How to Enable Remote Access To MySQL Database Server

Here i’m going to explain, step’s to connect the mysql database remotely. 1) If you want to access mysql database remotely, you should have a Static IP so that you can access it while...