Shulou(Shulou.com)06/01 Report--

Install / uninstall Mysql database

# install Mysql database

D:\ mysql\ bin > mysqld-- install

# start the Mysql service

D:\ mysql\ bin > net start mysql

# stop Mysql service

D:\ mysql\ bin > net stop mysql

# Uninstall Mysql database

D:\ mysql\ bin > mysqld-- remove

Log in / log out of the Mysql database

# Command: mysql-h host IP address-u user name-p password

# Log in locally, the user name root password is empty

D:\ mysql\ bin > mysql-h localhost-u root-p

# the above commands can also be written in the following ways

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

# the above command is abbreviated as the following command

D:\ mysql\ bin > mysql-u root

# exit Mysql

Mysql >\ Q

Mysql > exit

Mysql > quit

III. Common management tools for Mysql

1. Web management program written in phpmyadmin php language, recommended by linux.

2. SQLyog's excellent mysql desktop management software, which is recommended by windows.

4. Two storage engines commonly used in Mysql

MyISAM (old version default engine)

InnoDB (the new version of the default engine) can handle things (compatible with ACID)

5. Mysql basic view commands:

# View database version information

Select version ()

# check which database is currently in use and display the name of the current database

Select database ()

# View all databases

Show databases

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.