LAMP 3.4 MySQL Common operation-2

Authorization to the user

' User1 ' @'192.168.1.%'wangshaojun';

Specify the library, user name User1 all under the network segment, password Wangshaojun

Permissions are not valid after authorization, refresh permissions

> Flush Privileges;

View database There are those queues, like PS, that have those processes at work

> Show processlist;

View variables

> Show processlist;

Changing these values in the config file requires restarting MySQL, which can be changed directly in MySQL.

Change Max_connections 150 to 200

Set Global max_connections=;

View the specified value

' max_connec% ';

% indicates a wildcard.

View status

> Show status;

View the specified state

' %buffer% ';

Check the MySQL error log defined in this script

Vim/etc/init.d/mysqld

Datadir=/data/mysql

The error log is

Ls/data/mysql/wangshaojun.err

Tail Wangshaojun.err

Fix a table.

> Repair table discuz.pre_form_post;

LAMP 3.4 MySQL Common operation-2