Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

mysql basic question: help installing gallery2

Posted on 2008-06-23
6
Medium Priority
?
559 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
  • 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
NFR key for Veeam Agent for Linux

Veeam is happy to provide a free NFR license for one year.  It allows for the non‑production use and valid for five workstations and two servers. Veeam Agent for Linux is a simple backup tool for your Linux installations, both on‑premises and in the public cloud.

 
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

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Originally, this post was published on Monitis Blog, you can check it here . It goes without saying that technology has transformed society and the very nature of how we live, work, and communicate in ways that would’ve been incomprehensible 5 ye…
Without even knowing it, most of us are using web applications on a daily basis.  In fact, Gmail and Yahoo email, Twitter, Facebook, and eBay are used by most of us daily—and they are web applications. We generally confuse these web applications to…
The viewer will learn how to count occurrences of each item in an array.
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…
Suggested Courses

885 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