Installation and configuration of Ubuntu 14.04 database server--mysql

MySQL is an open-source relational database management system of Oracle Company, which is widely used in small and medium-sized websites, is a cross-platform database management system, now describes how to install and configure MySQL on Ubuntu 14.04

1. Update the source list

Open "Terminal Window", enter "sudo apt-get update"-and "enter the root user's password"--return, you can. If you do not run the command and install MySQL directly, a "few packages cannot be downloaded, you can run the Apt-get update------" error message, causing the installation to fail.

2. Install MySQL

Open terminal window, enter "sudo apt-get install mysql-server mysql-client"-Enter MySQL in the "Package Setup dialog box"--Enter "Y"--and return to " Root "user's password--Enter and lose the password again--Enter, the installation is complete.

3. How to determine if MySQL installation is successful

Open "Terminal Window", enter "sudo service mysql restart"-and enter-if MySQL starts successfully, the running status instructions MySQL installation is successful.

4. Let Apache support MySQL

Open "Terminal Window", enter "sudo apt-get install Libapache2-mod-auth-mysql"----the installation is successful, Apache will support MySQL after installing this module.

5. Let PHP support MySQL

Open "Terminal Window", enter "sudo apt-get install Php5-mysql"----the installation is successful, PHP will support MySQL after installing this module.

6. Log in to MySQL

Open terminal window, enter "Mysql-u root-p" and enter the password for the "root" user in MySQL----and the login is successful.

Precautions

Be sure to remember the root user password that was set when you installed MySQL, and the root user of the Ubuntu 14.04 system is not the same user as the root user in MySQL.

Installation and configuration of Ubuntu 14.04 database server--mysql