Reconfiguring MySQL at startup
Marek Burakowski <[email protected]>
| Newsgroups | gmane.comp.db.mysql.windows |
|---|---|
| Message-ID | <[email protected]> |
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: [email protected] ----- Edelleenlähetetty viesti päättyy ----- **************************************************************************** Marek Burakowski email: [email protected] -- MySQL Windows Mailing List For list archives: http://lists.mysql.com/win32 To unsubscribe: http://lists.mysql.com/[email protected]