Author Topic: implement panel option for changing MySQL root password  (Read 647 times)

0 Members and 1 Guest are viewing this topic.

Offline
****
implement panel option for changing MySQL root password
« on: January 29, 2018, 08:07:23 PM »
After the CWP installation one might want to change the SQL root password but there is currently no option in the panel. Instead the password has to be changed manually in the DB and then in **Check your MySQL root password in: /usr/local/cwpsrv/htdocs/resources/admin/include/db_conn.php and /root/.my.cnf


Offline
****
Re: implement panel option for changing MySQL root password
« Reply #2 on: January 29, 2018, 08:15:05 PM »
Did you try it? It is generating just a new random password and not providing an option to set one's own, hence no good, still have to change everything manually.

Offline
***
Re: implement panel option for changing MySQL root password
« Reply #3 on: January 29, 2018, 08:44:03 PM »
nano /scripts/mysql_pwd_reset

Find line

Quote
DB_ROOT_PASS=`cat /dev/urandom| tr -dc 'a-zA-Z0-9' | fold -w 12|head -n1`

Replace it

Quote
read -sp 'Password: ' DB_ROOT_PASS

Then run the script again.

Offline
****
Re: implement panel option for changing MySQL root password
« Reply #4 on: January 29, 2018, 09:45:57 PM »
awfully nice of you, works like a charm  8)

I am still in favour of CWP implementing it in the gui
« Last Edit: January 29, 2018, 10:06:48 PM by n8v8r »