This article discuses how a system administrator can use the phpMyAdmin server-management features for day-to-day user account maintenance, server verification, and server protection. The subject of how non-administrators can obtain server information from phpMyAdmin is also covered. Server administration is mostly done via the Server view, which is accessed via the menu tabs available on phpMyAdmin's home page.

This article shows how to use a combination of MySQL, PHP, Prototype.js, and Asynchronous JavaScript™ and XML (Ajax) to add simple rating and comment functionality to any site.

Database normalization is a process by which an existing schema is modified to bring its component tables into compliance with a series of progressive normal forms. The goal of database normalization is to ensure that every non-key column in every table is directly dependent on the key, the whole key and nothing but the key and with this goal come benefits in the form of reduced redundancies, fewer anomalies, and improved efficiencies. While normalization is not the be-all and end-all of good design, a normalized schema provides a good starting point for further development.This article will take a practical look at database normalization, focusing on the first three of seven generally recognized normal forms.

MySQL 5 introduced a plethora of new features, stored procedures being one of the most significant. This tutorial focuses on what they are and how they can make your life easier.

Even though MySQL is a good general-purpose database, if your application is search-heavy, you may get better performance by using Sphinx instead. Despite Sphinx being a full-text search tool, it can increase the speed of your application even when working with non-full-text queries. This article shows how to configure Sphinx for this task, includes some example queries, measures their execution times, and demonstrates some of the trade-offs involved in the change considering what you need to use Sphinx in a general, systematic way.

Although MySQL is one of the most popular programs, many developers have felt the need to branch it into other projects, each offering their own speciality. That need, along with the fear that Oracle will slow the growth of the core product, has led to many sub-projects and branches of interest to developers.

Rich Internet Applications (RIAs) often utilize different bundled technologies. Choosing the right grouping of technologies can expedite development times and provide users a complete and rich Internet experience. Discover how to use Java™ EE platform components on the server side, the Adobe® Flex™ platform on the client side, and the MySQL® database server for storage persistence.

Does MySQL Cluster scale? Does MySQL Cluster rock? This article try to answer these questions with tests of MySQL Cluster 5.1.20.

In Part 1 of this three-part series, you learned about the salient features of open source technologies such as Firefox, Zend Core, and MySQL. You were introduced to a non-trivial bank scenario that spans across all three tiers of an Ajax application. You also set up the database server, mid-tier server, and Eclipse-based IDE, which are required for end-to-end Ajax application development. In this second part of the series, you will develop some portions of the bank scenario. In particular, you'll create a back-end database using the MySQL database. You'll get exposure to several MySQL command-line tools for connecting, creating, defining, and populating bank-specific data in the database. Then, you will develop a mid-tier PHP module to house the bank's business logic, which uses ODBC to connect to the MySQL database. Finally, you'll develop a bank portal to provide a simple browser UI through which users can interact with this end-to-end application, which will soon be ready to run on Zend Core.

In this article we explore how to program foreign keys into a MySQL Server. This is important when your application requires referential integrity and the storage engine you’d like to use, as in the case of MyISAM or NDB (Cluster), does not support this functionality natively. We should note that InnoDB and the upcoming code-named “Falcon” storage engine, both support foreign keys.