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

推荐整理分享Linux(Ubuntu)下Mysql5.6.28安装配置方法图文教程，希望有所帮助，仅作参考，欢迎阅读内容。

文章相关热门搜索词:,内容如对您有帮助，希望把文章链接给更多的朋友！

mysql5.6.安装配置方法

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

2.更换安装方式

# apt-get install mysql-serverReading package lists... DoneBuilding dependency tree Reading state information... DoneThe following extra packages will be installed: libdbd-mysql-perl libdbi-perl libhtml-template-perl libmysqlclient 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.5Suggested packages: libipc-sharedcache-perl tinyca mailxThe following NEW packages will be installed: libdbd-mysql-perl libdbi-perl libhtml-template-perl libmysqlclient 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. upgraded, newly installed, 0 to remove and not upgraded.Need to get .6 MB of archives.After this operation, .2 MB of additional disk space will be used.Do you want to continue [Y/n]&#; yGet:1 precise-updates/main mysql-common all 5.5.-0ubuntu0...1 [.6 kB]Get:2 precise-updates/main libmysqlclient amd 5.5.-0ubuntu0...1 [ kB]Get:3 precise/main libnet-daemon-perl all 0.-1 [.1 kB]Get:4 precise/main libplrpc-perl all 0.-2 [.0 kB]Get:5 precise/main libdbi-perl amd 1.-1build2 [ kB]Get:6 precise/main libdbd-mysql-perl amd 4.-1build2 [ kB]Get:7 precise-updates/main mysql-client-core-5.5 amd 5.5.-0ubuntu0...1 [1, kB]Get:8 precise/main libterm-readkey-perl amd 2.-4build3 [.6 kB]Get:9 precise-updates/main mysql-client-5.5 amd 5.5.-0ubuntu0...1 [8, kB]Get: precise-updates/main mysql-server-core-5.5 amd 5.5.-0ubuntu0...1 [6, kB]Get: precise-updates/main mysql-server-5.5 amd 5.5.-0ubuntu0...1 [8, kB]Get: precise/main libhtml-template-perl all 2.-1 [.0 kB]Get: precise-updates/main mysql-server all 5.5.-0ubuntu0...1 [.8 kB]Fetched .6 MB in 0s (.2 MB/s) Preconfiguring packages ...Selecting previously unselected package mysql-common.(Reading database ... files and directories currently installed.)Unpacking mysql-common (from .../mysql-common_5.5.-0ubuntu0...1_all.deb) ...Selecting previously unselected package libmysqlclient.Unpacking libmysqlclient (from .../libmysqlclient_5.5.-0ubuntu0...1_amd.deb) ...Selecting previously unselected package libnet-daemon-perl.Unpacking libnet-daemon-perl (from .../libnet-daemon-perl_0.-1_all.deb) ...Selecting previously unselected package libplrpc-perl.Unpacking libplrpc-perl (from .../libplrpc-perl_0.-2_all.deb) ...Selecting previously unselected package libdbi-perl.Unpacking libdbi-perl (from .../libdbi-perl_1.-1build2_amd.deb) ...Selecting previously unselected package libdbd-mysql-perl.Unpacking libdbd-mysql-perl (from .../libdbd-mysql-perl_4.-1build2_amd.deb) ...Selecting previously unselected package mysql-client-core-5.5.Unpacking mysql-client-core-5.5 (from .../mysql-client-core-5.5_5.5.-0ubuntu0...1_amd.deb) ...Selecting previously unselected package libterm-readkey-perl.Unpacking libterm-readkey-perl (from .../libterm-readkey-perl_2.-4build3_amd.deb) ...Selecting previously unselected package mysql-client-5.5.Unpacking mysql-client-5.5 (from .../mysql-client-5.5_5.5.-0ubuntu0...1_amd.deb) ...Selecting previously unselected package mysql-server-core-5.5.Unpacking mysql-server-core-5.5 (from .../mysql-server-core-5.5_5.5.-0ubuntu0...1_amd.deb) ...Processing triggers for man-db ...Setting up mysql-common (5.5.-0ubuntu0...1) ...Selecting previously unselected package mysql-server-5.5.(Reading database ... files and directories currently installed.)Unpacking mysql-server-5.5 (from .../mysql-server-5.5_5.5.-0ubuntu0...1_amd.deb) ...Selecting previously unselected package libhtml-template-perl.Unpacking libhtml-template-perl (from .../libhtml-template-perl_2.-1_all.deb) ...Selecting previously unselected package mysql-server.Unpacking mysql-server (from .../mysql-server_5.5.-0ubuntu0...1_all.deb) ...Processing triggers for ureadahead ...Processing triggers for man-db ...Setting up libmysqlclient (5.5.-0ubuntu0...1) ...Setting up libnet-daemon-perl (0.-1) ...Setting up libplrpc-perl (0.-2) ...Setting up libdbi-perl (1.-1build2) ...Setting up libdbd-mysql-perl (4.-1build2) ...Setting up mysql-client-core-5.5 (5.5.-0ubuntu0...1) ...Setting up libterm-readkey-perl (2.-4build3) ...Setting up mysql-client-5.5 (5.5.-0ubuntu0...1) ...Setting up mysql-server-core-5.5 (5.5.-0ubuntu0...1) ...Setting up mysql-server-5.5 (5.5.-0ubuntu0...1) ... :: [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. :: [Note] /usr/sbin/mysqld (mysqld 5.5.-0ubuntu0...1) starting as process ...mysql start/running, process Setting up libhtml-template-perl (2.-1) ...Setting up mysql-server (5.5.-0ubuntu0...1) ...Processing triggers for libc-bin ...ldconfig deferred processing now taking place

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

3.安装成功，基本配置

4.问题解决

（1）访问报错，网络连接报错： ，telnet 不通 S1.关闭防火墙 # ufw allow ，还是不行 S2.用户网络权限已经给了（rant all privileges on . to ‘root'@'%' identified by ‘youpassword' with grant option;） S3.查看网路信息 # netstat -ano tcp 0 0 .0.0.1: 应该是绑定IP问题，修改/etc/MySQL/my.conf 找到bind-address = .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.基本服务命令

6.卸载Mysql：

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