Under Ubuntu 14.04 mysql install configuration tutorial _mssql

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

Method/Step

1, update the source list

Open "Terminal Window", enter "sudo apt-get update"--> carriage return--> "Enter root password"--> carriage return is OK. If you do not run this command and install MySQL directly, you will receive a "few packages that cannot be downloaded and you can run the Apt-get update------" error message, causing the installation to fail.

2, install MySQL

Open the Terminal window, enter sudo apt-get install mysql-server mysql-client--> return--> enter "y"--> carriage return--> enter MySQL in the Package Setup dialog box " Root "user's password--> carriage return--> again the password--> carriage return, installs completes.

3, how to determine whether MySQL installed successfully

Open "Terminal Window", enter "sudo service mysql restart"--> carriage return--> If MySQL starts successfully, running state indicates that the MySQL installation was successful.

4, let Apache support MySQL

Open the Terminal window, enter the "sudo apt-get install libapache2-mod-auth-mysql"--> carriage return--> installation was successful, after the installation of the module, Apache can support MySQL.

5, let PHP support MySQL

Open the Terminal window, enter the "sudo apt-get install php5-mysql"--> carriage return--> installation was successful, after installing this module, PHP can support MySQL.

6, login MySQL

Open "Terminal Window", enter "Mysql-u root-p"--> carriage return--> Enter the password of "root" user in MySQL--> return--> login succeeded.

Add a little ubuntu14.04 how to uninstall MySQL?

1, delete the MySQL data file
sudo rm/var/lib/mysql/-R
2, delete the Mqsql profile:
sudo rm/etc/mysql/-R
3, automatically uninstall the MySQL program:
sudo apt-get autoremove mysql*--purge
sudo apt-get remove AppArmor

Wonderful topic sharing: MySQL different versions of the installation Tutorials mysql5.7 version Installation Tutorials

The above is the detailed steps for installing and configuring MySQL on Ubuntu 14.04, do you like it?