1. Login on mysql command
mysql -u root -h localhost -p
2. Check Status
mysql> status
3. show databases
mysql> show databases;
2. Check Status
mysql> status
3. show databases
mysql> show databases;
6. Using and selecting system already available mysql database
mysql> use mysql;
mysql> select database();
mysql> use mysql;
mysql> select database();
7. select user table in mysql database
mysql> select Host, User from user
or
mysql> select Host, User from user
or
8. Create database and display it
mysql> create database tempDB;
mysql> show databases;
mysql> use tempDB;
mysql> select database();
mysql> create database tempDB;
mysql> show databases;
mysql> use tempDB;
mysql> select database();
Comments
Post a Comment
Share this to your friends