Could not connect

[turtle11boy]

When i click on "install" I receive the following two errors:

Could not connect to database; check your settings.
The mySQL error was: Access denied for user 'blog'@'lux2.uits.indiana.edu' (using password: YES)

I've set up a user profile in mysql for "blog" and it contains the same username and password I put into the ../serendipity/index.php install screen.

My mysql server is hosted by my university, and their webpage says the following:
•Connections to/from the MySQL service are restricted to Webserve and direct logins to the MySQL servers. As such, you are unable to use desktop MySQL clients to manage your databases or connect to your databases from servers other than Webserve.

Maybe this affects it? Maybe, but the serendipity files are all located within my university webserve account. Does serendipity still attempt somehow to install from the "outside?" Or, what else might be the problem?

Thanks

[garvinhicking]

Hi!

That means in the installation interface you enter access data to the mysql database that is not valid/recognized by the database server.

You might want to try "localhost" or "127.0.0.1" as database host, instead of your domainname, to force an internal mysql connection.

HTH,
Garvin

[turtle11boy]

Okay, I tried without success.

If neither of those work, is there anything else I could try.

[kleinerChemiker]

Ask your University. This is not a S9y problem, but a problem of your hoster. We can only guess but they should know.

[garvinhicking]

Hi!

Also, the username "blog" sounds to me as if it might not be the proper username. Your University might have given you another username, often a number or something like "webuser2001223", or whatver. The Database username&password must exist already, your provider must have given that to you, can you confirm thjat?

REgards,
Garvin

[turtle11boy]

I added "blog" myself, via phpmyadmin. I also tried using other usernames that work for accessing mysql data i already have, including the "root" user.

If I contacted the school webmaster, how could i describe the problem so that they'd know where the issue is?

Thanks

[garvinhicking]

Hi!

You should use the exactly same username, hostname and password as configured in phpMyAdmin - with that it should work!

If I contacted the school webmaster, how could i describe the problem so that they'd know where the issue is?

Tell him you need an exact Database host, username and password that you can use in PHP applications installed in your webspace.

HTH,
Garvin