Web Wiz Support and Community Forums : Problems conncting MySQL https://forums.webwiz.net/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Sat, 11 Apr 2026 13:24:59 +0000 Sat, 10 Jun 2006 18:08:57 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.08 360 https://forums.webwiz.net/RSS_post_feed.asp?TID=20248 <![CDATA[Web Wiz Support and Community Forums]]> https://forums.webwiz.net/forum_images/web_wiz_forums.png https://forums.webwiz.net/ <![CDATA[Problems conncting MySQL : Now working fine - ISP uninstalled...]]> https://forums.webwiz.net/problems-conncting-mysql_topic20248_post108820.html#108820 Author: lydbury
Subject: 20248
Posted: 10 June 2006 at 6:08pm

Now working fine - ISP uninstalled and reinstalled the ODBC drivers. Sorted.

Duncan


Edited by lydbury - 11 June 2006 at 5:24pm]]> Sat, 10 Jun 2006 18:08:57 +0000 https://forums.webwiz.net/problems-conncting-mysql_topic20248_post108820.html#108820 <![CDATA[Problems conncting MySQL : The ISP says:You can connect to...]]> https://forums.webwiz.net/problems-conncting-mysql_topic20248_post108780.html#108780 Author: lydbury
Subject: 20248
Posted: 09 June 2006 at 9:50pm

The ISP says:

You can connect to localhost (the fact phpMyAdmin can proves that).

Looking at your server the database also looks OK.

My database_connection.asp file seems fine - so I am totally confused. The ISP is looking at my files but I would still be very grateful for any thoughts.

Duncan




]]> Fri, 09 Jun 2006 21:50:23 +0000 https://forums.webwiz.net/problems-conncting-mysql_topic20248_post108780.html#108780 <![CDATA[Problems conncting MySQL : localhost was the name given me...]]> https://forums.webwiz.net/problems-conncting-mysql_topic20248_post108772.html#108772 Author: lydbury
Subject: 20248
Posted: 09 June 2006 at 6:13pm

localhost was the name given me by the ISP. And I did change the dbName to "grammar".

But I am checking with the ISP. All thoughts most welcome.

]]> Fri, 09 Jun 2006 18:13:14 +0000 https://forums.webwiz.net/problems-conncting-mysql_topic20248_post108772.html#108772 <![CDATA[Problems conncting MySQL : he did not changed the name of...]]> https://forums.webwiz.net/problems-conncting-mysql_topic20248_post108769.html#108769 Author: angel
Subject: 20248
Posted: 09 June 2006 at 5:14pm

he did not changed the name of the server to his own server and the db name to his own.]]> Fri, 09 Jun 2006 17:14:46 +0000 https://forums.webwiz.net/problems-conncting-mysql_topic20248_post108769.html#108769 <![CDATA[Problems conncting MySQL : Make sure the details of the mySQL...]]> https://forums.webwiz.net/problems-conncting-mysql_topic20248_post108768.html#108768 Author: WebWiz-Bruce
Subject: 20248
Posted: 09 June 2006 at 4:23pm

Make sure the details of the mySQL database are entered correctly.

Check with your web hosts you can use 'loclahost' to connect to the server.
]]> Fri, 09 Jun 2006 16:23:39 +0000 https://forums.webwiz.net/problems-conncting-mysql_topic20248_post108768.html#108768 <![CDATA[Problems conncting MySQL : I have been running the access...]]> https://forums.webwiz.net/problems-conncting-mysql_topic20248_post108767.html#108767 Author: lydbury
Subject: 20248
Posted: 09 June 2006 at 4:14pm

I have been running the access version for years and years - but now have MySQL available. So I am quite new to MySQL. Am using PHPMyAdmin. All this is on a remote server. PHPMYAdmin is setting up an empty database fine. I have edited the database_connection.asp file. Now I am trying to use mySQL-server_setup.asp and that is where I start getting problems.

In brief:

I have made an empty database named grammar.

I have set up:

        strSQLServerName = "localhost" 'Holds the name of the SQL Server (This is the name/location or IP address of the SQL Server)
        strSQLDBUserName = "username" 'Holds the user name (for SQL Server Authentication)
        strSQLDBPassword = "password" 'Holds the password (for SQL Server Authentication)
        strSQLDBName = "grammar"

in the database_connection.asp



Then I go to mySQL_server_setup.asp and enter the username and password and I get:

Error Connecting to database on mySQL Server

Check the following is set up and correct:-

mySQL Server User Name
mySQL Server Password
Name of the mySQL Server
Database name set up by you on the server
Empty Database set up by you on the mySQL Server

Check also that you have entered the correct details in the file 'database_connection.asp' found in the 'database' directory.

Can't see what I have done wrong. Grateful for any ideas you might have

Duncan



]]> Fri, 09 Jun 2006 16:14:36 +0000 https://forums.webwiz.net/problems-conncting-mysql_topic20248_post108767.html#108767