Common MySQL database operations

Common MySQL database operations
Server operation (cmd)

Check whether the mysqld.exe process exists in the progress table)

Disable the server (ensure that mysql is a windows Service): net stop mysql56
Check whether the process mysqld.exe exists in the process (does not exist)

Customer Login operation
Cmd
1. log on to the server: mysql-uroot-p123-hlocalhost //-hlocalhost can be omitted, which is the default
-U: followed by the user name
-P: Password followed
-H: followed by IP Address
2. exit the server: exit or quit

MySQL storage blob data package backup and recovery is too large

Com. mysql. jdbc. PacketTooBigException: Packet for query is too large (9802817> 1048576). You can change this value on the server by setting the max_allowed_packet 'variable.

In my. ini, add max_allowed_packet = 10 M under [mysqld]. For example:

[Mysqld]
Max_allowed_packet = 64 M

Encoding