



By N2H

What is a MySQL Database?

June 8th, 2009 by Shenron

MySQL is one of the well-known relational database systems. It is owned by a Swedish company called MySQL AB, which became a subsidiary of Sun Microsystems in 2008, recently acquired by Oracle. It is widely used in web applications and also acts as a database component. It is commonly used for open source bug tracking tools such as Bugzilla. MySQL became well known due to the popularity of PHP and Ruby on Rails, which were often combined with it. High-traffic websites such as Google, YouTube, Facebook, Wikipedia and Nokia use it for data storage. It works on a variety of system platform such as Mac OS, Linux, Windows XP, Solaris and Symbian. Programmers can access its libraries which are available in different programming languages. They can use the command line tool included in the database. GUI administration tools can also be downloaded from the MySQL website. There are also free noncommercial tools that are available for use.

Two Variants of MySQL Database

MySQL has two variants: the MySQL Community Server and Enterprise Server, which shares a common code base and a host of features. This includes a cross platform support, cursors, triggers, stored procedures, independent storage engines, strict mode, updatable views, query caching, and partial Unicode support. Its distinguishing features that separate it from other relational database systems are multiple storage engines which allow the user to choose the most effective table for application, native storage systems, partner and community developed storage engines, custom storage engines and commit grouping. Starting with version 5.1, the product will be released with only one server package. A server binary will be included for debugging information. Unlike other RDBMS, MySQL was first released late in 1995. After three years, the version for windows was released. This followed a series of releases which featured developments. Version 4 had unions; version 4.1 had R and B-trees, prepared statements and subqueries, version 5 had cursors, triggers, views, XA transactions and stored procedures; and version 5.1 had an event scheduler, plugin API, server log tables, row-based replication and partitioning. Future releases of the product will include foreign key, additional Unicode characters, support for parallelization and new transactional storage engine called Falcon. These features will be included in the version 6 and 6.1. The MySQL server is a free software under the general public license and buyers have access to binaries through subscriptions. These binary updated include the latest bug fixes. Buyers of the MySQL enterprise are provided with support ranging from performance tuning to advice on system architecture. The main problem of the product nowadays is that it is prone to crashing. Wrong result bugs appear and take a long time to fix. The server also performs poorly with data warehousing.

Future of MySQL Database

MySQL has been widely used and known because it is a free software, and the company was able to address its issues when they released version 5. Nowadays, it is still popular with web applications and is still being developed for better efficiency. The database may not be as big as other competitors, but MySQL has remained popular due to its accessibility. Let’s what Oracle is up to now…

Related Posts:

What is an Open Source Database?

Create your first Mysql database

What is a Database Table?

What is JDBC or Java Database Connectivity?

What are Database Applications?

Posted in DBMS, Mysql | | 0 Comments

Create your first Mysql database

December 9th, 2008 by Shenron

Installing a script (like wordpress for example) can seem a daunting task to newbies, with all those different fields you have to fill in and to which you don’t have a clue about.

Don’t fret, we will guide you through the process of creating a new database and installing that script.

Step 1

This much you should have already figured out by now, log into cpanel and select MySQL Databases there are other types of databases but we dont need those for now.

Step 2

You should see a text area which says above it “Create New Database” yup you guessed it you put the name of the database in here and click create. Keep it simple as chances are you will have to enter it into your script at somepoint, say for example your installing vbulletin, just call it something like forum . Easy peasy so far huh?

Step 3

This is where it starts to get more complicated. Go back to the previous page and then scroll down and you should see an option further down the page which says “Add new User” and like naming the database itself keep the username simple. Then create a password, for extra security it’s probably best if you generate one but you should note this down using notepad or something as you will more than likely need to enter it uring your script installation after then you probably wont need it again but you can always retreive it from your scripts config file.

Step 4

Now we hit the back button again and this time we need to add the user to the database lets say you named it forum. Scroll down the page where you should see the option “Add user to Database” , now provided you haven’t created any other databases you shouldn’t have to select the database to add the user to, or vice versa however if you have simply select your database and user you just created from the drop down and click add.

Step 5

Were almost there chaps. Now you will have to give your database username whatever privileges you want it o have, this is more for the advanced user who wants extra security but most of you wont really need to configure these privelages so just click the ALL PRIVILEGES check box and then click make changes.

Congratulations!

You’ve just created your first database now navigate on to the next part of our tutorial to find out how to install your first script.

Related Posts: