Perl DBI - Revision history

Woozle: /* usage */ restored missing r

2006-10-20T01:08:05Z

usage: restored missing r

← Older revision		Revision as of 01:08, 20 October 2006
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)

Woozle: /* functions */ usage notes

2006-07-04T22:01:08Z

functions: usage notes

← Older revision		Revision as of 22:01, 4 July 2006
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 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)

Woozle: /* Reference */ a couple of functions

2006-06-29T23:32:38Z

Reference: a couple of functions

← Older revision		Revision as of 23:32, 29 June 2006
Line 6:		Line 6:
	* {{wikipedia\|Perl DBI}}		* {{wikipedia\|Perl DBI}}
	* [http://dbi.perl.org/ official web page]		* [http://dbi.perl.org/ official web page]
			==Notes==
			===functions===
			* [http://search.cpan.org/~timb/DBI-1.51/DBI.pm#execute execute]()
			* [http://search.cpan.org/~timb/DBI-1.51/DBI.pm#prepare prepare]()

Woozle at 23:23, 29 June 2006

2006-06-29T23:23:24Z

New page

=={{hide|Navbar}}==
[[computing]]: [[software]]: [[Perl]]: [[Perl DBI|DBI]]{{seed}}
==Overview==
[[Perl DBI]] is the most common [[database]] [[API]] for the [[Perl]] programming language.
==Reference==
* {{wikipedia|Perl DBI}}
* [http://dbi.perl.org/ official web page]