Reconfiguring MySQL at startup

Reconfiguring MySQL at startup

am 23.08.2006 09:54:01 von Marek Burakowski

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.


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


************************************************************ ****************
Marek Burakowski
email: marek.burakowski@helsinki.fi
----- Edelleenlähetetty viesti päättyy -----


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