phpMyAdmin & Shared Server

[ginakra]

Hi all,

I'm looking at signing up with a web host that has no way to create or manage databases, or create users and passwords through the Control Panel. I have always had access to phpMyAdmin in the past. This would be a shared hosting environment.

I tried uploading phpMyAdmin to my current shared environment (they have phpMyAdmin provided), changing the config with my url path, username and password, and I keep getting:
Error
MySQL said:
Access denied for user: 'myusername@localhost' (Using password: YES)

Has anyone set up phpMyAdmin in a shared hosting environment in their own space and get it working? Please help.

[[deleted]]

The error you get is plain enough;the username and/or password are incorrect.

Most likely the database server is not setup to allow 'myusername' to connect from 'localhost' with the given password. Try replacing 'localhost' with the real hostname.

[ginakra]

Well, when I use a php script, and there's a config file that asks for the host, username, password, and database name, I get the connection fine and the script works fine, makes the table or whatever it needs to do. I put the same info into phpMyAdmin and it doesn't connect.

The host is 'localhost'--unless I'm missing something, whatever I input in the scripts should work with phpmyAdmin, right?

[nevrar]

it's just a wild guess, but try setting
$cfgServers[1]['only_db'] to be your database....