I went to MySQL.org, and there they have the odbc driver, and the MySQL client, but I need the MySQL server to run on my server. Does anyone know where I can get it, and if its at MySQL.org, then please tell me where because I couldnt find it.

Hey! I run mySQL on my 2K boxes.

Here is the link for it:

http://www.mysql.com/downloads/mysql-3.23.html

Hi, I was searching for threads on a similar topic to what I am after so thought best to reply here.

I have MySQL running on windows 2000. I am not too experienced myself with MySQL. I know it is all working but have a few questions.

Basically to add a MySQL database what would i do? I have WinmySQLadmin 1.3 running but am not sure how to:

1. Add a new user with there own username & password
2. Add a new database to a user.

I am sure it must be somthing simple but am not sure adn the MySQL documentation looks very daunting.

Any help grateful

Thanks

WinmySQLadmin 1.3 is not very easy to use.

DBTools http://www.dbtools.com.br/download.php is a really nice looking MySQL Admin tool ( regular Win32 exe )

Or of course

phpmyadmin ( from phpwizard.net ) ( written in PHP )

Thanks i downloaded and installed that. Just been setting it up and i have been playing about a bit.

Now I am not too familiar to MySQL rather as i am an Access person. Does it work the same way as an Access database? The user has the database uploads it to the webhost and connects to it through ASP/PHP/Whatever?

I see all these fields saying about table etc :eek:

I was expecting to see a bit to setup the user than somewhere i specify a link to the database? Or does it not work like this?

Thanks

Terry

You'll need to create a database and then use a DSN :)

We use Hosting Controller. Within it has a feature to let you add DSN's. Do these work for any ODBC compliant Database?

The user has options for

DSN NAME

DESCRIPTION

MICROSOFT ACCCESS > MICROSOFT EXCEL > OR SQL SERVER
(in a combo box)

SQL Server Entries :
Existing SQL Database name
SQL Server name (local)
Available SQL Server List


Basically I am trying to work out how a user would add a MySQL database?? :confused: