How to use mysql through cmd

1199 0

We can use the mysql through cmd by following the simple commands

1.First open the cmd/terminal and go to the root directory by using this command :

2.Aftet root directroy  go inside  xampp/mysql/bin directory by using the following commands :

 

3.Now access your mysql by mysql username and password :

When you run the above command you will get the screen given below

 

if your root user has any password then enter the password and if root has no password press enter. After this you will enter in the mysql

 

Now use the command   show databases;  you will get all databases

 

if you use a particular database use this command

after this you can perform select, insert,update,delete operation on the tables available in this database.

If you want to see all available table inside a database use this command :

Comments

comments

In this article

Join the Conversation