Topic: mySQL password

[Randy Brown]

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

[Randy Brown]

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

[ol]

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;

[Randy Brown]

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.

[Dan Brown]

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

[Randy Brown]

Thanks Dan,

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