MySQL is complaining about the user "dan" not existing in the database. You need to add a record to the mysql:users table for each user you wish to connect to the database as.
MySQL stores all of its permissions stuff as database tables so normal INSERT and UPDATE statements will work, but you will have to be a user that has privileges to update the "mysql" database on that mysql server (root for example). Troubleshoot this setup stuff with the actual command line client "mysql" and once you can connect as "dan" there then your script should run. http://danconia.org ------------------------------------------------ On Sun, 22 Sep 2002 23:35:19 +0100, "dan" <[EMAIL PROTECTED]> wrote: > 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] > -- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
