Tutorial on installing and configuring Mysql5.6.28 in Linux (Ubuntu), tumysql5.6.28

Tutorial on installing and configuring Mysql5.6.28 in Linux (Ubuntu), tumysql5.6.28

How to install and configure mysql5.6.28

1. view the basic system information and try to install yum

$ sudo -s# df -lhFilesystem  Size Used Avail Use% Mounted on/dev/vda1  79G 1.6G 74G 3% /udev   3.9G 8.0K 3.9G 1% /devtmpfs   799M 252K 799M 1% /runnone   5.0M  0 5.0M 0% /run/locknone   3.9G  0 3.9G 0% /run/shm# uname -aLinux nj01 3.16.0-34-generic #47~14.04.1-Ubuntu SMP Fri Apr 10 17:49:16 UTC 2015 x86_64 x86_64 x86_64 GNU/Linux# rpm -qa|grep yumThe program 'rpm' is currently not installed. You can install it by typing:apt-get install rpm# apt-get install rpm……# rpm -qa|grep yum# yum install The program 'yum' is currently not installed. You can install it by typing:apt-get install yum# apt-get install yum……# yum install mysqlSetting up Install ProcessNo package mysql available.Nothing to do

2. Change the Installation Method

# Apt-get install mysql-server
Reading package lists... Done
Building dependency tree
Reading state information... Done
The following extra packages will be installed:
Libdbd-mysql-perl libdbi-perl libhtml-template-perl libmysqlclient18 libnet-daemon-perl libplrpc-perl libterm-read key-perl mysql-client-5.5
Mysql-client-core-5.5 mysql-common mysql-server-5.5 mysql-server-core-5.5
Suggested packages:
Libipc-sharedcache-perl tinyca mailx
The following NEW packages will be installed:
Libdbd-mysql-perl libdbi-perl libhtml-template-perl libmysqlclient18 libnet-daemon-perl libplrpc-perl libterm-read key-perl mysql-client-5.5
Mysql-client-core-5.5 mysql-common mysql-server mysql-server-5.5 mysql-server-core-5.5
0 upgraded, 13 newly installed, 0 to remove and 15 not upgraded.
Need to get 27.6 MB of archives.
After this operation, 98.2 MB of additional disk space will be used.
Do you want to continue [Y/n]? Y
Get: 1 http://apt.wmcloud.com/ubuntu/ precise-updates/main mysql-common all 5.5.52-0ubuntu0. 12.04.1 [12.6 kB]
Get: 2 http://apt.wmcloud.com/ubuntu/ precise-updates/main libmysqlclient18 amd64 5.5.52-0ubuntu0. 12.04.1 [952 kB]
Get: 3 http://apt.wmcloud.com/ubuntu/ precise/main libnet-daemon-perl all 0.48-1 [43.1 kB]
Get: 4 http://apt.wmcloud.com/ubuntu/ precise/main libplrpc-perl all 0.2020-2 [36.0 kB]
Get: 5 http://apt.wmcloud.com/ubuntu/ precise/main libdbi-perl amd64 1.616-1build2 [849 kB]
Get: 6 http://apt.wmcloud.com/ubuntu/ precise/main libdbd-mysql-perl amd64 4.020-1build2 [106 kB]
Get: 7 http://apt.wmcloud.com/ubuntu/ precise-updates/main mysql-client-core-5.5 amd64 5.5.52-0ubuntu0. 12.04.1 [1,948 kB]
Get: 8 http://apt.wmcloud.com/ubuntu/ precise/main libterm-readkey-perl amd64 2.30-4build3 [28.6 kB]
Get: 9 http://apt.wmcloud.com/ubuntu/ precise-updates/main mysql-client-5.5 amd64 5.5.52-0ubuntu0. 12.04.1 [8,365 kB]
Get: 10 http://apt.wmcloud.com/ubuntu/ precise-updates/main mysql-server-core-5.5 amd64 5.5.52-0ubuntu0. 12.04.1 [6,327 kB]
Get: 11 http://apt.wmcloud.com/ubuntu/ precise-updates/main mysql-server-5.5 amd64 5.5.52-0ubuntu0. 12.04.1 [8,855 kB]
Get: 12 http://apt.wmcloud.com/ubuntu/ precise/main libhtml-template-perl all 2.10-1 [65.0 kB]
Get: 13 http://apt.wmcloud.com/ubuntu/ precise-updates/main mysql-server all 5.5.52-0ubuntu0. 12.04.1 [10.8 kB]
Fetched 27.6 MB in 0 s (38.2 MB/s)
Precycling packages...
Selecting previusly unselected package mysql-common.
(Reading database... 77501 files and directories currently installed .)
Unpacking mysql-common (from.../mysql-common_5.5.52-0ubuntu0.12.04.1_all.deb )...
Selecting previusly unselected package libmysqlclient18.
Unpacking libmysqlclient18 (from.../libmysqlclient18_5.5.52-0ubuntu0.12.04.1_amd64.deb )...
Selecting previusly unselected package libnet-daemon-perl.
Unpacking libnet-daemon-perl (from.../libnet-daemon-perl_0.48-1_all.deb )...
Selecting previusly unselected package libplrpc-perl.
Unpacking libplrpc-perl (from.../libplrpc-perl_0.2020-2_all.deb )...
Selecting previusly unselected package libdbi-perl.
Unpacking libdbi-perl (from.../libdbi-perl_1.616-1build2_amd64.deb )...
Selecting previusly unselected package libdbd-mysql-perl.
Unpacking libdbd-mysql-perl (from.../libdbd-mysql-perl_4.020-1build2_amd64.deb )...
Selecting previolet unselected package mysql-client-core-5.5.
Unpacking mysql-client-core-5.5 (from.../mysql-client-core-5.5_5.5.52-0ubuntu0.12.04.1_amd64.deb )...
Selecting previusly unselected package libterm-readkey-perl.
Unpacking libterm-readkey-perl (from.../libterm-readkey-perl_2.30-4build3_amd64.deb )...
Selecting previolet unselected package mysql-client-5.5.
Unpacking mysql-client-5.5 (from.../mysql-client-5.5_5.5.52-0ubuntu0.12.04.1_amd64.deb )...
Selecting previolet unselected package mysql-server-core-5.5.
Unpacking mysql-server-core-5.5 (from.../mysql-server-core-5.5_5.5.52-0ubuntu0.12.04.1_amd64.deb )...
Processing triggers for man-db...
Setting up mysql-common (5.5.52-0ubuntu0. 12.04.1 )...
Selecting previolet unselected package mysql-server-5.5.
(Reading database... 77879 files and directories currently installed .)
Unpacking mysql-server-5.5 (from.../mysql-server-5.5_5.5.52-0ubuntu0.12.04.1_amd64.deb )...
Selecting previusly unselected package libhtml-template-perl.
Unpacking libhtml-template-perl (from.../libhtml-template-perl_2.10-1_all.deb )...
Selecting previusly unselected package mysql-server.
Unpacking mysql-server (from.../mysql-server_5.5.52-0ubuntu0.12.04.1_all.deb )...
Processing triggers for ureadahead...
Processing triggers for man-db...
Setting up libmysqlclient18 (5.5.52-0ubuntu0. 12.04.1 )...
Setting up libnet-daemon-perl (0.48-1 )...
Setting up libplrpc-perl (0.2020-2 )...
Setting up libdbi-perl (1.616-1build2 )...
Setting up libdbd-mysql-perl (4.020-1build2 )...
Setting up mysql-client-core-5.5 (5.5.52-0ubuntu0. 12.04.1 )...
Setting up libterm-readkey-perl (2.30-4build3 )...
Setting up mysql-client-5.5 (5.5.52-0ubuntu0. 12.04.1 )...
Setting up mysql-server-core-5.5 (5.5.52-0ubuntu0. 12.04.1 )...
Setting up mysql-server-5.5 (5.5.52-0ubuntu0. 12.04.1 )...
160928 10:56:48 [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.
160928 10:56:48 [Note]/usr/sbin/mysqld (mysqld 5.5.52-0ubuntu0. 12.04.1) starting as process 6166...
Mysql start/running, process 6304
Setting up libhtml-template-perl (2.10-1 )...
Setting up mysql-server (5.5.52-0ubuntu0. 12.04.1 )...
Processing triggers for libc-bin...
Ldconfig deferred processing now taking place

Enter the root password during installation;

3. The installation is successful. basic configuration

mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' identified by '******';Query OK, 0 rows affected (0.00 sec)mysql> mysql> mysql> mysql> mysql> mysql> create database testdb;Query OK, 1 row affected (0.01 sec)mysql> mysql> mysql> mysql> mysql> show databases;+--------------------+| Database   |+--------------------+| information_schema || mysql    || testdb    || performance_schema |+--------------------+4 rows in set (0.00 sec)mysql> insert into mysql.user(Host,User,Password) values("%","test",password("******"));Query OK, 1 row affected, 3 warnings (0.00 sec)mysql> mysql> flush privileges;Query OK, 0 rows affected (0.00 sec)mysql> GRANT ALL PRIVILEGES ON testdb.* TO 'test'@'% identified by '******';Query OK, 0 rows affected (0.00 sec)mysql> flush privileges;Query OK, 0 rows affected (0.00 sec)

4. Problem Solving

(1) Access Error, network connection error: 10038, telnet failure
S1. disable the firewall # ufw allow 3306, or not
S2. the user's network permission has been granted (rant all privileges on. to 'root' @ '%' identified by 'youpassword' with grant option ;)
S3. view Network Information # netstat-ano
Tcp 0 0 127.0.0.1: 3306
It should be about binding IP addresses. Modify/etc/MySQL/my. conf.
Find bind-address = 127.0.0.1.
Change bind-address = 0.0.0.0 to solve the problem.
(2) case sensitive tables:
After logging on with the root account, add lower_case_table_names = 1 to the [mysqld] in/etc/my. cnf and restart the MYSQL service. At this time, the setting is successful: The table name is case insensitive;
Lower_case_table_names parameters:
Lower_case_table_names = 0
0: Case Sensitive, 1: case insensitive

5. Basic Service commands

# Start MySQL $ sudo service mysql start # Close MySQL $ sudo service mysql stop # restart MySQL $ sudo service mysql restart # other commands: $ sudo/etc/init. d/mysql start $ sudo/etc/init. d/mysql stop $ sudo/etc/init. d/mysql restart

6. uninstall Mysql:

sudo apt-get autoremove mysql* --purgesudo apt-get remove apparmorsudo apt-get install mysql-server mysql-common

After uninstallation, delete mysql related files (/var/lib/mysql,/etc/mysql, etc. You can use find-name mysql to query the related paths)

The above is all the content of this article. I hope it will be helpful for your learning and support for helping customers.