[SOLVED] g2 database setup Trouble

bodillon

Joined: 2005-03-20
Posts: 3
Posted: Sun, 2005-03-20 19:04

I am not very experienced with mysql and databases. I know the basics. I am stuck on step 5 in the G2 installation.
I need help connecting to my mysql database/server.
I do not host this from my computer, I have a hosting package from www.readysetconnect.com
MySQL account maintenance:
If i create a database named g2user, when i press go back after it succeeded, it is named dillon_g2user

Right now, i have my default database, and
i created mysql DB: dillon_gallery2
i created mysql user: dillon_g2user
my domain is: ****clan.us
my user password is: ********

In order for it to connect to my MySQL stuff on Step 5 of the G2 installation, what information do i need to put in?

Database type: (MySQL all versions)
DB hostname: ?
DB username: ?
DB password: ?
DB name: ?
Table Prefix: g2_
Column Prefix: g_

If i can get the correct information to connect to the MySQL server, I should be able to pass step 5.

Currently, I think i am putting in the wrong information and it is giving me this error:
Unable to connect to database with the information provided.

Warning: mysql_connect(): Access denied for user: 'dillon_g2user@saturn.select-servers.com' (Using password: YES) in /home2/dillon/public_html/gallery2/lib/adodb/drivers/adodb-mysql.inc.php on line 339
****clan.us: Access denied for user: 'dillon_g2user@saturn.select-servers.com' (Using password: YES)

Help is appreciated, I will check back to this thread often for replys. Please let me know if i can provide you with any additional information.
I do know that saturn.select-servers.com is like a shared ip that readysetconnect.com allows me until I get my real domain setup. (****clan.us) They operate on Linux, ApacheVersion: 1.3.33 PHPversion: 4.3.10 MySQL version: 4.0.22-standard
-Dillon

----

Gallery URL (optional):
Gallery version:
Webserver (with version):
Datatabase (with version):
PHP version (eg 4.2.1): 4.3.10
phpinfo URL (optional):
Graphics Toolkit(s):
Operating system:
Web browser/version:
G1 version (for migration bugs):
 
valiant

Joined: 2003-01-04
Posts: 32509
Posted: Sun, 2005-03-20 19:36

are you sure this access to the mysql server on saturn.select-servers.com should work? is it tested?
 
bodillon

Joined: 2005-03-20
Posts: 3
Posted: Sun, 2005-03-20 22:19

Problem solved! Nothing major i had to do, I simply did not have the correct database name in. I put localhost is for the DB name, and i believe i had no password.

Thanks for the reply, I have learned more than i knew before simply by going through this process.
 
valiant

Joined: 2003-01-04
Posts: 32509
Posted: Sun, 2005-03-20 22:59

as mysql server/host try:
localhost
or just empty
 
bodillon

Joined: 2005-03-20
Posts: 3
Posted: Sun, 2005-03-20 23:18

Above post ^^^^ thanks a ton valiant, although i solved it a hair before you posted, that was it!