[mapserver-users] Mapserver layer - MySQL connection

[Chris Green]

Jukka

You are a genius -it worked!


Thanks

-----Original Message-----
From: Rahkonen Jukka [mailto:Jukka.Rahkonen at mmmtike.fi] 
Sent: 22 June 2011 08:26
To: Chris Green; mapserver-users at lists.osgeo.org
Subject: Re: [mapserver-users] Mapserver layer - MySQL connection

Hi,

Try first by removing the space characters after separating commas.

-Jukka Rahkonen-


________________________________________
Lähettäjä: mapserver-users-bounces at lists.osgeo.org
[mapserver-users-bounces at lists.osgeo.org] käyttäjän Chris
Green [chris.green at ibstv.co.uk] puolesta
Lähetetty: 22. kesäkuuta 2011 10:12
Vastaanottaja: mapserver-users at lists.osgeo.org
Aihe: [mapserver-users] Mapserver layer - MySQL connection

Hi all

I’m using Mapserver 6.0 and I have GDAL  1.8.0 installed, running under
Ubuntu 10.04.  I am trying to make a connection from a layer to MySQL,
following the guidance given in the MySQL section of Mapserver
documentation. My problem is that when I try to connect using ogrinfo like:

~# ogrinfo mysql:testDB, user=root, password=mysql, port=3306

I get a mySQL connect failure message “ERROR 1: MySQL connect failed for:
testDB, Access denied for user’root’@’localhost’ (using password: NO)”

It seems that MySQL is refusing this connection request because the password
that I entered in the ogrinfo command is not being passed to MySQL and I
can’t find a way to overcome this. The same user name and password work fine
if I access MySQL directly rather than via ogrinfo.

Does anyone have an idea what my problem is?



Chris