Getting Started with MYSQL on Windows 2000

[chidori]

Hi,

I've spent the past 2 hrs looking up online help documents but none of them seem to describe how I can get mysql server started. They start off with a bunch of command line arguments that are not meant for windows.

I am very experienced with using Access and SQL.
All I want to try to do is export my Access tables into one huge mysql table.
But before I can do that, how do I even interface with mysql server using windows? Right now I want to keep the whole thing local, so I want to run the server off my computer.


Thanks in advance!

 

[sleipnir214]

I would imagine to interface to MySQL from Win32 that you should use the MyODBC driver.

http://www.mysql.com/downloads/api-myodbc-3.51.html

______________________________________________________________________
Did you know?
The quality of our answers is directly proportional to the number of stars you vote?

 

[netrift]

You'll need to tell use what stage your currently at.
ie. have you downloaded the MySQL server yet?

cheers

http://www.netrift.com

- "making the world look your way"

 

[KarveR]

To start your mysql server, make sure that you have the path in your autoexec.bat file.

It should look similar to this:
PATH=c:\windows;c:\windows\command;c:\mysql;c:\mysql\bin;

Once this is in, reboot.
then start|run and type in mysqld and press enter.

This will start the database daemon.

Now to access it from command line do
start|run type in command and press enter.

from the c:> type in mysql and press enter.

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

 

[PCSAARON]

I found it right in the manual right from

http://www.mysql.com.

I did read a GOOD portion of it though, so you may have skipped over it. I know that I tend to want to throw the manual down right when I think I "KNOW" the answer. I am trying not to do that anymore! hehehe

To install into services on 2000 (Use what flavor you need ex: mysqld-max-nt) go to the c:\mysql\bin\ directory and then type:
mysqld-nt --install

Other ways to start it:
mysqld-nt --install-manual (Will not autostart)
mysqld-nt --standalone (Does not install as a service)

To shutdown the server:
mysqladmin -u root shutdown -p

Hope this helps. I found it very simple to setup the server.

Aaron

 

[pamino]

Hi Chidori

An easy way to install mysql on a Windows PC.

http://sourceforge.net/projects/phptriad

Download PHP Triad. It will install

MySql (DBMS)
PHP
Apache Webserver

Everything is installed under the c:\apache folder. Don't worry if you don't need PHP or Apache Webserver yet. The installer configures your Windows for MySql and even creates shortcuts to start/stop MySql started. You must read the read me file, it tells you how start the MySql login etc.

Later you can add MySQL as a Windows Service, but first try the above. Work fine.

Pamino

Later you can also