Can not be installed
2. C: / mysql / bin> mysqld-max-nt -install runs Mysql service each time computer startup
3.Winmysqladmin boot graphical management tool
4. Login
Mysql -h localhost -u root -p (h: host; u: user p: password)
5.Mysql basic security settings (must be logged in with root first, then use mysql)
User Table in the mysql database is the permission table (in order to remember trouble, then study later)
6. MySQL> Show Databases
->;
--------
| Database |
--------
| mysql |
| Test |
--------
Display the database, here the default display with two databases
7. Show the table in the mysql database
MySQL> show tables
->;
-------------------------
| TABLES_IN_MYSQL |
-------------------------
| Columns_Priv |
| DB |
| func |
| Help_category |
| Help_Keyword |
| Help_RELATION |
| Help_topic |
| Host |
| TABLES_PRIV |
| Time_Zone |
| TIME_ZONE_LEAP_SECOND |
| Time_ZONE_NAME |
| TIME_ZONE_TRANSITION |
| TIME_ZONE_TRANSION_TYPE |
| User |
-------------------------
15 rows in set (0.02 sec)
