MySQL Series 4----password management, authorization, graphical management

First, mysql password hack

1. In Shell Life make password change under line

mysqladmin-hlocalhost-uroot-p password "123456"

2. Crack password

A, add in config file: skip-grant-tables, restart Service

B, Find the Mysql.user table and find the Authentication_string field

C, update the password: Update mysql.user set Authentication_string=password ("123456")

where user= "root" and host= "localhost";

D , refresh configuration: Flush privileges;

E. Modify the configuration file: Comment out the option to skip the password cancellation

F, restart the service, with the new password to verify the login

Second, user authorization and REVOKE authority

1. Grant All on * * to [e-mail protected] identified by ' 123456 ' with GRANT option

//To the man user in 192.168.4.5 all the libraries on this client have all the permissions,

The login password is 123456 and has authorization, that is, the client can grant permissions to other users

2. Client View permissions:

SELECT @ @hostname; Displays the host name of the connection server

Select User (); Displays the IP address of the currently logged on user and client host

Show grants; View permissions for logged-in users

Show Processlist; To view the status of the current User Client Connection server

3. Revocation of Authorization

Show grants for [email protected] "%"; To view the root user's permissions on all clients

revoke GRANT OPTION on * * FROM [email protected] '% '//REVOKE authorization rights

Revoke Delete on * * FROM [email protected] '% '; Revoke a single permission to delete

4. MySQL Authorization library:

User: Store an existing authorized user

DB: Store authorized user access to the library

Tables_priv: Access rights to a table

Columns_priv: Access to fields in a table

SELECT * from Mysql.user where user= "root" \g

View a list of all permissions for the root user

Drop user username @ ' client address ';//delete an authorized account

5, set Password=password ("New password")//user's own password change

Set password for user name @ "Client Address" =password ("New password"); Admin Change Password

Third, MySQL Graphics management tool

1, install Httpd,php,php-mysql, start the website service

2, Decompression: TAR-ZXF phpmyadmin-2.11.11-all-languages.tar.gz-c/var/www/html/

3, under the/var/www/html: MV Phpmyadmin-2.11.11-all-languages phpadmin

4, Chown-r Apache:apache phpadmin//Modify the Running account permissions

5. CP config.sample.inc.php config.inc.php//Generate master configuration file

6, modify the main profile: config.inc.php, in 17 and 31 lines to modify

7. Restart website Service

8. Http://192.168.4.51/phpadmin //On client authentication, login

MySQL Series 4----password management, authorization, graphical management