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查询下相关路径)
以上就是本文的全部内容,希望对大家的学习有所帮助,也希望大家多多支持毛票票。