Koozali.org: home of the SME Server

Legacy Forums => Experienced User Forum => Topic started by: Randy Brown on September 21, 2001, 10:41:01 AM

Title: mySQL password
Post by: Randy Brown on September 21, 2001, 10:41:01 AM

Hi everybody.

  The new sme looks pretty good to me so far, however the mySQL password that I used before is nor longer useable/readable.
so would somebody please tell me how to find the mySQL root password, or better yet tell me how to creat new mysql users.

thanks a bunch
randy

Title: Re: mySQL password
Post by: Randy Brown on September 24, 2001, 11:48:09 AM

Please forgive my ignorance... my ssh program was cuting off the end of my password. i do fell somewhat like an idiot. lol

root password is not hashed or anything, it is just much longer that it used to be.

still if anybody knows of a good (short and to the point) how to use mysql would you please point me in the right direction?

I would like to add mysql users, but the mysql documention is very larg and I dont have the time to research it properly.
thanks a bunch

Randy

Title: Re: mySQL password
Post by: ol on September 24, 2001, 09:17:21 PM

mysql password  v5 e-smith
consol mode
shell> mysql -u root mysql
mysql> UPDATE user SET Password=PASSWORD('new_password') WHERE user='root';
mysql> FLUSH PRIVILEGES;

Title: Re: mySQL password
Post by: Randy Brown on September 25, 2001, 04:36:16 AM

thanks ol for the dir, but this is unneeded unless you wnat to change the root password ( i think ).

What I want to do is add new mySQL users.

Title: Re: mySQL password
Post by: Dan Brown on September 25, 2001, 04:39:00 AM

a forum search on mysql grant should find what you're looking for--it's been discussed many times before.

Title: Re: mySQL password
Post by: Randy Brown on September 25, 2001, 05:00:45 AM

Thanks Dan,

  It helped a bunch to know what I was looking for.
Randy