In different versions of MySQL, many of the features and syntax may not be the same, how can we know the current installation version of the syntax? In fact, MySQL comes with a set of help for us to use. We can look at the layers.
Enter the command to see MySQL help all columns.
content
Note And the following keywords have a space between them)
If at this point, the user management is not very clear, you can enter ? Account Management
Then, you can continue to let subordinates see ? create user
It can be seen that the explanation is more comprehensive.
Supplemental simplified local MySQL connection
In the local test, if you feel the need to connect to MySQL every time is quite troublesome, now we can reduce the connection input.
We can connect directly by following MySQL. Of course, in order to achieve this effect, must be a certain configuration.
Under Win, open the database configuration file My.ini, in the [client] area, add the host, user name, and password.
[client]port=3306host=localhostuser=rootpassword=123456
Tests such as
Use of MySQL Help