Linux(Ubuntu)下Mysql5.6.28安装配置方法图文教程
mysql5.6.28安装配置方法
1.系统基本信息查看，尝试yum安装
$sudo-s #df-lh FilesystemSizeUsedAvailUse%Mountedon /dev/vda179G1.6G74G3%/ udev3.9G8.0K3.9G1%/dev tmpfs799M252K799M1%/run none5.0M05.0M0%/run/lock none3.9G03.9G0%/run/shm #uname-a Linuxnj013.16.0-34-generic#47~14.04.1-UbuntuSMPFriApr1017:49:16UTC2015x86_64x86_64x86_64GNU/Linux #rpm-qa|grepyum Theprogram'rpm'iscurrentlynotinstalled.Youcaninstallitbytyping: apt-getinstallrpm #apt-getinstallrpm …… #rpm-qa|grepyum #yuminstall Theprogram'yum'iscurrentlynotinstalled.Youcaninstallitbytyping: apt-getinstallyum #apt-getinstallyum …… #yuminstallmysql SettingupInstallProcess Nopackagemysqlavailable. Nothingtodo
2.更换安装方式
#apt-getinstallmysql-server
Readingpackagelists...Done
Buildingdependencytree
Readingstateinformation...Done
Thefollowingextrapackageswillbeinstalled:
libdbd-mysql-perllibdbi-perllibhtml-template-perllibmysqlclient18libnet-daemon-perllibplrpc-perllibterm-readkey-perlmysql-client-5.5
mysql-client-core-5.5mysql-commonmysql-server-5.5mysql-server-core-5.5
Suggestedpackages:
libipc-sharedcache-perltinycamailx
ThefollowingNEWpackageswillbeinstalled:
libdbd-mysql-perllibdbi-perllibhtml-template-perllibmysqlclient18libnet-daemon-perllibplrpc-perllibterm-readkey-perlmysql-client-5.5
mysql-client-core-5.5mysql-commonmysql-servermysql-server-5.5mysql-server-core-5.5
0upgraded,13newlyinstalled,0toremoveand15notupgraded.
Needtoget27.6MBofarchives.
Afterthisoperation,98.2MBofadditionaldiskspacewillbeused.
Doyouwanttocontinue[Y/n]?y
Get:1http://apt.wmcloud.com/ubuntu/precise-updates/mainmysql-commonall5.5.52-0ubuntu0.12.04.1[12.6kB]
Get:2http://apt.wmcloud.com/ubuntu/precise-updates/mainlibmysqlclient18amd645.5.52-0ubuntu0.12.04.1[952kB]
Get:3http://apt.wmcloud.com/ubuntu/precise/mainlibnet-daemon-perlall0.48-1[43.1kB]
Get:4http://apt.wmcloud.com/ubuntu/precise/mainlibplrpc-perlall0.2020-2[36.0kB]
Get:5http://apt.wmcloud.com/ubuntu/precise/mainlibdbi-perlamd641.616-1build2[849kB]
Get:6http://apt.wmcloud.com/ubuntu/precise/mainlibdbd-mysql-perlamd644.020-1build2[106kB]
Get:7http://apt.wmcloud.com/ubuntu/precise-updates/mainmysql-client-core-5.5amd645.5.52-0ubuntu0.12.04.1[1,948kB]
Get:8http://apt.wmcloud.com/ubuntu/precise/mainlibterm-readkey-perlamd642.30-4build3[28.6kB]
Get:9http://apt.wmcloud.com/ubuntu/precise-updates/mainmysql-client-5.5amd645.5.52-0ubuntu0.12.04.1[8,365kB]
Get:10http://apt.wmcloud.com/ubuntu/precise-updates/mainmysql-server-core-5.5amd645.5.52-0ubuntu0.12.04.1[6,327kB]
Get:11http://apt.wmcloud.com/ubuntu/precise-updates/mainmysql-server-5.5amd645.5.52-0ubuntu0.12.04.1[8,855kB]
Get:12http://apt.wmcloud.com/ubuntu/precise/mainlibhtml-template-perlall2.10-1[65.0kB]
Get:13http://apt.wmcloud.com/ubuntu/precise-updates/mainmysql-serverall5.5.52-0ubuntu0.12.04.1[10.8kB]
Fetched27.6MBin0s(38.2MB/s)
Preconfiguringpackages...
Selectingpreviouslyunselectedpackagemysql-common.
(Readingdatabase...77501filesanddirectoriescurrentlyinstalled.)
Unpackingmysql-common(from.../mysql-common_5.5.52-0ubuntu0.12.04.1_all.deb)...
Selectingpreviouslyunselectedpackagelibmysqlclient18.
Unpackinglibmysqlclient18(from.../libmysqlclient18_5.5.52-0ubuntu0.12.04.1_amd64.deb)...
Selectingpreviouslyunselectedpackagelibnet-daemon-perl.
Unpackinglibnet-daemon-perl(from.../libnet-daemon-perl_0.48-1_all.deb)...
Selectingpreviouslyunselectedpackagelibplrpc-perl.
Unpackinglibplrpc-perl(from.../libplrpc-perl_0.2020-2_all.deb)...
Selectingpreviouslyunselectedpackagelibdbi-perl.
Unpackinglibdbi-perl(from.../libdbi-perl_1.616-1build2_amd64.deb)...
Selectingpreviouslyunselectedpackagelibdbd-mysql-perl.
Unpackinglibdbd-mysql-perl(from.../libdbd-mysql-perl_4.020-1build2_amd64.deb)...
Selectingpreviouslyunselectedpackagemysql-client-core-5.5.
Unpackingmysql-client-core-5.5(from.../mysql-client-core-5.5_5.5.52-0ubuntu0.12.04.1_amd64.deb)...
Selectingpreviouslyunselectedpackagelibterm-readkey-perl.
Unpackinglibterm-readkey-perl(from.../libterm-readkey-perl_2.30-4build3_amd64.deb)...
Selectingpreviouslyunselectedpackagemysql-client-5.5.
Unpackingmysql-client-5.5(from.../mysql-client-5.5_5.5.52-0ubuntu0.12.04.1_amd64.deb)...
Selectingpreviouslyunselectedpackagemysql-server-core-5.5.
Unpackingmysql-server-core-5.5(from.../mysql-server-core-5.5_5.5.52-0ubuntu0.12.04.1_amd64.deb)...
Processingtriggersforman-db...
Settingupmysql-common(5.5.52-0ubuntu0.12.04.1)...
Selectingpreviouslyunselectedpackagemysql-server-5.5.
(Readingdatabase...77879filesanddirectoriescurrentlyinstalled.)
Unpackingmysql-server-5.5(from.../mysql-server-5.5_5.5.52-0ubuntu0.12.04.1_amd64.deb)...
Selectingpreviouslyunselectedpackagelibhtml-template-perl.
Unpackinglibhtml-template-perl(from.../libhtml-template-perl_2.10-1_all.deb)...
Selectingpreviouslyunselectedpackagemysql-server.
Unpackingmysql-server(from.../mysql-server_5.5.52-0ubuntu0.12.04.1_all.deb)...
Processingtriggersforureadahead...
Processingtriggersforman-db...
Settinguplibmysqlclient18(5.5.52-0ubuntu0.12.04.1)...
Settinguplibnet-daemon-perl(0.48-1)...
Settinguplibplrpc-perl(0.2020-2)...
Settinguplibdbi-perl(1.616-1build2)...
Settinguplibdbd-mysql-perl(4.020-1build2)...
Settingupmysql-client-core-5.5(5.5.52-0ubuntu0.12.04.1)...
Settinguplibterm-readkey-perl(2.30-4build3)...
Settingupmysql-client-5.5(5.5.52-0ubuntu0.12.04.1)...
Settingupmysql-server-core-5.5(5.5.52-0ubuntu0.12.04.1)...
Settingupmysql-server-5.5(5.5.52-0ubuntu0.12.04.1)...
16092810:56:48[Warning]Usinguniqueoptionprefixkey_bufferinsteadofkey_buffer_sizeisdeprecatedandwillberemovedinafuturerelease.Pleaseusethefullnameinstead.
16092810:56:48[Note]/usr/sbin/mysqld(mysqld5.5.52-0ubuntu0.12.04.1)startingasprocess6166...
mysqlstart/running,process6304
Settinguplibhtml-template-perl(2.10-1)...
Settingupmysql-server(5.5.52-0ubuntu0.12.04.1)...
Processingtriggersforlibc-bin...
ldconfigdeferredprocessingnowtakingplace
安装过程中输入root的密码即可；
3.安装成功，基本配置
mysql>GRANTALLPRIVILEGESON*.*TO'root'@'%'identifiedby'******';
QueryOK,0rowsaffected(0.00sec)
mysql>
mysql>
mysql>
mysql>
mysql>
mysql>createdatabasetestdb;
QueryOK,1rowaffected(0.01sec)
mysql>
mysql>
mysql>
mysql>
mysql>showdatabases;
+--------------------+
|Database|
+--------------------+
|information_schema|
|mysql|
|testdb|
|performance_schema|
+--------------------+
4rowsinset(0.00sec)
mysql>insertintomysql.user(Host,User,Password)values("%","test",password("******"));
QueryOK,1rowaffected,3warnings(0.00sec)
mysql>
mysql>flushprivileges;
QueryOK,0rowsaffected(0.00sec)
mysql>GRANTALLPRIVILEGESONtestdb.*TO'test'@'%identifiedby'******';
QueryOK,0rowsaffected(0.00sec)
mysql>flushprivileges;
QueryOK,0rowsaffected(0.00sec)
4.问题解决
（1）访问报错，网络连接报错：10038，telnet不通
S1.关闭防火墙#ufwallow3306，还是不行
S2.用户网络权限已经给了（rantallprivilegeson.to‘root'@'%'identifiedby‘youpassword'withgrantoption;）
S3.查看网路信息#netstat-ano
tcp00127.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.基本服务命令
#启动MySQL$sudoservicemysqlstart #关闭MySQL$sudoservicemysqlstop #重启MySQL$sudoservicemysqlrestart #其他命令：$sudo/etc/init.d/mysqlstart $sudo/etc/init.d/mysqlstop $sudo/etc/init.d/mysqlrestart
6.卸载Mysql：
sudoapt-getautoremovemysql*--purge sudoapt-getremoveapparmor sudoapt-getinstallmysql-servermysql-common
卸载后删除mysql相关文件（/var/lib/mysql，/etc/mysql等等，可以用find-namemysql查询下相关路径）
以上就是本文的全部内容，希望对大家的学习有所帮助，也希望大家多多支持毛票票。