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...
Posts: 32509
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.
Posts: 3
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.