Install the MySQL server and client in Ubuntu14.04

Now the software in Linux is getting better and better to install, especially when installing software in Ubuntu, It is not skillful. You only need to use apt-getinatll when connected. Resolution

Now the software in Linux is getting better and better to install, especially when installing software in Ubuntu, It is not skillful. You only need to use apt-get inatll when connected. Resolution

Now the software in Linux is getting better and better to install, especially when installing software in Ubuntu, It is not skillful. You only need to use apt-get inatll when connected. Before deciding to install MySQL, you must first determine whether the system has installed MySQL.

-------------------------------------- Split line --------------------------------------

Install MySQL in Ubuntu 14.04

MySQL authoritative guide (original book version 2nd) Clear Chinese scan PDF

Ubuntu 14.04 LTS install LNMP Nginx \ PHP5 (PHP-FPM) \ MySQL

Build a MySQL Master/Slave server in Ubuntu 14.04

Build a highly available distributed MySQL cluster using Ubuntu 12.04 LTS

Install MySQL5.6 and Python-MySQLdb in the source code of Ubuntu 12.04

MySQL-5.5.38 universal binary Installation

-------------------------------------- Split line --------------------------------------

Test version: Ubuntu 14.04

Hadoop @ master :~ $ Netstat-tap | grep mysql
(Not all processes can be detected. process information of all non-users is not displayed. To view all information, you must switch to the root user)

We can see that mysql is not installed in the system. Run the following command to install mysql.

Hadoop @ master :~ $ Sudo apt-get install mysql-server
Reading the package list... complete
Analyzing the dependency tree of the software package
Reading status information... complete
The following additional software packages will be installed:
Libdbd-mysql-perl libdbi-perl libhtml-template-perl libmysqlclient18
Libterm-readkey-perl mysql-client-5.5 mysql-common mysql-server-5.5
Mysql-server-core-5.5
Recommended software packages:
Libmldbm-perl libnet-daemon-perl libplrpc-perl libsql-statement-perl
Libipc-sharedcache-perl tinyca mailx
The following [new] software packages will be installed:
Libdbd-mysql-perl libdbi-perl libhtml-template-perl libmysqlclient18
Libterm-readkey-perl mysql-client-5.5 for mysql-common mysql-server
Mysql-server-5.5 mysql-server-core-5.5
0 software packages have been upgraded, 10 new software packages have been installed, and 0 software packages have to be uninstalled. 158 software packages have not been upgraded.
Download the 8,343 kB software package.
After decompression, 86.8 MB of extra space is consumed.
Do you want to continue? [Y/n]

Enter Y to go to the installation page. During the installation process, a page will pop up asking you to enter the mysql root Password. Enter the password here, saving you the trouble of setting the password after installation.

Enter the password again:

