setting password for root

[Bob]

I'm just starting PHP and MySQL - and really like the book by Welling
and Thomsom.

I've installed MySQL on my WinXP desktop, along with Apache and PHP. I
have not figured out how to set a password for the root account. I've
been able to set up a user account for myself, with a password, but not
the root account. I understand this is not ideal.

I've tried setting the password in My.ini but it doesn't seem to work.
I must be doing something wrong. Can anyone suggest what I should be
doing. TIA

[Jerry Stuckle]

Bob wrote:

I'm just starting PHP and MySQL - and really like the book by Welling
and Thomsom.

I've installed MySQL on my WinXP desktop, along with Apache and PHP. I
have not figured out how to set a password for the root account. I've
been able to set up a user account for myself, with a password, but not
the root account. I understand this is not ideal.

I've tried setting the password in My.ini but it doesn't seem to work.
I must be doing something wrong. Can anyone suggest what I should be
doing. TIA

Well, for one thing you're asking a MySQL question in a PHP newsgroup.

Try comp.databases. mysql.

--
=============== ===
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
js*******@attgl obal.net
=============== ===

[wayne]

Bob wrote:

I'm just starting PHP and MySQL - and really like the book by Welling
and Thomsom.

I've installed MySQL on my WinXP desktop, along with Apache and PHP. I
have not figured out how to set a password for the root account. I've
been able to set up a user account for myself, with a password, but not
the root account. I understand this is not ideal.

I've tried setting the password in My.ini but it doesn't seem to work.
I must be doing something wrong. Can anyone suggest what I should be
doing. TIA

Go to this site:
http://dev.mysql.com/doc/refman/5.0/...rmissions.html

Details on setting a password if one was never set and changing it if
you set one and have forgotten what it is.

--
Wayne
http://www.glenmeadows.us
With or without religion, you would have good people doing good things
and evil people doing evil things. But for good people to do evil
things, that takes religion.
—Steven Weinberg

[Alvaro G. Vicario]

*** Bob escribió/wrote (1 Sep 2006 16:49:19 -0700):

I've installed MySQL on my WinXP desktop, along with Apache and PHP. I
have not figured out how to set a password for the root account. I've
been able to set up a user account for myself, with a password, but not
the root account. I understand this is not ideal.

I've tried setting the password in My.ini but it doesn't seem to work.
I must be doing something wrong. Can anyone suggest what I should be
doing. TIA

That's explained in the "Securing the Initial MySQL Accounts" chapter:
For Windows, do this:

shellmysql -u root
mysqlSET PASSWORD FOR 'root'@'localho st' = PASSWORD('newpw d');
mysqlSET PASSWORD FOR 'root'@'%' = PASSWORD('newpw d');

Read the whole chapter, though, there're other concerns.

--
-+ http://alvaro.es - Álvaro G. Vicario - Burgos, Spain
++ Mi sitio sobre programación web: http://bits.demogracia.com
+- Mi web de humor con rayos UVA: http://www.demogracia.com
--

[Bob]

Thanks for all your help. It's working fine now.

I'll try to keep the MySQL questions for another group.