Control Web Panel

WebPanel => MySQL => Topic started by: golfofficial on August 23, 2016, 06:52:36 AM

Title: Change Password Root SQL , then the SQL Error.
Post by: golfofficial on August 23, 2016, 06:52:36 AM

Change the Root Password SQL Password Change the time of the User Password CWP.admin it does not change the SQL to make it impossible to access your SQL User.What exactly do I need to set up a highly detailed interference fit is not good . CentOS and CWP.Admin


It is this message

Warning: [obfuscated](): No such file or directory in /usr/local/cwpsrv/htdocs/admin/index.php on line 0
mysqld dead but subsys locked

Trying to start mysql server, please wait!
Try to restart CentOS Web Panel with command: service cwpsrv restart

**Check your MySQL root password in: /usr/local/cwpsrv/htdocs/resources/admin/include/db_conn.php and /root/.my.cnf

Could not connect: No such file or directory




thank you

Title: Re: Change Password Root SQL , then the SQL Error.
Post by: Igor S. on August 23, 2016, 09:51:49 AM

Hello.

For the root password changing you have to use the script /scripts/mysql_pwd_reset
If you have change it manually you must to change the password in:

Code: [Select]

/usr/local/cwpsrv/htdocs/resources/admin/include/db_conn.php and /root/.my.cnf

Title: Re: Change Password Root SQL , then the SQL Error.
Post by: golfofficial on August 23, 2016, 11:18:58 AM

Quote from: Igor S. on August 23, 2016, 09:51:49 AM

Hello.

For the root password changing you have to use the script /scripts/mysql_pwd_reset
If you have change it manually you must to change the password in:

Code: [Select]

/usr/local/cwpsrv/htdocs/resources/admin/include/db_conn.php and /root/.my.cnf

 
Do I Change Password in SQL itself. And changes in db_conn.php Match in PhPmyadmin Password It is not associated with CWP. Admin's SQL User lost.

It was a message on the menu mysql_manager in CWP.Admin List of MySQL databases and users that have access to database All data lost Help bother me

Title: Re: Change Password Root SQL , then the SQL Error.
Post by: Igor S. on August 24, 2016, 07:51:53 AM

Have no ideas. Try contact to CWP support http://centos-webpanel.com/support-services for investigate.