hi

What is the syntax for connecting to the mysql database on our webserver? ie what should the format be of the server name for connecting to a MySQL 5.0 database?

I've tried just throwing in the IP address (http://xx.xx.xx.xx) for our website and then the database username and password, but Prism says: "Unable to connect to any of the specified MySQL hosts."

Hope you can help. The tutorials just seem to show how to connect to an Excel file?

thanks
Phil.
 

Hi Phil,

Connecting to each Database Server via Prism includes selecting the Data Origin (i.e. SqlServer, MySqL etc...), Server, User Name and password.

Same goes for MySql. The Server name is the name of MySql server. When your Database server is on the same machine with the MySql server you can use localhost. The user name and password are valid MySql user name and password. For adding a user to MySql visits this page: MySQL Tutorial.   For further information about MySql Connectivity: http://dev.mysql.com/doc/refman/5.0/en/connecting-disconnecting.html.

Try to write the Server Ip without the "http".  Just the IP of the server.

Aviad.

 hello, I just downloaded the application and I'm using a MySQL 5.1 Database, running on a remote server.

I can't connect to my database. The database doesn't listen on usual port 3306, but 3307.

I noticed there is no way to specify the listening port of the MySQL server and I guess it could be the reason I can't connect.

Maybe there's a way to change the port, but I didn't find.

Thank you in advance for the help!

Jo

Hi,

In order to connect to MySql with different port than the default one, you should add in the Database server location: “;port=<YourPortNumber>.”  . So if your server location is 192.168.1.99 and the server port is 3307, your Database server location should look like this: “192.168.1.99;port=3307”.

Aviad.