Topic: need info to change mysql password

[fixit]

I need to change mysql password, I do not want to reset it but change it, is this possible without breaking any other appz

the problem is that I have a forward slash / in the password, which I believe is causing my problem with installing a web app that requires the root password.

I have used the same app on a test server and the installation was successful

Thanks, Russell

[pfloor]

I need to change mysql password, I do not want to reset it but change it, is this possible without breaking any other appz

the problem is that I have a forward slash / in the password, which I believe is causing my problem with installing a web app that requires the root password.

I have used the same app on a test server and the installation was successful

Thanks, Russell

You should NEVER change the mysql root password.  And you should NEVER use the root user for a web app.

Your web app should never be allowed to have root privileges to mysql. 

Create a new user in mysql and give that new user all privileges for the web app's database.  Something like this:

create database webapp;
grant all privileges on webapp.* to webappuser@localhost identified by 'secretpassword';

See http://wiki.contribs.org/MySQL for additional information.

[william_syd]

is this possible without breaking any other appz

Probably not.

As per above post... create a new mySQL user.

You can do it with a menu'd script

Code: [Select]

mysql_setpermission