How to select database using command line in Mysql

Use the following command to select database using command line in Mysql.

1 . Grant Permission

GRANT ALL PRIVILEGES ON `database_name`.* TO 'username'@'localhost'WITH GRANT OPTION;

2 . Now Select Database

Use database_name;

you will be switch to this database.

Add Comment

📖 Read More

• 1. My Sql Questions And Answers
• 2. Get last conversation in mysql table in facebook style
• 3. Mysql find duplicate records in table
• 4. Sql create table with primary key
• 5. Mysql create table primary key autoincrement example

• 6. Get zip codes in radius Mysql query
• 7. SQL Prevent Duplicate INSERT - MySql
• 8. Get list of MySQL user accounts
• 9. Can't connect to local MySQL server through socket '/var/mysql/mysql.sock'
• 10. MySQL Grant all privileges on database