What are the steps required to view your MYSQL database?

asked Sep 13, 2013 in MYSQL by rajesh
edited Sep 12, 2013
0 votes

1 Answer

0 votes

There are certain steps that are required to before you can view MySQL database and they are as follows:

1. Login as database user: for example: 
[root@ tmp]# mysql -u mysqluser -p sales
2. List all your MySQL databases: use the show command to view the list of all available MySQL databases. For example to view sales database use the command shown below:
mysql> show databases;
| Database |
| salesdata |


answered Sep 13, 2013 by rajesh
edited Sep 12, 2013