Article directory
just installedCWP Control Panel, but want to createMySQL database, again forgotMySQLDatabase password password, what should I do?
Don't worry, if you want to check your password, please follow the instructions below.
View MySQL root user password method
You can use this command from the shell to view the MySQL root user password:
grep password /root/.my.cnf
What should I do if I forget the MySQL root password of CWP?
- The MySQL root password can be reset by entering the SSH command.
To reset the MySQL root password, enter the following command via SSH:
sh /usr/local/cwpsrv/htdocs/resources/scripts/mysql_pwd_reset
If you enter the CWP control panel command to reset the MySQL root password, you cannot log inphpMyAdmin,How to do?
- Use the SSH command shared in this article to reset the MySQL root password without using special characters.
- Reset the MySQL root password using a mix of uppercase and lowercase letters and numbers.
- Otherwise, errors may occur, preventing login to CWP control panel and phpMyAdmin control panel.
Please try to reset the MySQL root password again with the following command:
sh /scripts/mysql_pwd_reset
CWP modify MySQL specified user password
Go to phpMyAdmin -> "Account"Tab :
- Click on the root user's"edit permission" ▼
- Go to"change Password"Section -> Generate New Password ▼
- then click"execute (Go)” button ▲
Now you need to set a new password in your website's database configuration file.
If your website is usingWordPressTo build, please modify the database password in the wp-config.php file.
Hope Chen Weiliang Blog ( https://www.chenweiliang.com/ ) shared "What should I do if I forget the MySQL root password? CWP reset/modify MySQL user password method", it will help you.
Welcome to share the link of this article:https://www.chenweiliang.com/cwl-156.html
Welcome to the Telegram channel of Chen Weiliang's blog to get the latest updates!
📚 This guide contains huge value, 🌟This is a rare opportunity, don’t miss it! ⏰⌛💨
Share and like if you like!
Your sharing and likes are our continuous motivation!