Perl-mysql


Hi,

I would like to connect to a database stored at linux
machine from my Windows machine. But I am unable to connect to the
mysql
server.

The error I am getting is

"DBI connect('employee:xxx.xxx.xxx.xx','root',...) failed: Unknown MySQL
server host 'xxx.xxx.xxx.xx' (11001) at
d:\pras\webshare\common\siva\mysql\mysql.pl line 2"
--
I have used the exact ip address of the machine instead of
xxx.xxx.xxx.xx
,the database "employee" is created properly and mysql is running


Please help me regarding this issue.

************************************************************************
use DBI;

$dbh = DBI->connect("DBI:mysql:employee:xxx.xxx.xxx.xx", 'root',
'abc123',{ RaiseError => 1 });

#do something here
$dbh->disconnect();

***********************************************************************

Thanks
siva
.

Relevant Pages

  • RE: MySQL/PHPMyAdmin on FC3 Connection Problem
    ... // You can disable a server config entry by setting host to ''. ... MySQL server ... MySQL control user settings ... table to describe the display fields ...
    (Fedora)
  • DBD::mysql failing to make test
    ... To teach myself, I have been working my way through Paul DuBois' 'MySQL' book, first edition. ... I've had no problem connecting to the server with the 'mysql' client and running the test exercises. ... So now I'm up to the chapter on the Perl DBI. ... This test requires a running server and write permissions. ...
    (perl.dbi.users)
  • Re: Using Access for web application?
    ... Any suggestions as to which newsgroup would be more ... The server that the web app will use in this case, ... > which technology you will decide to use as the Web server (Linux or Windows) ... Instead MySQL is being ...
    (microsoft.public.access.dataaccess.pages)
  • [UNIX] phpMyAdmin PHP Code Injection (left.php)
    ... The following security advisory is sent to the securiteam mailing list, and can be found at the SecuriTeam web site: http://www.securiteam.com ... phpMyAdmin is "web-based MySQL ... does not prevent a malicious user from altering the servers configuration ... server configurations to the list of servers configuration by adding ...
    (Securiteam)
  • Re: MySQL 4.1+ Password Incompatibility
    ... >> I'm having trouble getting DBI connect to a MySQL 4.1+ server. ... >> byte hashes instead of 45 byte hashes. ...
    (perl.dbi.users)