Linux(Ubuntu)下Mysql5.6.28安装配置方法图文教程

数据运维 2023-04-27 张二河 手机阅读

mysql5.6.28安装配置方法 1.系统基本信息查看，尝试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

                        <p>mysql5.6.28安装配置方法</p>

1.系统基本信息查看，尝试yum安装

$ sudo -s

  1. df -lh Filesystem Size Used Avail Use% Mounted on /dev/vda1 79G 1.6G 74G 3% / udev 3.9G 8.0K 3.9G 1% /dev tmpfs 799M 252K 799M 1% /run none 5.0M 0 5.0M 0% /run/lock none 3.9G 0 3.9G 0% /run/shm

  2. uname -a Linux 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

  3. rpm -qa|grep yum The program 'rpm' is currently not installed. You can install it by typing: apt-get install rpm

  4. apt-get install rpm ……

  5. rpm -qa|grep yum

  6. yum install The program 'yum' is currently not installed. You can install it by typing: apt-get install yum

  7. apt-get install yum ……

  8. yum install mysql Setting up Install Process No package mysql available. Nothing to do

2.更换安装方式

# 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-readkey-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-readkey-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 0s (38.2 MB/s)    Preconfiguring packages ... Selecting previously 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 previously unselected package libmysqlclient18. Unpacking libmysqlclient18 (from .../libmysqlclient18_5.5.52-0ubuntu0.12.04.1_amd64.deb) ... Selecting previously unselected package libnet-daemon-perl. Unpacking libnet-daemon-perl (from .../libnet-daemon-perl_0.48-1_all.deb) ... Selecting previously unselected package libplrpc-perl. Unpacking libplrpc-perl (from .../libplrpc-perl_0.2020-2_all.deb) ... Selecting previously unselected package libdbi-perl. Unpacking libdbi-perl (from .../libdbi-perl_1.616-1build2_amd64.deb) ... Selecting previously unselected package libdbd-mysql-perl. Unpacking libdbd-mysql-perl (from .../libdbd-mysql-perl_4.020-1build2_amd64.deb) ... Selecting previously 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 previously unselected package libterm-readkey-perl. Unpacking libterm-readkey-perl (from .../libterm-readkey-perl_2.30-4build3_amd64.deb) ... Selecting previously 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 previously 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 previously 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 previously unselected package libhtml-template-perl. Unpacking libhtml-template-perl (from .../libhtml-template-perl_2.10-1_all.deb) ... Selecting previously 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

安装过程中输入root的密码即可；

3.安装成功，基本配置

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.问题解决

（1）访问报错，网络连接报错：10038 ，telnet 不通 S1.关闭防火墙 # ufw allow 3306 ，还是不行 S2.用户网络权限已经给了（rant all privileges on . to ‘root'@'%' identified by ‘youpassword' with grant option;） S3.查看网路信息 # netstat -ano tcp 0 0 127.0.0.1:3306 应该是绑定IP问题，修改/etc/MySQL/my.conf 找到bind-address = 127.0.0.1这一行 改为bind-address = 0.0.0.0，问题解决。 （2）表区分大小写： 用root帐号登录后，在/etc/my.cnf 中的[mysqld]后添加添加lower_case_table_names=1，重启MYSQL服务，这时已设置成功：不区分表名的大小写； lower_case_table_names参数详解： lower_case_table_names = 0 其中 0：区分大小写，1：不区分大小写

5.基本服务命令

  1. 启动MySQL$ sudo service mysql start
  2. 关闭MySQL$ sudo service mysql stop
  3. 重启MySQL$ sudo service mysql restart
  4. 其他命令：$ sudo /etc/init.d/mysql start $ sudo /etc/init.d/mysql stop $ sudo /etc/init.d/mysql restart

6.卸载Mysql：

sudo apt-get autoremove mysql* --purge sudo apt-get remove apparmor sudo apt-get install mysql-server mysql-common

卸载后删除mysql相关文件（/var/lib/mysql ， /etc/mysql等等，可以用 find -name mysql 查询下相关路径）

以上就是本文的全部内容，希望对大家的学习有所帮助，也希望大家多多支持每日运维。