Control Web Panel

WebPanel => CentOS-WebPanel GUI => Topic started by: alierenerdal on December 08, 2015, 09:46:05 AM

Title: How to change mysql user password from for cwp client ?
Post by: alierenerdal on December 08, 2015, 09:46:05 AM

Please help me , I want to change mysql password without create again user.

Title: Re: How to change mysql user password from for cwp client ?
Post by: Igor S. on December 08, 2015, 09:53:10 AM

Hello.

Quote from: alierenerdal on December 08, 2015, 09:46:05 AM

Please help me , I want to change mysql password without create again user.

You have two ways for that.
a) you can log in to PhpMyAdmin as root and change the user password;
b) use the mysql command in SSH:

Code: [Select]

mysql -e "UPDATE mysql.user SET Password=PASSWORD('%your_password%' WHERE User='%your_user%' ; FLUSH PRIVILEGES)"Where: %your_user% - database user ; %your_password% - the new user password