Re: can't connect to MySql server on 'localhost' <10061>

[Sergio Oliveira]

Hi,

I installed MySQL Server on my computer, following the steps:

a) if you installed once and the server is not running, verify if the service of MySQL is up;
b) remove any installation of this server on your machine. If you installed a version and this don't work, remove ALL installation and start of the "begin" again;
c) sometimes, some traces of the installation stay on windows regkey. Use the REGEDIT to remove them;
d) restart your machine and verify if it's clean. You don't need disable the firewall. I use the McAfee Firewall and didn't have problems;
e) be a administrator or have power for this;
f) begin the installation. I prefer the custom mode;
g) follow the steps of installation;
h) if you remove all traces or don't have nothing, probably you won't have problems;
i) the firewall will ask you about the access power of the mysql.exe and mysqld-nt.exe files. I give "total access" how server (in/out), but when I connect the internet I block this.
j) installation finished! Verify the file my-dist.cnf on MySQL directory;
k) if you installed MySQL on C:\, forget this step. Stop the MySQL service and save this file on C:\WINDOWS or C:\WINNT directory (see your OS), with the name "my.ini" doing the changes on [mysqld] point:

# The MySQL server
[mysqld]
# The path of MySQL
basedir=d:/mysql/
# The path of MySQL data files. You can install this on any drive
datadir=d:/mysql/data/

l) start the MySQL service;
m) on prompt, go to \mysql\bin and call mysql command;
n) the MySQL is prompt to your password;
o) the MySQL is running;

Good luck!