Reconfiguring MySQL at startup

Every time I restart my computer I also have to reconfigure MySQL using the
MySQL Server Instance Configuration Wizard. Otherwise root password doesnt
work in the MySQL command prompt. Is this just normal or can I make MySQL
automatically accept root password at startup?


************************************************************ ****************
Marek Burakowski
email: marek.burakowski@helsinki.fi

--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org

Re: Reconfiguring MySQL at startup

On 8/18/06, Marek Burakowski wrote:
>
> Every time I restart my computer I also have to reconfigure MySQL using the
> MySQL Server Instance Configuration Wizard. Otherwise root password doesnt
> work in the MySQL command prompt. Is this just normal or can I make MySQL
> automatically accept root password at startup?
>
>

We need windows and mysql version, along with the type of install, and
some error message, the way to reproduce the error would be good
too... With what you gave us we can only guess, and guess bad, whats
going on...

--
Daniel da Veiga
Computer Operator - RS - Brazil
-----BEGIN GEEK CODE BLOCK-----
Version: 3.1
GCM/IT/P/O d-? s:- a? C++$ UBLA++ P+ L++ E--- W+++$ N o+ K- w O M- V-
PS PE Y PGP- t+ 5 X+++ R+* tv b+ DI+++ D+ G+ e h+ r+ y++
------END GEEK CODE BLOCK------

--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org

Re: Reconfiguring MySQL at startup

--------------enig1513EAE1B486DC684B7C0BE7
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

> Every time I restart my computer I also have to reconfigure MySQL
> using the MySQL Server Instance Configuration Wizard. Otherwise root
> password doesnt work in the MySQL command prompt. Is this just normal
> or can I make MySQL automatically accept root password at startup?

I think you have used the windows installer. Try it first when a fresh
reinstall. Uninstall MySQL server and delete the MySQL server under
Program Files.

Then, reinstall MySQL. MySQL shall already start during startup. Check
Administrative Tools - Services. You shall see MySQL running automatic
during startup.

try to telnet on port 3306 or the port you specified during the
installation during startup

$ telnet localhost 3306

If it responds with some random characters. It means MySQL is already
running.

When you try to connect to MySQL with a mysql client. Use

$ mysql -u root -p
Enter password: *****


--------------enig1513EAE1B486DC684B7C0BE7
Content-Type: application/pgp-signature; name="signature.asc"
Content-Description: OpenPGP digital signature
Content-Disposition: attachment; filename="signature.asc"

-----BEGIN PGP SIGNATURE-----
Comment: GPG Public Key: https://www.biglumber.com/x/web?qs=0x4A256EC8
Comment: GPG Public Key: http://www.lorztech.com/GPG.txt
Comment: Google, Skype, Yahoo ID: michaellouieloria

iQEVAwUBROu2+7XBHi2y3jwfAQogaAf8CxlQaE9TR7MzTCvCL6DWw2vgVFRE XJVT
r+tNiFMMmJhShTzsJFAo0DKtJ2iSlFnsuJk7y1OZlmNO/Uc4WJa+QyWZfKp9 0xmd
YmWBIjh3Ab2XWGWWw7MiClGKDZI7PDR5xEQvqgK/ifm+FoMdVokj6i11gj7x rUJX
DtSTvIcJeqMeO4KtzNf7FhDqKtchQvHTynvcP1IQh3tF6qT3oeb36nuInZ6Q 8eQr
y63yXoyZh95ckl0bLt0D0XQ/CTS0YDwzQ028ZFcz4DmjWIeo9lyEitZJeAai n8T9
3eMYUHnHtFk5A9cZ+axLsLjd9yIs7fFwZoYy+EQQrUFD2mx7kFxbug==
=1wib
-----END PGP SIGNATURE-----

--------------enig1513EAE1B486DC684B7C0BE7--

Re: Reconfiguring MySQL at startup

Ok, I got it working now. The problem was the firewall which had to be
manually given the permission to accept MySQL(it normally prompts for rule
changes.)

> Weird. I reinstalled MySQL, and it is running as a service from startup
> now,
> but I still cannot connect to it. Could it be that my firewall is
> blocking
> access? When trying:
> telnet localhost 3306
> I responds cannot connect to host... connection failed (or something
> similar
> since I'm not using English WinXP).
> mysql -u root -p and the correct password gives ERROR 2003: Can't connect
> to
> MySQL server on 'localhost' (10061), and the same happens when using php
> scripts that connect to MySQL.
> I am using the latest MySQL with WinXPsp2 and my Firewall is F-Secure
> Client
> Security 6.0.
>



************************************************************ ****************
Marek Burakowski
email: marek.burakowski@helsinki.fi

--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org