MySQL remote access authorization and quick fix _ MySQL

MySQL remote access authorization and quick repair of bitsCN.com

> Grant all on *. * to root @ '%' identified by '20140901 ';
> Flush privileges;
MySQL remote access authorization and quick fix
MySQL remote authorization
# Mysql-uroot-p
> GRANT all privileges ON *. * to root @ % identified by "comsenz ";
> Flush privileges;
> GRANT all privileges ON discuzbbs. * to discuz@192.168.0.3 IDENtTIFIED BY "comsenz ";
> Flush privileges;
Note: If the discuz user does not exist in MySQL, MySQL automatically adds the user in the authorization operation and performs the authorization operation.
MySQL quick fix
After using MySQL for a long time, some problems may occur in the database. Most problems can be solved quickly through simple operations. The following describes two methods to quickly repair the MySQL database.
1. myisamchk
To use myisamchk, you must temporarily stop the MySQL server. For example, we want to repair the discuz database. Perform the following operations:
# Service mysql stop (stop MySQL );
# Myisamchk-r/var/lib/mysql/discuz/* MYI
# Service mysql start
Myisamchk automatically checks and fixes index errors in the data table.
2. mysqlcheck
You can use mysqlcheck to perform hotfix without stopping MySQL. The procedure is as follows:
# Mysqlcheck-r discuz .*
Note: Do not use-f to forcibly fix myisamchk or mysqlcheck. If the-f parameter fails to be repaired, delete some data with errors to try to fix it. Therefore, do not use-f unless necessary.

Author "third party"

BitsCN.com