G2 Database problem/question - can't connect to MySQL Server

Groovykid

Joined: 2005-05-05
Posts: 3
Posted: Mon, 2005-05-23 16:50

I have Gallery1 and have been enjoying it very much. I have not had any major problems with gallery1 but would like to try out gallery2. In the installation process I received the following error on Step 5:

Warning: mysql_connect(): Host '[My IP]' is not allowed to connect to this MySQL server in /var/www/images/gallery2/lib/adodb/drivers/adodb-mysql.inc.php on line 339
[localhost]: Host '[My IP]' is not allowed to connect to this MySQL server

I had our web admin setup the database and password for me, but I think it is needing more permissions for this to work. I don't have root permission for our Linux server so I cannot change any of the permission.

My question is thus: Is my error coming up because my MySQL database does not have the right permissions? or is this another problem?

I would change the permissions but I cannot easily without having to tell my Web admin. Is there anyway to bypass this step? What is the database used for anyway? I am not quite sure why G1 would work so well but G2 is not getting past this step...

 
valiant

Joined: 2003-01-04
Posts: 32509
Posted: Mon, 2005-05-23 18:02

first, try leaving the host field blank.
if this doesn't work, you have to talk to the admin. report him the problem. he will have to change a general mysql config file to accept connections from your host.

 
Groovykid

Joined: 2005-05-05
Posts: 3
Posted: Mon, 2005-05-23 18:59

hmm. Leaving the host field blank does not make any difference. Thanks for the tip though. Perhaps I will stick with G1 for a while.