Web Wiz Forums - mysql install problem

Print Page | Close Window

mysql install problem

Printed From: Web Wiz Forums
Category: Web Wiz Web App Support Forums
Forum Name: Web Wiz Forums
Forum Description: Support forum for Web Wiz Forums application.
URL: https://forums.webwiz.net/forum_posts.asp?TID=22021
Printed Date: 08 April 2026 at 3:03pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: mysql install problem

Posted By: wrc2376
Subject: mysql install problem
Date Posted: 25 November 2006 at 4:26am

I am on the mysql setup page and it wants me to put a different user name and password to create the database that is different from the connection string. My hosting provider only allows the one user name and password for the database so I am unable to create the tables and such. Is there any way around this so I can continue with the install?

Replies:

Posted By: WebWiz-Bruce
Date Posted: 26 November 2006 at 10:14am

You can enter the same username and password in the setup tool. It only asks for a different one because sometimes hosts will give two usersnames, one for general use and a more relaxed one for creating and altering tables. In your case you only have the one set so just use that.

-------------
https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting
https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting

Posted By: wrc2376
Date Posted: 26 November 2006 at 4:48pm

I had assumed the problem was I needed a different user ID and password. I keep getting this error when I try to create the tables in the empty database. I have double checked my connection string several times and know it is correct. I have several other mysql databases that work correctly so I'm not sure what is wrong.

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.

Solved the problem Thanks for your help