Re: 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?

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

-----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+7XBHi2y3jwfAQogaAf8CxlQaE9TR7MzTCvCL6DWw2vgVFREXJVT
r+tNiFMMmJhShTzsJFAo0DKtJ2iSlFnsuJk7y1OZlmNO/Uc4WJa+QyWZfKp90xmd
YmWBIjh3Ab2XWGWWw7MiClGKDZI7PDR5xEQvqgK/ifm+FoMdVokj6i11gj7xrUJX
DtSTvIcJeqMeO4KtzNf7FhDqKtchQvHTynvcP1IQh3tF6qT3oeb36nuInZ6Q8eQr
y63yXoyZh95ckl0bLt0D0XQ/CTS0YDwzQ028ZFcz4DmjWIeo9lyEitZJeAain8T9
3eMYUHnHtFk5A9cZ+axLsLjd9yIs7fFwZoYy+EQQrUFD2mx7kFxbug==
=1wib
-----END PGP SIGNATURE-----