mysql login_mysql 常用命令行-login

1、mysql 登录

LOGIN

In CMD:

>>mysql.exe –uroot –p

>>Enter Password: ********

>>mysql>

It’s like this:

mysql -uusername -ppassword –hhost

Attention: There is no blank after the parameters: -u, -p, –h

The MySQL client program, also known as the MySQL monitor, is an interface that allows the user to connect to the MySQL server, create and modify databases, and execute queries and view their results. This program is started by executing the command mysql at the shell prompt. In general, the syntax for this command is:

%>mysql [options] [database]

2、查看数据库

show databases;

create database mysql;//建立数据库

3、使用某个数据库

use database;

4、显示表名

show tables;

create table customer(id int not null primary key AUTO_INCREMENT,name varchar(50));