Tutorialsplane

How to select database using command line in Mysql

admin

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.

Illegal mix of collations (latin1_general_ci,IMPLICIT) and (latin1_swedish_ci,IMPLICIT) for operation
How to update row using joins in MYSQL | to updtae row ,data using joins in sql
How to import database using command line in MySQL
How to select database using command line in Mysql
My Sql Questions And Answers
Get last conversation in mysql table in facebook style
Mysql find duplicate records in table
Sql create table with primary key
Mysql create table primary key autoincrement example
Get zip codes in radius Mysql query
SQL Prevent Duplicate INSERT – MySql
Get list of MySQL user accounts
Can’t connect to local MySQL server through socket ‘/var/mysql/mysql.sock’
MySQL Grant all privileges on database