468,272 Members | 2,165 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,272 developers. It's quick & easy.

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

Sep 1 '06 #1
4 1292
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*******@attglobal.net
==================
Sep 1 '06 #2
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
Sep 2 '06 #3
*** 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'@'localhost' = PASSWORD('newpwd');
mysqlSET PASSWORD FOR 'root'@'%' = PASSWORD('newpwd');

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
--
Sep 2 '06 #4
Bob
Thanks for all your help. It's working fine now.

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

Sep 3 '06 #5

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

16 posts views Thread by John | last post: by
reply views Thread by David Ehmer | last post: by
1 post views Thread by Adam Smith | last post: by
reply views Thread by NPC403 | last post: by
reply views Thread by zattat | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.