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

This article mainly tells you briefly how to crack and reset the mysql password. You can check the relevant professional terms on the Internet or find some related books to supplement them. We will not dabble here, so let's go straight to the topic. I hope that how to crack the mysql password and reset this article can bring you some practical help.

# first close mysqlservice mysqld stop# and enter the secure mode. You can log in without password / usr/local/mysql/bin/mysqld_safe-- skip-grant-tables-- skip-networking&# login without password / usr/local/mysql/bin/mysql-uroot# to change password. Password and user options are optional. Choose which user environment you want to update to update mysql.user set password=PASSWORD ('new password') where user='root' and host='root' or host='localhost'or host='localhost.localdomain'or host='127.0.0.1' # use the new field update mysql.user set authentication_string=password ('new password') where user='root';# refresh policy flush privileges;# to restart mysql/etc/init.d/mysqld restart# normal login / usr/local/services/mysql/bin/mysql-uroot-p 'new password' # Test whether the function is normal mysql > show databases

How mysql password should be cracked and reset will first tell you here, for other related issues you want to know can continue to pay attention to our industry information. Our section will capture some industry news and professional knowledge to share with you every day.

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.