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)