(Karam Chand) Most Web hosting providers block port 3306 (the MySQL server port) at the firewall to prevent outside access. As a result, many MySQL developers and administrators can’t access and manage their own MySQL servers remotely; they must use the Web-based interfaces that their ISPs provide.

(Mark Kaelin) When properly implemented, a relational database can greatly enhance the availability of data and information for an enterprise’s decision makers. However, deploying a relational database on almost any scale requires a thorough understanding of the fundamental concepts and rules that g

(Barry L. Kline) The office is closed today, but I am here because I am awaiting the arrival of my IBM CE. During the week, our database server (an IBM pSeries running AIX and Oracle) spontaneously rebooted, rudely cutting off the 30+ users who had been enjoying its services. Once the system was

(Tony Howlett) It’s pretty much a given these days that firewalls are an essential part of any secure infrastructure. There are many very viable commercial alternatives available: Cisco, NetScreen, SonicWALL, and Checkpoint are just a few of the vendors making high-end, commercial firewall solutions

(Paul DuBois) Perfect for SQL novices, this chapter provides an introduction to the MySQL relational database management system (RDBMS), and to the Structured Query Language (SQL) that MySQL understands.

(Trudy Pelzer) This book is for the long-time MySQL user who wants to know “what’s new” in version 5. The short answer is “stored procedures, triggers, views, and information schema”. The long answer is the MySQL 5.0 New Features series, and this book is the last in that series. (pdf)

(James Niccolai) MySQL has released the first beta version of a major upgrade to its open source database, adding several features designed for corporate users.

(Trudy Pelzer) This book is for the long-time MySQL user who wants to know “what’s new” in version 5. The short answer is “stored procedures, triggers, views, and information schema”. The long answer is the MySQL 5.0 New Features series, and this book is the third in that series. (pdf)

(Jan Stafford) Migration automation software can take a lot of the tediousness out of migrating from Microsoft SQL Server to MySQL migrations. In the previous installment of SearchEnterpriseLinux.com’s series on migrating from MS SQL to MySQL, Mike Sheffey, CEO of migration tools vendor Versora, gav

(Peter Gulutzan) This book is for long-time MySQL users who want to know “what’s new” in version 5. The short answer is “stored procedures, triggers, views, information_schema”. The long answer is the “MySQL 5.0 New Features” series, and this book is the second in the series. (pdf)