Posted by Alvaro G. Vicario on 09/02/06 09:34

*** 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:

shell> mysql -u root
mysql> SET PASSWORD FOR 'root'@'localhost' = PASSWORD('newpwd');
mysql> SET 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
--

• Next in forum: Re: phpmailer.class messages are been converted to plain text...
• Prev in forum: Re: do professional PHP programmers use error checking in their code?
• Thread view: Re: setting password for root

[Reply to this message]