Re: MySQL vs. DBI/DBD

From: Tom Mornini (tmornini_at_infomania.com)
Date: 03/12/05

  • Next message: Unknown Sender: "Re: Problems on Connect :("
    Date: Sat, 12 Mar 2005 01:13:13 -0800
    To: Perl - DBI users <dbi-users@perl.org>
    
    

    -----BEGIN PGP SIGNED MESSAGE-----
    Hash: SHA1

    A simple Google search on the error message:

    http://dev.mysql.com/doc/mysql/en/perl-support-problems.html

    Look at the very last response on the bottom of the page.

    On Mar 11, 2005, at 8:19 PM, borkurg@simnet.is wrote:

    > 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
    >
    >
    - --
    - -- Tom Mornini

    -----BEGIN PGP SIGNATURE-----
    Version: GnuPG v1.2.4 (Darwin)

    iD8DBQFCMrKpzaKkuvKwKvcRAqbLAJ46vD3l/agdwL8XsTyEMnPDBvTIZACcD0/j
    kFPJ7cC3PwapsP5rQAuJRD8=
    =p1R3
    -----END PGP SIGNATURE-----


  • Next message: Unknown Sender: "Re: Problems on Connect :("

    Relevant Pages

    • Re: MySql
      ... I'm having trouble writing to a MySql db using python and the MySQLdb ... and then i run my py script 3 times, the data is not entered but if i ... Evidently it's committed the auto increment before it decides that it ... If you get an error message, tell us what the error message was. ...
      (comp.lang.python)
    • Re: not able to connect to mysql
      ... -cgi script on command line its working fine. ... Can't connect to local MySQL server through socket ... the end of that error message. ...
      (comp.lang.perl.misc)
    • Re: Form Security
      ... After all this, if no error message has been generated, the form contents are emailed to me. ... I'm no Linux guru, so I don't know what someone could do to cause problems with this script, other than spam me. ... What he's proposing is false security - which is worse than no security ...
      (comp.lang.php)
    • RE: Cannot Edit Logion Scripts
      ... remove the script that you would like to edit. ... Please capture a screenshot of the error message received on the client ... Microsoft Online Newsgroup Support ... This newsgroup only focuses on SBS technical issues. ...
      (microsoft.public.windows.server.sbs)
    • Re: Sound file
      ... There shouldn't be any problems in the limited user accounts. ... The only other problem just about has to be with the attaching of the .wav ... > Common script errors messages can be eliminated by Clicking: ... >> click on the html file we get an error message and the wav file does ...
      (microsoft.public.windowsxp.accessibility)