MySQL Common operations

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