MySQL I : Creating Databases and Tables

1. Start the MySQL Monitor client: mysql –u root –p Password: mypass 2. Create and load for use, a new database: CREATE DATABASE accounting; USE accounting; 3. Create an invoices table: CREATE TABLE invoices ( invoice_id SMALLINT(4) UNSIGNED NOT NULL AUTO_INCREMENT, client_id SMALLINT(3) UNSIGNED, invoice_date DATE NOT NULL, invoice_amount DECIMAL(10,2) UNSIGNED NOT NULL, invoice_description TINYTEXT, …

MySQL I : Installation

Getting Started: Visit www.mysql.com Brand new: Version 5 MaxDB: the SAP/MySQL joint venture Find the Downloads page. Note available versions. Click through to the version 4.1 page. Note the mention of MD5 checksums; follow this link for more information. Windows installation Log in as Administrator. Copy the MD5 checksum to a text file and save …

MySQL I : Introduction

UNM Continuing Education Course Instructor: Glenn Norman Text: Objectives A basic understanding of MySQL database functionality Familiarity with construction, maintenance and troubleshooting of databases What is MySQL? A robust, full-featured enterprise-ready database “Dual-license” software: Open source and Commercial Both “bleeding-edge” (Community Edition) and “Certified Software” (Network Edition) What will we do in this course? Look …

Application Support

Perl Your Configuration File perl.conf Checking for Installation rpm -q mod_perl   PHP Checking for Installation rpm -q php To test Apache and PHP, create a PHP file in you web root named info.php containing the following: <? phpinfo() ?> Now point your browser at the page http://localhost/info.php.   Ruby http://www.ruby-lang.org/en/

SSL and https

–> Review the Apache Administrator’s Handbook, Chapter 22. Confidentiality Integrity Authentication   Certification Authorities: VeriSign, Thawte   Secure Sockets Layer Configuration ssl.conf Does your system support SSL? rpm -q OpenSSL rpm -q mod_ssl   Getting Certified Certificates Create a self-signed SSL Certificate. Place it in the correct location. Create a Key Pair. Create a Certificate …