MYSQL HELP, MYSQL TUTORIALS, MYSQL PROGRAMMING, LEARN MYSQL TRICKS

Are you thinking of running a database in the cloud, but worried about security because your database is open source? Gazzang just might have you covered. The cloud computing security firm just announced that it is expanding its ezNcrypt data encryption and security solution to cover more open source databases.

Database software company Oracle reported that Jeff Epstein, its chief financial officer, has resigned. Epstein became CFO in August of 2008, just nine months before Oracle announced a definitive agreement to acquire Sun, and with it open source database system MySQL.

In yet another sign of the changes wrought by its purchase of Sun, Oracle said that it would no longer offer a commercial version of the Open Office productivity suite for sale. The company is not completely giving up on open source software, however.

Oracle improved the performance of MySQL with the much-anticipated first development release of MySQL 5.6. This latest version of the open source database features an improved storage engine and other enhancements.

Proving that no one is immune to security breaches, both MySQL.com and Oracle's Sun.com have fallen to SQL injection attacks. The attackers exposed all the databases on MySQL.com, and compromised two Sun subdomains.

This tutorial will introduce you to seven MySQL command-line tool tips that help increase your productivity and skills using the command-line method. These are written with beginners in mind, but can still be applied by any MySQL user.

Oracle, the parent company of MySQL through their Sun Microsystems purchase, has announced the release-ready update for MySQL 5.5. This release promises performance gains of up to 360% for read/write on Linux platforms and over 600% on Windows Servers. Read on for a list of the new MySQL features for both Windows and Linux in the GA release.

There are times when using a GUI-based client, such as phpMyAdmin, for managing MySQL databases is not enough. Limitations include issues with importing databases and lack of security for MySQL sessions. You can get around these limitations if you're willing to use the command line. This article introduces the use of the command line in MySQL management.

This is a tutorial for automatically doing MySQL database backups using PHP and cron job. This will be helpful for beginners who find it complex to do backups on a periodic basis.

In this third part of the series, I further enhance the functionality of this sample MVC framework by adding a class to it that takes care of interacting with MySQL in a simple manner. You’ll see the importance of this abstraction class when I show you the definition of the corresponding model, which will aggregate an instance of “MySQL” to handle the data layer very easily.

Organize a collection of data somehow for later usage and you will get a database. In the last couple of years, with the spread of the Internet, databases have become something you will come across everywhere on the World Wide Web. Most websites have a strong database behind them. With this phase of the web's evolution, if you work in software development, eventually you will need to create and plan a database from scratch. This article is here to teach you and show you what traits a solid plan should have.

Using a MySQL GUI (Graphical User Interface) makes it easier, more efficient and user-friendly to work with a MySQL database. The two most popular MySQL GUIs, HeidiSQL and MySQL Query Browser, have their default connections to any MySQL server “unencrypted.” This is a problem, but we're going to fix it; just keep reading.

There are some hosting companies that do not offer an SSL (Secure Socket Layer) environment for MySQL. It is important to have an SSL environment for MySQL, because your sessions are protected with “encryption.” Fortunately, if you can't get SSL with your hosting company, there is an alternative: SSH.

Definitely, building chainable class methods with PHP 5 is a process that can be mastered with minor effort, even for developers with only an average level of experience in using the object-oriented paradigm. Therefore, if you're a passionate PHP programmer who wishes to learn the key concepts that surround the implementation of method chaining in a painless fashion, then this group of articles is what you need.

In this eleventh part of a 12-part series on method chaining, I will finish building the custom CodeIgniter library we've been working on by adding to it some very useful features. When we're done, the library will be able to autoload a specified model and validate input data.