MySQL II : Perl

Using MySQL With Perl (See MMS4 595) Once upon a time you had to jump through some hoops to set up Perl for MySQL. Now you can simply install the perl-DBD-MySQL package with Fedora 4 or later. Before we start, let’s be clear about a couple of things, namely single-quotes and double-quotes. ->Single-quotes are strong …

MySQL II : MS Access

Using MySQL With Microsoft Access Set up the MySQL ODBC Connector on your Linux server rpm -q mysql-connector-odbc If you don’t, the easiest solution is to use the Fedora CDs to install it. (See your instructor.) Another solution is to download and install the ODBC Connector directly from mysql.com. See this document: Installing MyODBC from …

MySQL II : Sample Users

Set Up Sample Users (See MMS4 416 ff.) Now we’ll need some sample users for our continuing process. You’ll be setting up these users: herbie (password ‘hacker’) carrie (password ‘cracker’) arnold (password ‘admin’) yulia (password ‘user’) fred (password ‘freeloader’) george (password ‘good’) yanni (password ‘user’) Setting them up manually, one at a time, is silly. …

MySQL II : Sample Data

Run the Sample Database Scripts to Install Sample Data It’s time to populate a sample database. We’re going to use some examples and materials from the article “Stored Procedures, Views and Triggers” by Jay Pipes and Michael Kruckenberg, in the December 2005 edition of Linux Magazine. Take it from me: you should subscribe. 1. Get …