Shulou(Shulou.com)06/01 Report--

This article mainly introduces mysql password cracking, authority revocation, graphics management tools overview, the things involved, learned from the theoretical knowledge, there are many books, literature for your reference, from a practical point of view, accumulated years of practical experience can be shared with you.

I. mysql password cracking

1. Change the password under the shell command line

Mysqladmin-hlocalhost-uroot-p password "123456"

2. Crack the password

Add: skip-grant-tables to the configuration file to restart the service

B. look up the mysql.user table and find the authentication_string field

C. Update 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 password cancellation

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

II. User authorization and revocation of authority

1. Grant all on *. * to man@192.168.4.5 identified by "123456" with grant option

/ / give man users all permissions for all libraries on the 192.168.4.5 client

The login password is 123456 and has authorized rights, that is, permissions can be granted to other users on the client side.

2. Client view permissions:

Select @ @ hostname; / / displays the hostname of the connection to the CVM

Select user (); / / displays the ip addresses of the currently logged-in users and client hosts

Show grants; / / View the permissions of the login user

Show processlist; / / View the current user's client connection to the server

3. Revoke the authorization

Show grants for root@ "%"; / / View the permissions of the root user on all clients

Revoke grant option on *. * from root@'%' / / revoke authorization

Revoke delete on *. * from root@'%'; / / revoke a single permission for deletion

4. Mysql authorization library:

User: stores existing authorized users

Db: stores the authorized user's access to the library

Tables_priv: access to tables

Columns_priv: access to fields in the table

Select * from mysql.user where user= "root"\ G

/ / View the list of all permissions for root users

Drop user user name @ 'client address'; / / Delete authorized accounts

5. Set password=password ("new password") / / users modify their own passwords

Set password for username @ "client address" = password ("new password"); / / administrator changes password

3. Mysql graphics management tools

1. Install httpd,php,php-mysql and start the website service

2. Decompress: tar-zxf phpMyAdmin-2.11.11-all-languages.tar.gz-C / var/www/html/

3. Under / var/www/html: mv phpMyAdmin-2.11.11-all-languages phpadmin

4. Chown-R apache:apache phpadmin / / modify the permissions of the running account

5. Cp config.sample.inc.php config.inc.php / / generate the main configuration file

6. Modify the main configuration file: config.inc.php, on lines 17 and 31

7. Restart the website service

8. Http://192.168.4.51/phpadmin / / verify on the client and log in

Read the above mysql password cracking, authority revocation, an overview of graphics management tools, hoping to bring some help to everyone in practical application. Due to the limited space in this article, there will inevitably be deficiencies and areas that need to be supplemented. You can continue to pay attention to the industry information section and will update your industry news and knowledge regularly. If you need more professional answers, you can contact us on the official website for 24-hour pre-sales and after-sales to help you answer questions at any time.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.