Difference between revisions of "Perl DBI"

from HTYP, the free directory anyone can edit if they can prove to me that they're not a spambot
Jump to navigation Jump to search
(→‎functions: usage notes)
m (→‎usage: restored missing r)
 
Line 11: Line 11:
 
* [http://search.cpan.org/~timb/DBI-1.51/DBI.pm#prepare prepare]()
 
* [http://search.cpan.org/~timb/DBI-1.51/DBI.pm#prepare prepare]()
 
===usage===
 
===usage===
Using an existing user/pass combination, I got an erro message saying "Client does not support authentication protocol requested by server". The [http://dev.mysql.com/doc/mysql/en/Old_client.html mysql manual said] (among other things) that one way around this was to reset the password using an old format ("OLD_PASSWORD('newpwd');"), so I created a new user with the intention of doing that to it (since I didn't want to mess up existing access), and then just for the heck of it I tried accessing that user/pass from Perl DBI... and it worked. I'm guessing this has something to do with the [[HSphere]] update on the shared server (I generally use HSphere to manage users, since I don't think I have permission to do so otherwise). --[[User:Woozle|Woozle]] 18:01, 4 July 2006 (EDT)
+
Using an existing user/pass combination, I got an error message saying "Client does not support authentication protocol requested by server". The [http://dev.mysql.com/doc/mysql/en/Old_client.html mysql manual said] (among other things) that one way around this was to reset the password using an old format ("OLD_PASSWORD('newpwd');"), so I created a new user with the intention of doing that to it (since I didn't want to mess up existing access), and then just for the heck of it I tried accessing that user/pass from Perl DBI... and it worked. I'm guessing this has something to do with the [[HSphere]] update on the shared server (I generally use HSphere to manage users, since I don't think I have permission to do so otherwise). --[[User:Woozle|Woozle]] 18:01, 4 July 2006 (EDT)

Latest revision as of 01:08, 20 October 2006

Navbar

computing: software: Perl: DBI

This page is a seed article. You can help HTYP water it: make a request to expand a given page and/or donate to help give us more writing-hours!

Overview

Perl DBI is the most common database API for the Perl programming language.

Reference

Notes

functions

usage

Using an existing user/pass combination, I got an error message saying "Client does not support authentication protocol requested by server". The mysql manual said (among other things) that one way around this was to reset the password using an old format ("OLD_PASSWORD('newpwd');"), so I created a new user with the intention of doing that to it (since I didn't want to mess up existing access), and then just for the heck of it I tried accessing that user/pass from Perl DBI... and it worked. I'm guessing this has something to do with the HSphere update on the shared server (I generally use HSphere to manage users, since I don't think I have permission to do so otherwise). --Woozle 18:01, 4 July 2006 (EDT)