getting a windows environ. going 2

[costarica1]

I have been requested to learn mysql server / db design from a new partner. I am happy to have finally realized the option from using MS database's to run my websites.

So now, here I am just downloaded the windows releases (with installer) and cf admin and control panels all installed. My problem now is I dont know what to do next. I played with it in dos and at least found an error message.

ERROR 2003: Can't connect to MySQL server on 'localhost' (10061)

At least I found out an error message, thats at least progress. Any help, basically i know that somehow I have to get the mysql server running as a process or inegrate it into IIS .. I just am trying to build websites, running the servers is just going way beyond my little world.

thanks, Michael

 

[TonyGroves]

Are you sure port 10061 is right? The MySQL server defaults to port 3306.

-----
ALTER world DROP injustice, ADD peace;

 

[costarica1]

The problem seems to be that I am not properly initializing the server at all on bootup. I was reading the docs

http://dev.mysql.com/doc/mysql/en/Windows_prepare_environment.html

and it says something about a my.ini file that needs to go on the C:\ drive during startup. I added this:

[mysqld]
# set basedir to your installation path
basedir=C:/mysql
# set datadir to the location of your data directory
datadir=G:/mysql/data

to my.ini file. So now I wonder what I need to do. Just tried to execute c:\mysql\bin\mysql.exe and it still give the same error message.

ALSO about the ports: I dont know what that number meant, nor am I good at setting which port goes where.

 

[TonyGroves]

The INI file you have is right (assuming the paths are right), but it needs to be named either c:\my.cnf or c:\winnt\my.ini or c:\windows\my.ini. Also, if during installation you specified a port number different to the default of 3306 (normally you would not), you need to specify this in the [mysqld] section of the file, with the line:
[tt]port=12345[/tt]

Then, assuming you are running Windows NT/2000/XP, you would want to install it as a service. To do this, run:
[tt]c:\mysql\bin\mysqld --install[/tt]
To start the service, you can run:
[tt]net start mysql[/tt]

You should then be able to use mysql or any other client program.

-----
ALTER world DROP injustice, ADD peace;

 

[KarveR]

ERROR 2003: Can't connect to MySQL server on 'localhost' (10061)

10061 is the eroor code for "access denied" normally due to a service not being available (i.e not successfully started), most commonly seen in *nix questions.

you need to strat the mysql daemon(the server) before you will be able to use mysql.exe (the client) to connect.

Ensure that you have administrator privileges and RTFM, its all very well documented and the troubleshooting section tells you what you need to know.

______________________________________________________________________
There's no present like the time, they say. - Henry's Cat.

 

[costarica1]

Tony,

much thanks for the help, you got me up and running, which was really good cause my guy was waiting for a progress report .. so it kept things good, at least I had something to tell the guy. Stoked.. now I am using that manager to create a few databases and design them. So much beter than Access ( probably a bad word in this forum ) .. I wish I had set this up years ago.

The only things I am looking into now are: connecting to these datasources in colfusion and then once I learn that, going to convert a few websites from access dsn's to mySQL . . ooohhh what fun.

Much thanks & a star if I may.

MC