Need Help Installing PP

[geck]

Hello,

I believe I have uploaded everything correctly to my public_html folder in my new account at eleven2.com. I also think I configured the pixelpost.php file correctly with the info I created in the MySQL cPanel:
user name (geck)
password (XXXXXX)
localhost (localhost)
datebase (geckblog)

I try to run the installer at http://www.geckonia.com/pixelpost/admin/install.php but get this error when the page loads:
_________________________________________________
Warning: mysql_connect(): Access denied for user 'geck'@'localhost' (using password: YES) in /home/geckonia/public_html/pixelpost/admin/install.php on line 38
Error: Access denied for user 'geck'@'localhost' (using password: YES)
_________________________________________________

blog is going to be located at www.geckonia.com
My user name is geck

Here's what the MySQL page says:
__________________________________
MySQL Account Maintenance


Databases:
geckonia_geckblog
Users in geckblog
geckonia_geck (Privileges: ALL PRIVILEGES)
Connection Strings
Perl $dbh = DBI->connect("DBI:mysql:geckonia_geckblog:localhost"," geckonia_geck","<PASSWORD HERE>");
PHP $dbh=mysql_connect ("localhost", "geckonia_geck", "<PASSWORD HERE>") or die ('I cannot connect to the database because: ' . mysql_error());
mysql_select_db ("geckonia_geckblog");

User: Db:
Privileges: ALL ALTER CREATE TEMPORARY TABLES CREATE DELETE DROP SELECT INSERT UPDATE REFERENCES INDEX LOCK TABLES

Db:
Users:
geckonia_geck
UserName:
Password:

Access Hosts:
localhost
Host (% wildcard is allowed):

phpMyAdmin
You can use phpMyAdmin to administrate your MySQL databases in a web based environment.
__________________________________________________

Can anyone tell me where I went wrong?

TIA,
geck

[Rodney-E2]

This is becasue you do not have a database username added. You are just using the username: geck

it will be in the format like geck_geck or whatever you add.

[Joe[y]+]

geckonia_ is the prefix you need to add to your database details and username.

[geck]

Thanks! I tried everything I could think of, but keep getting this new error:

Error: No database selected

here is my cpanel mysql page:


if that is correct, how should I fill out these fields?
(assume my password is xxxxxx)

$pixelpost_db_host = "replace_me"; // database host, often "localhost"
$pixelpost_db_user = "replace_me"; // database user
$pixelpost_db_pass = "replace_me"; // database user password
$pixelpost_db_pixelpost = "replace_me"; // database

When I have the pixelpost.php file correct, is it ok just to replace that file on the server, or do I need to reinstall the whole folder.

Thanks again.
geck

[ranko]

i think

$pixelpost_db_host = "localhost"; // database host, often "localhost"
$pixelpost_db_user = "geckonia_geck"; // database user
$pixelpost_db_pass = "xxxxxx"; // database user password
$pixelpost_db_pixelpost = "geckonia_geckblog"; // database

should do it. (note that only the database and database user need the geckonia_ prefix.) then you can just replace the pixelpost.php file, no need to re-upload the whole folder.

good luck!

[geck]

I'm in! Thank you.