Koozali.org: home of the SME Server

Obsolete Releases => SME Server 7.x => Topic started by: fixit on October 08, 2007, 04:07:56 AM

Title: need info to change mysql password
Post by: fixit on October 08, 2007, 04:07:56 AM

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

Title: Re: need info to change mysql password
Post by: pfloor on October 08, 2007, 06:58:16 AM

Quote from: fixit on October 08, 2007, 04:07:56 AM

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.

Title: Re: need info to change mysql password
Post by: william_syd on October 08, 2007, 07:42:03 AM

Quote from: fixit on October 08, 2007, 04:07:56 AM

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