Get: 1 trusty-updates/main mysql-common all 5.5.38-0ubuntu0. 14.04.1 [14.1 kB]
Get: 2 trusty-updates/main libmysqlclient18 i386 5.38-0ubuntu0. 14.04.1 [592 kB]
Get: 3 trusty/main libdbi-perl i386 1.630-1 [881 kB]
Get: 4 trusty/main libdbd-mysql-perl i386 4.025-1 [99.6 kB]
Get: 5 trusty/main libterm-readkey-perl i386 2.31-1 [27.2 kB]
Get: 6 trusty-updates/main mysql-client-5.5 i386 5.38-0ubuntu0. 14.04.1 [1,433 kB]
Get: 7 trusty-updates/main mysql-server-core-5.5 i386 5.38-0ubuntu0. 14.04.1 [3,135 kB]
Get: 8 trusty-updates/main mysql-server-5.5 i386 5.38-0ubuntu0. 14.04.1 [2,082 kB]
Get: 9 trusty/main libhtml-template-perl all 2.95-1 [65.5 kB]
Get: 10 trusty-updates/main mysql-server all 5.5.38-0ubuntu0. 14.04.1 [12.4 kB]
Download 8,343 kB, 49 seconds (168 kB/s)
Configuring the software package...
Selecting previusly unselected package mysql-common.
(Reading the database... the system currently has 212184 files and directories installed .)
Preparing to unpack.../mysql-common_5.5.38-0ubuntu0.14.04.1_all.deb...
Unpacking mysql-common (5.5.38-0ubuntu0. 14.04.1 )...
Selecting previusly unselected package libmysqlclient18: iworkflow.
Preparing to unpack.../libmysqlclient18_5.5.38-0ubuntu0.14.04.1_i386.deb...
Unpacking libmysqlclient18: i386 (5.5.38-0ubuntu0. 14.04.1 )...
Selecting previusly unselected package libdbi-perl.
Preparing to unpack.../libdbi-perl_1.630-1_i386.deb...
Unpacking libdbi-perl (1.630-1 )...
Selecting previusly unselected package libdbd-mysql-perl.
Preparing to unpack.../libdbd-mysql-perl_4.025-1_i386.deb...
Unpacking libdbd-mysql-perl (4.025-1 )...
Selecting previusly unselected package libterm-readkey-perl.
Preparing to unpack.../libterm-readkey-perl_2.31-1_i386.deb...
Unpacking libterm-readkey-perl (2.31-1 )...
Selecting previolet unselected package mysql-client-5.5.
Preparing to unpack.../mysql-client-5.5_5.5.38-0ubuntu0.14.04.1_i386.deb...
Unpacking mysql-client-5.5 (5.5.38-0ubuntu0. 14.04.1 )...
Selecting previolet unselected package mysql-server-core-5.5.
Preparing to unpack.../mysql-server-core-5.5_5.5.38-0ubuntu0.14.04.1_i386.deb...
Unpacking mysql-server-core-5.5 (5.5.38-0ubuntu0. 14.04.1 )...
Processing triggers for man-db (2.6.7.1-1 )...
Setting mysql-common (5.5.38-0ubuntu0. 14.04.1 )...
Selecting previolet unselected package mysql-server-5.5.
(Reading the database... the system currently has 212532 files and directories installed .)
Preparing to unpack.../mysql-server-5.5_5.5.38-0ubuntu0.14.04.1_i386.deb...
Unpacking mysql-server-5.5 (5.5.38-0ubuntu0. 14.04.1 )...
Selecting previusly unselected package libhtml-template-perl.
Preparing to unpack.../libhtml-template-perl_2.95-1_all.deb...
Unpacking libhtml-template-perl (2.95-1 )...
Selecting previusly unselected package mysql-server.
Preparing to unpack.../mysql-server_5.5.38-0ubuntu0.14.04.1_all.deb...
Unpacking mysql-server (5.5.38-0ubuntu0. 14.04.1 )...
Processing triggers for ureadahead (0.100.0-16 )...
Ureadahead will be reprofiled on next reboot
Processing triggers for man-db (2.6.7.1-1 )...
Setting libmysqlclient18: i386 (5.5.38-0ubuntu0. 14.04.1 )...
Setting libdbi-perl (1.630-1 )...
Setting libdbd-mysql-perl (4.025-1 )...
Setting libterm-readkey-perl (2.31-1 )...
Setting mysql-client-5.5 (5.5.38-0ubuntu0. 14.04.1 )...
Setting mysql-server-core-5.5 (5.5.38-0ubuntu0. 14.04.1 )...
Setting mysql-server-5.5 (5.5.38-0ubuntu0. 14.04.1 )...
16:29:54 [Warning] Using unique option prefix key_buffer instead of key_buffer_size is deprecated and will be removed in a future release. Please use the full name instead.
Mysql start/running, process 31215
Setting libhtml-template-perl (2.95-1 )...
Processing triggers for ureadahead (0.100.0-16 )...
Setting mysql-server (5.5.38-0ubuntu0. 14.04.1 )...
Processing triggers for libc-bin (2.19-0ubuntu6. 1 )...

MySQL Server Installation Process

After installing mysql, you can use netstat-tap | grep mysql to check whether the system has the mysql service.

The above information indicates that mysql is successfully installed.

Run the following command to view the MySQL version:

Hadoop @ master :~ $ Mysql-V
Mysql Ver 14.14 Distrib 5.5.38, for debian-linux-gnu (i686) using readline 6.3

For more details, please continue to read the highlights on the next page: