New MySQL DB giving 1045 error

Problem: Getting 1045 on new MySQL DB from phpmyadmin access.

Sucessfully activated MySQL, created DB and user/password pair. Admin page shows: "Your mySQL database <name> is hosted on PowWeb's server mysql03.powweb.com"

Here <name> is DB name I gave.

Admin page shows user name with Y in all privileges fields.

Followed link from admin page to http://phpmyadmin.powweb.com/?server=52 to phpmyadmin login page with username text box and server choice drop down set correctly.

Input password and submit, get: "#1045 - Access denied for user: '<user> @<IP address>' (Using password: YES)"

Here <user> and <IP address> stand for the actual strings.

phpmyadmin tries to set cookie, contents are:

Name: pma_cookie_username
Domain: phpmyadmin.powweb.com.
Path: /
Data: <user>+

I read the FAQ and searched existing posts for similar. AFAIK fields are correct, especially the ones admin page fills in itself. Really only leaves password, which I have reset a few times to confirm typing it correctly.

This is about the limit of diagnosis I can do. Have not checked access through php script yet.

I have just taken over admin job for this account, not too familiar with powweb. Tried to telent in and run mysql from command line to see what happened there, but nothing is listening on telnet port; probably telnet is disabled. Have not looked in FAQ to find out about telnet status on powweb yet.

Thanks in advance for any suggestions regarding getting MySQL up and running.

Suwanee River
way down upon the; far, far away

[alphadesk]

There is no "telnet" access or any remote access at all for mysql.

The most common errors are a space before or after a username ... pass ...etc. or a case sensitive issue. Make sure you don't have a space and using the proper case.

Thanks alphadesk for the reply.

Since initial post ftp'ed a php script to try DB access that way, no joy:

$db = mysql_connect("","user","pass");
if( ! $db ) {
Error_handler( "Error in mysql_connect" , $db );
} else {
echo "Connected<br />\n";
}

(user and pass being replaced with actual strings)

Script execution follows error branch -> no valid db handle.

Tried with localhost as arg, which also failed.

Copied and pasted username and password between os.powweb and script, so little chance here for extra spaces, case changes, etc.

Never saw this with MySQL before, maybe just takes awhile for DB to be exposed, but oc.powweb can see it.

[alphadesk]

Since this a "NEW" DB I suggest you start from scratch.

Delete the users and rename the DB ... give the server time to update (maybe 30 minutes) ... then add the users with pass back.

AlphaDesk,

Thanks for the suggestion. Created new DB and left it lie last evening. Looks like everything synched up in the wee hours, as the mySQL dolphin is liking the phpMyAdmin purple pill now. My php test script also runs.

Forum is great resource, saved me calling up tech support. Expect I will be here from time to time as long as I admin these guy's site.

Now the real fun can commence. Client wants lots of DB-backed tools, should be a blast.

Suwanee River
way down upon the; far, far away
http://gsfrrhs.org