how to change mysql root password (phpmyadmin root) same thing

[teknohan]

how to change mysql root password (phpmyadmin root) same thing

[Administrator]

why would you need to change mysql root password ?

[erm3nda]

I don't think the why is a required thing to ask

Also i wanna remark that are different things if you wanna change to another, or if you lost it.
Also, once change, you must update my.ini file under root home.

[teknohan]

i needed before but now i found the way around no need anymore thanks

[erm3nda]

Can you explain a little?

What was the problem and what was the workaround?

[Administrator]

now /scripts folder has this solution

Code Select Expand

sh /scripts/mysql_pwd_reset

[erm3nda]

mysqld_safe --skip-grant-tables >res 2>&1 &

This is the way. I got my own version of that script from long time ago, but yours is clear

Thank you.