Hello All,

I have a Dedicated server, running Plesk 7.5.4 Linux/Unix. We have developed a desktop application that interacts with mysql. It works fine on local WAMP but the application will not interact with the mysql on the server.

Is there any easy fix for this problem? Do I need to access the root directory of mysql to change the access settings?
Your assistance is greatly apprecieated.

Thanks,

Coop

Hi

First you need to add checks in the application - when it tries to connect to the database and it fails - you need to print out an error message. The network could be down, access denied, service down - it could be many reasons. The mysql documentation has examples on how to connect to the database - including printing out error messages.

Most likely there's some "Access denied". A default MySQL install gives root access to the database from localhost only. There's also an option called "skip-networking" - some distros may turn it on for security reasons.

Error No:1045
Access denied for user:'username@135.242.65.281'(using password:YES')

We have tried using a program called putty, we are unable to connect using that either.

How do I set the root password? I dont think its ever been setup.

Thanks again,

Coop

Hi again

On the server, type mysql, and give the command:
grant all privileges on databasename.* to username identified by 'password';

Change "databasename", "username" and "password" to the values you want.

This will give username access to all tables in the specified database from anywhere.

It is common to not allow access from anywhere. If you want that, try:
grant all privileges on databasename.* to username@135.242.65.281 identified by 'password';

To change the root password:
mysqladmin -u root -p password 'newpassword';

This will ask for the old password first, if it isn't set before, just hit enter.

For more info:
http://dev.mysql.com/doc/refman/5.0/en/grant.html

HI Guttorm,

Thanks for your help. I am going to work on this today. I'll keep you posted.

Thanks again,

Coop