Can't log on using MySQL Front

[nlcc]

Well, I've tried everything I can think of but getting no where.

Here's the error message I'm getting:

Connection failed
2005-Unknown MySQL Server Host’mysql01.powweb.com’

In the long run, I'm trying to get a counter to work that requires php and My SQL which I picked up at
http://www.ep-dev.com/modules.php?name=Downloads&d_op=viewdownload&cid=3

Any help would be much appreciated.

TIA

Mike H.

[SLSTEK]

You need a MySQL host/server such as mysql01.powweb.com or whatever was assigned to you.

You need a hostname/IP
You need a database (name)
You need a username
You need a password

With these four things previously obtained/generated on Powweb, you should be able to connect via MySQL-Front using that MySQL info.

Be sure you are using a MySQL username and password and not your OPS or FTP username/password info, because they are normally different (unless you set them to be the same). You generate a user and password in the MySQL section of OPS...

Good Luck!

[nlcc]

Thanks for your responce and help.

I think I may be missing what my actual host name is for this. This is what I going by that I get on the powweb MySQL site:


hostname/IP:mysql01.powweb.com
You need a database: xxxxx
You need a username"xxxxx
You need a password: xxxxxxxxxx

Is mysql01.powweb.com not my hostname/IP.

I've tried to use our sites url but that didn't work

TIA


Mike H.

[alphadesk]

When it ask for hostname for mysql use:
mysql01.powweb.com

Remember it's case sensitive for all.
hostname
db name
user
pass

What are you installing that uses mysql?

[SLSTEK]

nlcc -- for security reasons, I would not post any of your personal info here and you should go back and star out your database name and user name as well like you did for the password. Nobody else needs to know that info on here or elsewhere... :)

[nlcc]

Thanks for the privacy tip.

This is the error message:

Connection failed
2005-Unknown MySQL Server Host’mysql01.powweb.com’

Which I'm to believe is the host name provided by powweb.

Regarding case-sensative.....I believe that I have been doing that.

Reason, I'm trying to get MySQL working originally for a PHP Quz that I was working on. I've sort of put that on hold because of my knowledge deficit regarding PHP/MySQL.

For this project I started using a php/counter that I picked up at:
http://www.ep-dev.com/modules.php?name=Downloads&d_op=viewdownload&cid=3

However, as it seems If got the script working, it looks like to have it work completely, I need to change all my pages to have a .php extension......that's not ok Site is over a hundred pages......hum....this learning curve is a killer...lol

[SLSTEK]

Log onto ops.powweb.com
Go to your package
Go to the MySQL page
check to see what your MySQL server name is there. If it is not mysql01.powweb.com as you think, then it may be your website's server name or maybe mysql02, etc.

Just go double check and see and cut and paste the info directly to get it correct for MySQL-Front and any other apps or PHP that may use that info on your site.

mysql01 is a "zero" also...

[nlcc]

Hum, I think that is what I have been doing to prevent any errors, I've just cut and paste.

I have to run about an hour or so errands then I'll come back and make some screen shots to show you what I am seeing.

TIA
Mike H.