Mysql problem

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

to add when i run ./upgrade_mysql



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

Server Version NOT supported!

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:

Find something new 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...

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;