Control Web Panel
WebPanel => CentOS 7 Problems => Topic started by: mishaal on October 12, 2022, 05:16:02 PM
-
Hi
I have a problem when logging into the server panel
Warning: mysqli_connect(): (HY000/1045): Access denied for user 'root'@'localhost' (using password: YES) in /usr/local/cwpsrv/htdocs/resources/admin/include/functions.php on line 0
Warning: mysqli_connect(): (HY000/1045): Access denied for user 'root'@'localhost' (using password: YES) in /usr/local/cwpsrv/htdocs/admin/admin/index.php on line 0
Trying to start mysql server, please wait!
Try to restart Control Web Panel with command: sh /scripts/restart_cwpsrv
**Check your MySQL root password in: /usr/local/cwpsrv/htdocs/resources/admin/include/db_conn.php and /root/.my.cnf
You can reset the MySQL root password fast with this command: /scripts/mysql_pwd_reset -q
Warning: mysqli_error() expects exactly 1 parameter, 0 given in /usr/local/cwpsrv/htdocs/admin/admin/index.php on line 0
Could not connect:
-
this is what I'd do to reset MySQL password
1.) mysql --version
2.) sudo systemctl stop mysql(if root sudo is not needed)
3.) sudo mysqld_safe --skip-grant-tables &
4.) mysql -u root
5.) ALTER USER 'root'@'localhost' IDENTIFIED BY 'MY_NEW_PASSWORD';
6.) FLUSH PRIVILEGES;
7.) UPDATE mysql.user SET authentication_string = PASSWORD('MY_NEW_PASSWORD') WHERE User = 'root' AND Host = 'localhost';
8.) FLUSH PRIVILEGES;
9.) SET PASSWORD FOR 'root'@'localhost' = PASSWORD('MY_NEW_PASSWORD');
10.) FLUSH PRIVILEGES;
if all goes well you should see this: Query OK, 0 rows affected (0.00 sec)
then either restart mysql or reboot server
for more details search "reset mysql password" 8)