Difference between revisions of "Perl DBI"

Latest revision as of 01:08, 20 October 2006

Navbar

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

execute()
prepare()

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)

@@ Line 11: / Line 11: @@
 * [http://search.cpan.org/~timb/DBI-1.51/DBI.pm#prepare prepare]()
 ===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)