(Peter Gulutzan) MySQL 5.0, the alpha version of MySQL that’s available for testing new features, has trigger support. This is no surprise, as triggers were promised in the MySQL Development Roadmap, but it’s a novel experience to work with one of the big “MySQL can’t do that” features and watch MyS
Tag: Open Source
Open source MySQL database all child’s play
(Rodney Gedda) When popular children’s Web site Nickelodeon went through an upgrade and rehosting move late last year, the decision to stay with the open source MySQL database was apparent amid growing data and traffic demands.
Downloadable Databases Pose Security Dangers
(Lisa Vaas) Are they lazy? Stupid? Or merely inexperienced? It’s baffling that so many database administrators or casual non-DBA downloaders were responsible for leaving weak or default passwords on MySQL databases and thus allowing the MySpooler bot attack against Windows installations of MySQL
Securing a MySQL Server on Windows
(Mike Hillyer) At the end of January 2005 a new worm-like malware named Forbot spread across the Internet, targeting poorly configured MySQL installations and exploiting them to gain access to the Windows host machines. Forbot was not a worm, in the sense that it had to be signalled to continue infe
Must-have open source applications for consultants
(Rob Sutherland) As a consultant to small businesses trying to get up to speed on Linux, my must-have applications are OpenOffice.org, MySQLAdmin, and Rekall. I’m going to include Knoppix as well; although it isn’t an application in the sense of being a single package, I use it as a system recovery
MySQL warning users, contemplating changes after worm
(Paul Roberts) Open source database software maker MySQL warned its users to tighten security after news broke about a new Internet worm that targets the popular relational database, according to a company executive. The company is looking at making bigger changes to harden its product against f
HOW TO: Install MySQL as Part of a UNIX-to-Windows Migration
MySQL is an open-source relational database management system (RDBMS) that supports the SQL query language. MySQL is available for most UNIX and Windows platforms, and it is typically used in combination with languages such as Perl, Python, and PHP. This article describes how to install MySQL on
Update of the MySQL Certification Exams
On February 1st, 2005, the MySQL Certification Exams will be updated to reflect the changes that have taken place with the release of MySQL Server version 4.1.
Worm hijacks open source database
(Dan Ilett) Security experts have warned that thousands of MySQL servers around the world could be press-ganged into launching a denial-of-service attack that could bring down the Web site of a company the size of Microsoft.
Data Definition Language, Part 2
(Paul Dubois) The SELECT statement retrieves the information contained in your databases. You can also ask MySQL to show you information about your databases, such as database and table names or information about the columns or indexes in a table.