Database Discussion - mysql on localhost

Print Page | Close Window

mysql on localhost

Printed From: Web Wiz Forums
Category: General Discussion
Forum Name: Database Discussion
Forum Description: Discussion and chat on database related topics.
URL: https://forums.webwiz.net/forum_posts.asp?TID=16353
Printed Date: 29 March 2026 at 4:41am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: mysql on localhost

Posted By: RCorr
Subject: mysql on localhost
Date Posted: 27 August 2005 at 12:09pm

hello,

I have been searching the web for documentations on connecting to a mysql database through a website on localhost. Does anyone know a web site that provides an easy straight forward step-by-step tutorial?

Do I need to move mysql db from c drive to the wwwroot folder? If so, where do I place it? Or can I connect to it where it is currently resides at C:\Program Files\MySQL\MySQL Server 4.1\bin\?

Any help will be appreciated,

Ronan

Replies:

Posted By: michael
Date Posted: 27 August 2005 at 1:49pm

You should not have to move anything. For a local DB you can simply connect like

DRIVER={MySQL ODBC 3.51 Driver};SERVER=localhost;DATABASE=myDatabase;USER=myUsername;PASSWORD=myPassword;OPTION=3

-------------
http://baumannphoto.com" rel="nofollow - Blog | http://mpgtracker.com" rel="nofollow - MPG Tracker

Posted By: RCorr
Date Posted: 27 August 2005 at 2:52pm

Thanks Michael,

I am making progress with connecting to a mysql db on localhost, but not quite there yet. I have downloaded MySQL ODBC 3.51 and now following the steps on this page http://dev.mysql.com/doc/mysql/en/dsn-on-windows.html - http://dev.mysql.com/doc/mysql/en/dsn-on-windows.html to connect to a mysql database. I have not created a new user and password, so I am using root as the username and the password field is blank.

this is what I have:
Data Source name: myODBC
Description:test

Server: localhost

User: root

Password:

Database: fruits

When I click the test connection button this is the error I get:

[MySQL][OBDC 3.51 Driver]Can't connect to MYSQL server on 'localhost'

I tried testing the connection again after running MYSQL, but I get the same error. Any futhur assistant will be appreciated.

Thanks,

RPCorr

Posted By: michael
Date Posted: 28 August 2005 at 11:01pm

Is the mySQL service running? Are you able to connect with any client tools?

-------------
http://baumannphoto.com" rel="nofollow - Blog | http://mpgtracker.com" rel="nofollow - MPG Tracker

Posted By: RCorr
Date Posted: 29 August 2005 at 11:42am

Michael,

I checked the window services pane and MySQL41 status reads "started". I am not sure what you mean if I am "able to connect with any client tools?" The only way I know how to connect to MySQL is by opening the MySQL server 4.1 command prompt.

RCorr

Posted By: zaboss
Date Posted: 29 August 2005 at 1:35pm

There are several tools available, including one on the MySQL webpage, mySQL Administrator, similar to Enterprise Manager for MS SQL. I use MySQL Front. It was discontinued, but I got used to it and it's all I need.

-------------
Cristian Banu
http://www.soft4web.ro - Soft 4 web