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]
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.