Newbie Question: DBI and MySQL Connection Issues

From: Qaseem Shaikh (qaseemshaikh_at_yahoo.com)
Date: 03/24/05 

Date: Thu, 24 Mar 2005 08:17:35 -0800 (PST)
To: dbi-users@perl.org

Hi

I am using DBI to connect to MySQL. However I am
getting the following error:

Couldn't connect to database: Client does not support
authentication protocol requested by server; consider
upgrading MySQL client

when DBI tries to connect to the database. I've read
about the solution which requires changing the
password to an old-style password. However I was
wondering if there was a cleaner way to do this.

Any help will be greatly appreciated.

Thanks,
Qaseem

                
__________________________________
Do you Yahoo!?
Make Yahoo! your home page
http://www.yahoo.com/r/hs

Relevant Pages

  • Re: toolkits or APIs to create a web interface as a frontend to mysql
    ... I am also *not* looking for a web based full fledged mysql client. ... For simple display of tabulated data the most useful thing is a displaywhich uses 's with absolute coordinates to position text in a box of defined width, formatted to be left, right or center justified, an using a preselected style from a a style sheet. ... As far as the actual database calls go, those are specific to each form, and apart from a little coding so that 'database_open, database_close' exist in the library, taking such things as the database name, user name and password from an included file I find it easiest to simply do the query and iterate through it to display the data requested. ...
    (comp.os.linux.misc)
  • Re: Confusion about database updates
    ... all connecting to the same database server. ... MySQL can easily handle many simultaneous clients. ... AlphaCluster all open multiple connections to a MySQL server running on ... Let the MySQL server do that when your client ...
    (comp.lang.java.databases)
  • Re: PHP front to mySQL database
    ... You should be able to set up MySQL to respond via ODBC to calls from VB. ... Set up the database file table structure in Access and call it from VB. ... I also prefer to use the web browser as the client interface instead of VB. ... an installation pain. ...
    (alt.php)
  • Re: Base Pair Patterns Database
    ... There is a MySQL database open to the Internet public, ... ODBC client driverfirst, depending on what client software you ... This new server allows MySQL access to the same set of data ...
    (talk.origins)
  • Re: Evaluated "require $database" not found.
    ... DBI Error 1046: No database selected ... What I have found is that if the spaceare removed as per the correct syntax, then the DBI_errorhandler will trap and report a connection failure if a non-existent database is specified, as per this example: ... This requires that you first have an installation of mysql setup on a host ...
    (perl.dbi.users)