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



Print Page | Close Window

Forum Software by Web Wiz Forums® version 12.08 - https://www.webwizforums.com
Copyright ©2001-2026 Web Wiz Ltd. - https://www.webwiz.net