• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 560
  • Last Modified:

mysql basic question: help installing gallery2

Am trying to install gallery2 on my website; and its asking me for my MySQL database username and password.

Haven't the foggiest.

As described in the screenshots; I went into my hosting web console; pressed 'create a database'; tried the username & password but it doesn't seem to work. . And as I said - I haven't a clue what i'm doing!

Any advice / suggestions appreciated.
sql1.JPG
sql2.JPG
sql3.JPG
sql4.JPG
sql5.JPG
sql6.JPG
0
callmecheez
Asked:
callmecheez
  • 3
  • 3
1 Solution
 
minibagoCommented:
Hi,

From your screenshots it looks like the database you created is called: web163-cdp (from the list on the very left of the phpMyAdmin screen) which would make sense as that is also the username.

In your Gallery2 install screen you have 'gallery2' in the 'DB Name' field. If you change that to web163-cdp it should work.

=)
0
 
callmecheezAuthor Commented:
Thanks for the reply, I got this error;

Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'web163-cdp '@'localhost' (using password: YES) in ../public_html/a/b/c/d/adodb-mysql.inc.php on line 366
localhost: Access denied for user 'web163-cdp '@'localhost' (using password: YES)


{{ directory removed by PenguinMod, EE Moderator, per e-mail request to EE, 01-July-2008 }}
0
 
callmecheezAuthor Commented:
screenshot addded
sql7.JPG
0
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

 
minibagoCommented:
I just have to check, are the web-site and database being hosted by the same company (and therefore probably on the same server)?

If so, I also have to check that you are sure you have the correct password, with the correct capitalisation of upper and lowercase letters.

If both of those are 'Yes', then I'll have to have a bit more of a think about it.

=)
0
 
callmecheezAuthor Commented:
I just have to check, are the web-site and database being hosted by the same company (and therefore probably on the same server)?

- yes!


If so, I also have to check that you are sure you have the correct password, with the correct capitalisation of upper and lowercase letters.

- yes!

0
 
minibagoCommented:
I can't think what could be wrong.  That error looks like MySQL is saying you don't have permission to access that database. So the user and password are correct, and the databse name is correct, but the user doesn't have permission to access the database.

It's possible that this is the case, but seems odd if that user was created for that database. I'd sudgest checking the permissions for that user to that database in phpMyAdmin.
0

Featured Post

Receive 1:1 tech help

Solve your biggest tech problems alongside global tech experts with 1:1 help.

  • 3
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now