MySQL vs. DBI/DBD

borkurg_at_simnet.is
Date: 03/12/05

  • Next message: Tom Mornini: "Re: MySQL vs. DBI/DBD" 
    Date: Sat, 12 Mar 2005 04:19:21 +0000
To: dbi-users@perl.org

    I'm using
      MySQL v4.1.10.a on Windows XP
      Activestate Perl v5.8.6.811
      DBI v1.47
    This is my script:
    ----------------------------------------
    #!/usr/bin/perl -w
    use strict;
    use DBI;

    my $database = "bg_test";
    my $hostname = "localhost";
    my $port = 3306;

    my $user = "root";
    my $password = "msqlborkur";

    my $dsn = "DBI:mysql:database=$database;host=$hostname;port=$port";
    my $dbh = DBI->connect($dsn, $user, $password);

    ----------------------------------------

    When I run the script I get this error message:

    DBI connect('database=bg_test;host=localhost;port=3306','root',...) failed: Client does not support authentication protocol requested by server; consider upgrading MySQL client at test.pl line 15

    ----------------------------------------

    I hope you have the time to look into this.
    Regards,
    Börkur Gudjonsson

  • Next message: Tom Mornini: "Re: MySQL vs. DBI/DBD"

    Relevant Pages

    • Re: Very Frustrating
      ... It would not allow my script to open up a ... port. ... a thread named "Very Frustrating" will have anything to do ... getting "bad hostname" error when accessed from the browser ...
      (comp.lang.perl.misc)
    • Re: webmin help
      ... >> localhost in the search box. ... >> fix it ... >> same for if I use my ip and then the ip port number ... > the setup.sh script. ...
      (comp.unix.solaris)
    • Re: Several issues with /etc/hosts.allow at a university setting
      ... > my university's computer support office in order to use their internet ... Yes when dhcp is used and you have not disabled hostname your pc gets ... What you could do is create a script to update /etc/hosts with your ip ... That stops name changes but a hostname of localhost will not do well. ...
      (comp.os.linux.networking)
    • How to wrap up scp command?
      ... I basically want to write a general script that can put a port number ... in and in the same time replace the hostname by localhost. ... The new scp ...
      (comp.unix.shell)
    • How to wrap up scp command?
      ... I basically want to write a general script that can put a port number ... in and in the same time replace the hostname by localhost. ... The new scp ...
      (comp.unix.shell)