Mad Irish

Articles in mysql

1. dotProject Multiple Vulnerabilities - dotProject (http://www.dotproject.net/) is a robust open source project management tool written in PHP and MySQL. dotProject contains numerous serious cross site scripting (XSS) and SQL injection vulnerabilities.
2. Magento eCommerce XSS Vulnerabilities - Magento (http://www.magentocommerce.com/) is an eCommerce platform written in MySQL and PHP. Magento contains numerous serious cross site scripting (XSS) vulnerabilities.
3. Secure PHP Connections to MySQL with SSL - Using encryption you can protect the traffic between your web server and your database server.
4. LAMP Security Through Virtualization - Splitting up the various layers of the LAMP stack to provide more insulation and defense in depth.
5. Writing Safer Database Queries from PHP - Both PHP and MySQL include many features that developers can use to create safer web applications.
6. Building an MD5 Rainbow Table - A short perl program that creates a MySQL database of MD5 values, or a rainbow table.
7. Defending PHP Web Applications from MySQL - MySQL provides a number of features that can be used to greatly increase the security of your PHP application.
8. Connecting to MySQL from Oracle SQL Developer -
9. Dump all data from a MySQL database into a tab delimited file - This is a simple script that will dump all the data out of a MySQL database.
10. Using PHP to Access MySQL Results - This article aims to show you how to retrieve and use MySQL result sets in PHP.
11. MySQL Database User Security - All too often, especially on small setups, database security is ignored.
12. Backing up MySQL Remotely with Rsync and SSH - Implementing a MySQL backup solution utilizing mysqldump, secure shell (SSH), public key access (PKA), rsync and a remote server.
13. Loading Data into MySQL from a Text File - Short article on loading text into a MySQL database from a plain text file. This operation is remarkably fast and easy, especially for data migration.
14. Executing MySQL via Textpad - Instructions on how to execute MySQL commands on a local database directly from within TextPad.
15. Posting to MySQL with TextPad - You can document the data model as you actually create it. This is wonderful news for anyone that has had to spec up a data model, then create it, then reverse engineer a text document that describes the model.
16. Setting Up a WAMP System - A short guide to setting up an Apache, MySQL and PHP system on your Windows machine including common errors.
17. Connecting To a Remote MySQL Server Securely Using SSH Port Forwarding - Brief instructions on how to set up local port forwarding to allow for a secure MySQL connection.
18. Setting up a Linux MySQL server for Windows clients - Quick setup notes for connecting Windows client machines to a MySQL server.
19. Using Squirrel SQL to connect to your MySQL database - Brief instructions on how to set up Squirrel SQL Client as a GUI for your MySQL server.
20. MySQL Max Allowed Packet Size Exceeded Fix - Solving the MySQL max_allowed_packet size exceeded error.
21. Designing a LAMP Based Online MUA - Documentation of my experimentation and eventual success with a system to import POP3 email into a MySQL database via a web interface.
22. Backing Up and Restoring MySQL Databases - Backing up and restoring a MySQL database.
23. Using Soundex with MySQL - A description of SOUNDEX and how to use its functionality in MySQL.
24. Designing a Data Driven Website - Part 1 - Choosing a good platform for your website needs, including operating system, scripting language, and database server.
25. MySQL Beginners Guide - A comprehensive training white paper desinged to get you started with MySQL, including installation and use.