Solved

mysql basic question: help installing gallery2

Posted on 2008-06-23
6
553 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
Migrating Your Company's PCs

To keep pace with competitors, businesses must keep employees productive, and that means providing them with the latest technology. This document provides the tips and tricks you need to help you migrate an outdated PC fleet to new desktops, laptops, and tablets.

 
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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

"In order to have an organized way for empathy mapping, we rely on a psychological model and trying to model it in a simple way, so we will split the board to three section for each persona and a scenario and try to see what those personas would Do,…
There’s a good reason for why it’s called a homepage – it closely resembles that of a physical house and the only real difference is that it’s online. Your website’s homepage is where people come to visit you. It’s the family room of your website wh…
This video teaches users how to migrate an existing Wordpress website to a new domain.
The is a quite short video tutorial. In this video, I'm going to show you how to create self-host WordPress blog with free hosting service.

839 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