MySQL Command learning notes (one)

One, install/uninstall MySQL database

#安装Mysql数据库

D:\mysql\bin>mysqld--install

#启动Mysql服务

D:\mysql\bin>net start MySQL

#停止Mysql服务

D:\mysql\bin>net stop MySQL

#卸载Mysql数据库

D:\mysql\bin>mysqld--remove

Second, login \ Exit MySQL Database

#命令: Mysql-h Host IP address-u user name-p password

#本机登录, the user name root password is empty

D:\mysql\bin>mysql-h Localhost-u Root-p

#上面命令还可以写成下列方式

D:\mysql\bin>mysql-hlocalhost-uroot-p

#上面命令简写为下面命令

D:\mysql\bin>mysql-u Root

#退出Mysql

Mysql>\q

Mysql>exit

Mysql>quit

Third, MySQL common management tools

1, phpMyAdmin PHP language written Web management program, Linux recommended to use

2, SQLyog very good MySQL desktop management software, Windows recommends the use of

Iv. two storage engines commonly used by MySQL

MyISAM (old version default engine)

InnoDB (new version default engine) can handle things (acid-compatible)

V. Basic MySQL View command:

#查看数据库版本信息

Select version ();

#查看当前使用的哪个数据库, displays the current database name;

Select Database ();

#查看所有数据库

show databases;

This article is from the "Network Learning and Communication" blog, please be sure to keep this source http://steave.blog.51cto.com/229503/1882416

MySQL Command learning notes (one)