Author Topic: Mysql problem  (Read 8999 times)

0 Members and 1 Guest are viewing this topic.

Offline
*
Mysql problem
« on: December 19, 2018, 08:42:43 AM »
Hello i got a strange problem i lost acces to mysql over cwp. also some cronjobs doesent work. i must say that i try mysql scrip to resset password i try to google and many other things nothing work. i return manualy old password to make cwp working again

http://prntscr.com/lwva5k

also when i try to update mysql script i got mysql root password error...

Offline
*
Re: Mysql problem
« Reply #1 on: December 19, 2018, 10:44:20 AM »
to add when i run ./upgrade_mysql



CWP MySQL & phpMyAdmin Upgrade Script
#######################################

Server Version NOT supported!

Offline
*
Re: Mysql problem
« Reply #2 on: December 19, 2018, 11:07:01 AM »
when i use script to reboot mysql password i get crash from cwp panel, and mysql password dont change (beacuse i login again to mysql with old pass


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 CentOS 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


Warning: mysqli_error() expects exactly 1 parameter, 0 given in /usr/local/cwpsrv/htdocs/admin/admin/index.php on line 0
Could not connect:

Offline
*
Re: Mysql problem
« Reply #3 on: December 20, 2018, 07:22:28 AM »
Find something new :P when i use this

service mysqld stop
killall -vw mysqld
mysqld_safe --skip-grant-tables  &

And check, mysql running fine in mysql safe... all working even in mysql manager i see databases... but when i return to regular mysql nothing work... its like cwp dont have acces to mysql...

Offline
*
Re: Mysql problem
« Reply #4 on: December 21, 2018, 02:29:00 PM »
Solved thanks to igor from support. Also if u delete root user by accident like i did :) , here is a quick solution.

service mysqld stop
killall -vw mysqld
mysqld_safe --skip-grant-tables &

mysql -u root
SET PASSWORD FOR 'root'@'localhost' = PASSWORD('MyNewPass');
FLUSH PRIVILEGES;