Discover mysql reset admin password, include the articles, news, trends, analysis and practical advice about mysql reset admin password on alibabacloud.com
For whatever reason, there should be a lot of friends in their own vps/server using the WDCP Management panel when there are forgotten MySQL root account management password in the search for solutions, and even forget WDCP admin login password.
In the previous article we have introduced the Wdcp–linux Server management system, for whatever reason, there should be a lot of friends on their own vps/server to use the WDCP Admin panel when you forget the MySQL root account management password,
Today help a friend get back the Super Administrator root password mysql, start to enter the command when less hit a "point" the harm of a few hours, finally solved, write a tutorial, easy to use later!If you are a server that is Windows Xp/2000/2003
After installing MySQL, unable to enter through the root, because the installation, and did not set the root password, there seems to be an initial random password, but do not remember, too troublesome, directly reset the root password. After
Today, SSH is automatically disconnected without seeing the password.
So how to view/Reset the administrator password information. You can view the installation log directly in SSH
Installation log
Cat/usr/local/directadmin/scripts/setup.txt
The
Restart the MySQL root password
Methods one, using Mysqladmin
The code is as follows
Copy Code
#./mysqladmin-u root password ' newpassword '#./mysqladmin-u root-h host_name password ' newpassword 'Usually mysqladmin ' s
One, the normal change user passwordManage-users-select "Users" on the right-click on the admin-in the list to edit the password-click on the archive after entering the new password650) this.width=650; "src="
How to modify the MySQL root passwordForgetting the MySQL root password is a common problem in mysq use, but a lot of friends do not reset the root password, that complain Ah, close-up this article to communicate with you:1. Edit the MySQL
Reset the root password for MySQL under Ubuntusudo vi/etc/mysql/my.cnf, adding a line "skip-grant-tables" to the [Mysqld] Segmentsudo service mysql restart, restart MySQL servicessudo mysql-u root-p mysql, enter MySQL admin command line with a blank
A few days ago, I authorized a foreign Space Provider server and installed the plesk host management system. I used to know that I could retrieve the password directly on the server. I finally found the solution, after that, add 8443 access to the
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.