Solved

mysql basic question: help installing gallery2

Posted on 2008-06-23
6
555 Views
Last Modified: 2013-11-19
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
Comment
Question by:callmecheez
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 3
6 Comments
 
LVL 2

Expert Comment

by:minibago
ID: 21847645
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
 
LVL 3

Author Comment

by:callmecheez
ID: 21847705
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
 
LVL 3

Author Comment

by:callmecheez
ID: 21847716
screenshot addded
sql7.JPG
0
Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

 
LVL 2

Expert Comment

by:minibago
ID: 21847796
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
 
LVL 3

Author Comment

by:callmecheez
ID: 21850001
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
 
LVL 2

Accepted Solution

by:
minibago earned 500 total points
ID: 21874027
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

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

FAQ pages provide a simple way for you to supply and for customers to find answers to the most common questions about your company. Here are six reasons why your company website should have a FAQ page
When crafting your “Why Us” page, there are a plethora of pitfalls to avoid. Follow these five tips, and you’ll be well on your way to creating an effective page.
This video teaches users how to migrate an existing Wordpress website to a new domain.
Learn how to create flexible layouts using relative units in CSS.  New relative units added in CSS3 include vw(viewports width), vh(viewports height), vmin(minimum of viewports height and width), and vmax (maximum of viewports height and width).

728 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question