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 connect the mysql database from terminal

How to connect the mysql database from terminal

Here i’m going to explain, step’s to connect the remote mysql database server from terminal. Tested Environment. Remote Server OS CentOS release 6.5 Server (Final) Remote Server MySQL Version 5.1.73 Local PC OS Ubuntu...

How to Recover/Reset forgotten MySQL root Password on Linux

How to Recover/Reset forgotten MySQL root Password on Linux

Did you forgot your mysql password.Don’t worry. Here is the solution, to recover it with simple steps, in this article. 1) Checking mysql service with wrong password ? I have forget my mysql root...

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...

How to check mysql database sizes in command line

How to check mysql database sizes in command line

We are using most of the servers with cpanel and few server not having cpanel. I have used below commands to checked the databases size. If you want to check below commands you should...

15 Awesome Mysqladmin commands for server administrator

15 Awesome Mysqladmin commands for server administrator

mysqladmin is a command line utility of mysql server and its very useful for DB/server administrator to mange and troubleshoot the mysql server issues. I have worked-out 10+ the commands and past the exact...

mysql server monitoring command for server administrator

mysql server monitoring command for server administrator

The easy and quick way to monitoring the mysql server, you can use the below command, it will show’s how many users are currently using mysql database’s which action is their doing and list...

Close
Please support the site
By clicking any of these buttons you help our site to get better