?
Solved

mysql basic question: help installing gallery2

Posted on 2008-06-23
6
Medium Priority
?
557 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
Looking for a new Web Host?

Lunarpages' assortment of hosting products and solutions ensure a perfect fit for anyone looking to get their vision or products to market. Our award winning customer support and 30-day money back guarantee show the pride we take in being the industry's premier MSP.

 
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 2000 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

Give Your Engineering Team a Productivity Boost

Learn why container technology is so powerful and how it can provide your team with productivity gains and other benefits.

Question has a verified solution.

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

In this blog post, we’ll look at how ClickHouse performs in a general analytical workload using the star schema benchmark test.
In this blog post, we’ll look at how using thread_statistics can cause high memory usage.
Any person in technology especially those working for big companies should at least know about the basics of web accessibility. Believe it or not there are even laws in place that require businesses to provide such means for the disabled and aging p…
Video by: Mark
This lesson goes over how to construct ordered and unordered lists and how to create hyperlinks.
Suggested Courses

719 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