right, i've had a look into sql and everything, and kinda got to grasp with how it works, i've written a trial script to see if it works, but it keeps spewing an error:
DBI->connect(mx:localhost:3306) failed: Access denied for user: 'dan@localhost' (Using password: YES) at db.pl line 10 Can't connect to the DB: Access denied for user: 'dan@localhost' (Using password: YES) here's the script (real password omitted of course) (the password isn't 'YES' either) __ START __ #!/usr/bin/perl use strict; use DBI; my $dsn = 'dbi:mysql:mx:localhost:3306'; my $user = 'dan'; my $pass = 'mypassword'; my $dbh = DBI->connect($dsn, $user, $pass) or die "Can't connect to the DB: $DBI::errstr\n"; __ END __ what's wrong? dan "Wiggins D'Anconia" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > First off for those MySQL newbies in the crowd you might find this > helpful, I compiled it a while ago but I am pretty sure it is still > accurate: > > http://www.residualselfimage.com/mysql_pkt_ref/ > > Essentially you need to start with the mysql documentation, or a > beginners guide on that, then check out > > perldoc DBI (http://search.cpan.org/author/TIMB/DBI-1.30/DBI.pm) > > DBI lets you connect to the database and send queries to it. Queries > being just about any SQL (including create and drop tables, selects, > updates, inserts, etc.) > > Once you have a handle (no pun intended) on how DBI works what you can > do is pretty much limitless (again no pun intended) (at least within the > confines of Perl, which at times appear limitless :-)). > > I would give it a try and the post specific questions after looking into > DBI. > > http://danconia.org/ > > dan wrote: > > I'm in the process of writing IRC Services in Perl. I know most of you won't > > know anything about IRC in this aspect at least. However what I need help > > with is being able to store the services' data in a MySQL database. I know > > absolutely nothing about MySQL. At the moment it's using a flat text file > > database, and it gets sluggish at points when it starts saving. So I thought > > it may be easier/faster reading from a MySQL database. Since I know nothing > > about MySQL, how would I go about: > > a) creating the "tables" for the services to read, and how to put different > > bits of data there, and how to call them back without having to foreach > > through a big list? > > b) writing the code so perl connects to MySQL and stays connected for the > > entire time the process is live, so it can read/write data from/to the > > database > > c) making a web accessible interface to use the same database as the > > services, to provide real-time live statistics to the web, to enable website > > users to view certain portions of the database > > > > All help muchly appreciated > > > > Dan > > > > > > > -- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
