MySQL second lesson SQL statement build Database

Scene

MySQL executable directory: C:\Program Files (x86) \mysql\mysql Server 5.6\bin

Login Instructions Mysql.exe-u root-p

Enter Password: admin123

Show databases;//s is required, is required, shows all databases

When importing a data table, you must select a database, otherwise error message: No database selected, use instruction

Use test;

Note: CREATE DATABASE directive:

Import Database directives:

SOURCE E:test.sql

Doubts

Mysql-js>

This hint indicates that the current interactive language is JavaScript

Reference

http://blog.csdn.net/u010722980/article/details/51553478

Forgot MySQL Password

1) Stop the service

net stop MYQL

2) Skip Permission detection

Mysqld--defaults-file= "C:\Program Files (x86) \mysql\mysql Server 5.6\my.ini"--console--skip-grant-tables

Reference

Http://www.cnblogs.com/andy_tigger/archive/2012/04/12/2443652.html

Modify the character encoding of MySQL support GBK Chinese encoding

Modify the My.ini in the C:\Program files\mysql\mysql Server 5.6 Directory

Modify Default-character-set=latin1 to DEFAULT-CHARACTER-SET=GBK

Use DOS command: net stop MySQL to stop service net start MySQL to start

MySQL second lesson SQL statement build Database