To see if the service is started
Adding environment variables
Use MySQL root again
Permanent effect
Put the command into profile
Make environment variables effective
Mysql-u User-p password
Set the root user password
Change root password
Reset Password
Edit File
Modify Ignore Authorization Skip-grant
Restart Service Effective
Switch libraries
Modify a password in a table
Remove the Ignore authorization action
Restart Service
Link MySQL
Verify link remote mysql-hip address-p port
Using SOCKD Links
The link is only suitable for the native
Linked Operations List the database
MySQL Common commands
View Database
Use MySQL switch library
View the table of the library needs to add;
View the fields of a table
View the Build Table statement \g vertical Display
View Current User
Command history file
View current use of the hair database
Create a library
View Gallery
Create a table
The charest= character set can be defined by itself
View Table
View Database version
View library Status
View various parameters
modifying parameters
You want to have it in effect modify the configuration file
View queues
Common commands
MySQL Common operations