MYSQL

About MySQL

MySQL is the world’s most popular open source database software, with over 100 million copies of its software downloaded or distributed throughout it’s history. With its superior speed, reliability, and ease of use, MySQL has become the preferred choice for Web, Web 2.0, SaaS, ISV, Telecom companies and forward-thinking corporate IT Managers because it eliminates the major problems associated with downtime, maintenance and administration for modern, online applications.

Many of the world’s largest and fastest-growing organizations use MySQL to save time and money powering their high-volume Web sites, critical business systems, and packaged software — including industry leaders such as Yahoo!, Alcatel-Lucent, Google, Nokia, YouTube, Wikipedia, and Booking.com.

The flagship MySQL offering is MySQL Enterprise, a comprehensive set of production-tested software, proactive monitoring tools, and premium support services available in an affordable annual subscription.

MySQL is a key part of LAMP (Linux, Apache, MySQL, PHP / Perl / Python), the fast-growing open source enterprise software stack. More and more companies are using LAMP as an alternative to expensive proprietary software stacks because of its lower cost and freedom from platform lock-in.

MySQL was originally founded and developed in Sweden by two Swedes and a Finn: David Axmark, Allan Larsson and Michael “Monty” Widenius, who had worked together since the 1980’s. More historical information on MySQL is available on Wikipedia

Our Continued MySQL Values

We want the MySQL database to be:

  • The best and the most-used database in the world for online applications
  • Available and affordable for all
  • Easy to use
  • Continuously improved while remaining fast, secure and reliable
  • Fun to use and improve
  • Free from bugs

 

We want the people working on MySQL to:

  • Subscribe to the Open Source philosophy
  • Aim to be good citizens
  • Prefer partners that share our values and mindset
  • Answer email and give assistance to users, customers, partners and co-workers
  • Be a virtual organization, networking with others

 

Creating a MySQL Database Detailed Tutorial

Creating a MySQL database with cPanel, which is included in all of SiteGround’s hosting plans, can be easily accomplished. In order to create a MySQL database on your hosting account, you need to log in cPanel. This can be done by either using the Go to cPanel button in the Customer Area ->My Accounts section or by entering one of the following URLs in your web browser:

http://yourdomainname.com/cpanel
http://cpanel.servername.com

Important You should replace “yourdomainname.com” with your actual domain name or “servername.com” with the hostname of the SiteGround server on which your account is hosted.

Once you have logged in cPanel, you can access the MySQL management screen by clicking on the MySQL Databases button as shown below.

In order to create a new database you need to enter the desired name for the database in the New Database field and click on the Create Database button as shown below:

Create New Database

A confirmation screen will be displayed, informing that the database has been successfully created:

You can click on the Go Back button to return to the database management screen.

Important The MySQL database is created with your username as prefix – username_databasename and this is the name you have to use for your application.

Creating a MySQL Username Detailed Tutorial

You can continue with the creation of a user who should be able to connect to the newly created database. To create a user you just need to fill in the desired user name and password as shown in the image below:

Add New User

Click Submit to save your MySQL username.

ImportantYou should always bear in mind that your cPanel username will be added as a prefix to all databases and usernames you create.

Adding a user to a MySQL Database Detailed Tutorial

Once the database and the username are created, you can add certain privileges for the user to the database. In order to do so you should select them both from the corresponding drop-down menus under Add User To Database label and click on the Submit button:

Add User to Database

You will be redirected to a screen where you will be prompted to choose the desired privileges. It is advisable to select All Privileges and click on the Make Changes button:

Manage User Privileges

Using the MySQL Database Wizard

All of the steps above can be accomplished using the MySQL Database Wizard. Click on it and you will be guided trough all steps that you should perform in order to successfully create a new MySQL database and add a user to it.

MySQL Database Wizard

Check out the Using MySQL Databases Wizard video tutorial:

Add a Comment

Your email address will not be published. Required fields are marked *