remote mysql db access config question 1

[Developer8]

I want to access a mysql database (on linux) from another linux box. I type in:

mysql -hservername -uusername -ppassword databasename

and it tells me that my server ip is not allowed to access the mysql database. How would I configure mysqlaccess.conf to allow remote access?

 

[w1nn3r]

#$Param{'host'} = '';
$Param{'user'} = 'nobody';
$Param{'db'} = 'test';
$Param{'password'} = 'foobar';
$Param{'debug'} = 0;

See the $Param{'host'} = ''; In the = ''; field, put your IP address in the ''; field.

 

[Developer8]

Thanks...

I was able to login as root to mysql and add a remote user using the grant command.

---------- On the remote server:

GRANT SELECT ON TABLENAME TO USER@SERVERNAME
IDENTIFIED BY PASSWORD;

GRANT INSERT ON TABLENAME TO USER@SERVERNAME
IDENTIFIED BY PASSWORD;

---------- In my Perl program on the local server:

$driver = "mysql";
$database = "databasename";
$hostname = "servername";
$dsn = "DBI:$driver:database=$database;host=$hostname";
($username, $password) = ('username', 'password');
$dbh = DBI->connect($dsn, $username, $password);