Difference between revisions of "Perl DBI"
(→Reference: a couple of functions) |
m (→usage: restored missing r) |
||
| (One intermediate revision by the same user not shown) | |||
| Line 10: | Line 10: | ||
* [http://search.cpan.org/~timb/DBI-1.51/DBI.pm#execute execute]() | * [http://search.cpan.org/~timb/DBI-1.51/DBI.pm#execute execute]() | ||
* [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=== | ||
| + | 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
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)