[Catalyst] Newbie Question about Database

Giancarlo Corcuera giancarlo at capybara-software.com
Tue Jan 20 14:08:31 GMT 2009



Ashley wrote:
> On Jan 19, 2009, at 7:06 PM, Charlie Garrison wrote:
>> Good afternoon,
>>
>> On 19/01/09 at 8:11 PM -0500, Robert L Cochran 
>> <cochranb at speakeasy.net> wrote:
>>
>>> I also wonder if Catalyst can make use of a .my.cnf file if there is
>>> one. Why is this important? Because you can keep your connection
>>> password private.
>>
>> You can pass a path to a "user defaults" file as part of the DBI 
>> connect string. I don't recall the syntax though.
>
> This is how I usually do it. The __path_to()__ in configs gets 
> expanded properly.
>
> Model::DBIC:
>   schema_class: MyApp::Schema
>   connect_info:
>     - 
> dbi:mysql:myappdb;mysql_read_default_file=__path_to(etc/.mysql.cnf)__
>     - ~
>     - ~
>     - RaiseError: 1
>       PrintError: 0
>       AutoCommit: 1
>       ChopBlanks: 1
>
> -Ashley
>
>
> _______________________________________________
> List: Catalyst at lists.scsys.co.uk
> Listinfo: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/catalyst
> Searchable archive: 
> http://www.mail-archive.com/catalyst@lists.scsys.co.uk/
> Dev site: http://dev.catalyst.perl.org/
>

Thank you all for your answers:
Actually, what I did is to follow the basic instructions from mysql 
forum but what I was missing is to set the user with full access from 
any host, which I created later from phpmyadmin.

Regards,

Giancarlo



More information about the Catalyst mailing list