LNMP (nginx php-fpm mysql) environment deployment--mysql

Objective:

The previous article has said that the deployment of the original intention, if not clear, you can look at the preface of the previous article or leave a message in the comment area to me.

This article mainly introduces the method of installing MySQL, PHP will use the MySQL connection database

Get ready:

MySQL official website: mysql.com

SOURCE directory:/USR/LOCAL/SRC

MySQL official provide the official library, source code, binary package three ways to install. This article will introduce the official library, the source package installation method, for the binary package, download can be used directly.

This article introduces MySQL 5.6 Community Edition, do not choose wrong when downloading

Installation:

Install using the official library:

1 Configuring Mysql.repo

vim/etc/yum.repos.d/mysql.repo# Enable to use MySQL 5.6[mysql56-community]name=mysql 5.6 Community Serverbaseurl=http ://repo.mysql.com/yum/mysql-5.6-community/el/6/$basearch/enabled=1gpgcheck=1

2 Createmysql_pubkey.asc


可参考http://dev.mysql.com/doc/refman/5.6/en/checking-gpg-signature.html

Vim MYSQL_PUBKEY.ASC

-----begin pgp public key block-----version: gnupg v1.4.9  (SunOS) mQGiBD4+ Owwrbac14gifufcyedsiepvew3safudjbtoqhh/njkzyqt7h9bpluwc3rodjqreycitrrdwyrkugku2fmevgwn2u2wmdmnablnpprwpkbdck96 +omsln9brzfw2vougcmyv2hw0hydhuvylqa/bthqoadgj8aw6/0lo7v1w9/8vuhp0gqwcgvzv3bqoxrznncrcrxauauvzthrceajooqk1+ isiunzmyd1wufexfshc57s/+yejkegnwhxwr9prwvarnyjddrt+rf2rue3vpquknqu/ hneiuhjrqqyho8gtxvxxnqc7fjylvk2htkrpbp72vwsekmyhhr0ekcbtlgfls9krjj6sbgacyp/ vb7hipwxh6rdz7itnekypxbacmwpp8njtkamenpcia2zoohodanwpukp43i7jsdmgtobzx9qnraxw+ undiqjexm6fsbi0lltzcinlysafwapeomdkpmqak6iyisntpvald8lh0bpanwqcyefeprv0sxxquemcm3o7wwgfn83pokdasdbs3pjwphxvhz6/ /62zqj7q2txltuuwgumvszwfzzsbfbmdpbmvlcmluzya8bxlzcwwtynvpbgrab3nzlm9yywnszs5jb20+ igkeexecackcgymgcwkibwmcbbuccamefgidaqieaqixgaizaqucuwhuzgujgmblywakcrcmcy07uhlh9v+dakcjs1ggwgvi/eut+5l+ l2v3ybl+ Zgccd7zoa341htorov3u6xrd09fugeq0o015u1fmifbhy2thz2ugc2lnbmluzybrzxkgkhd3dy5texnxbc5jb20pidxidwlszebtexnxbc5jb20 +ig8embecac8fak53pa0ohsbidwlszebtexnxbc5jb20gd2lsbcbzdg9wihdvcmtpbmcgc29vbgakcrcmcy07uhlh9bu9aj9xdk0oxjfl9vtl9oszc4lx0k9azwcccrs9cnjyz79earjl0s2r/ Ccljdyizqqteqiahqucr6yutaujdtbyqaulbwodbamvawidfgibaheaabijeixxjttqcuh1b2vhuecaaqgukgcffz4guejzxkoi71vcwgcxastgbe0an34lpr 1j9fcbrxwxo14msiadfb5pieweexecaawfaj4+o9efgwlmalsacgkqsvdhkrjykfik4qcfwbeekn+3trspe+5xkj+ Kqjsammianjuz0xfwplvx0f8o38qng1bq0cu9ieweexecaawfaj5cggmfgwliiokacgkqtvxntca6jd+ wkqcgigmnogjmojynp5ppvmxkyukfnykaok79e6h8rwksdzouiz7nmrish8uyieyeebecaayfaj+s468acgkqr8ujshidda/ 2lgcg21ihimmabtydp/ibiusp/jqlieoanrzmywetujqz/e9ono7h1dkebda4ieyeebecaayfaj+ 0q3cacgkqhzavqzbztmbgwwcdfqd1frvic7wrt8gkoos7hznn32kanirlbwpnt7a6nosq83nk11a2dephieyeebecaayfaknbs+ oacgkqi9gubzc5s1x/ dacdelkoxqkkwjn0gzztsm7kjsigyfmanrrmbhq7v39xc90oipapjk3a01tgieyeexecaayfaktxmyyacgkq9kne9gctuwwkcqcgibak/ swhxwh1ijrhgyco5gtm4vcanahtzl57wcw1kg1xm7nvgetuqj7fieweebecaawfakgbywefgwyi2ysacgkqgfnqh2d7oexcjqccd8sjndc/ ms8m8ogduox9vmwcngkanj1ywod+qhxo3mi/ul9oeahnkjcfieweebecaawfakgbyzqfgwyi2vgacgkqgcl36+ittpiiiwcdfvnvub8xe8mfxopm4d9z54ptjpmanispa/ zsfj3oomlkar4f0qpprdrgieweebecaawfakgby2ifgwyi2soacgkqa3ds2v3d9hmjqgcbbyzr5gpxoxgp88jkzmdbjweqxeeanrss4g2g/ 3qd7uhtl1spt1shjwuxieweebecaawfakhqkyqfgwxuewgacgkqfsxkcsepp8jivqcghvwvkpqowsw8w7wssetcw1tflvkani+vlhl/ Dqily0lkzyn5jzk1dpvfieweebecaawfakirw7ofgwv5sniacgkq5hukirxruavzewcgkzl5qklsypcw9lghcfsx1ya0vl4an35nxkumg6ccj1np8r2i4nczw Irqieweehecaawfakaqwtofgwd6s1iacgkqpkefnjt6+gemxaccd+ a53a5ogm7w750w11ukq4iz9ckanrmvndaqn3ytoxxllpj2upzisgsqieweehecaawfaka9+rofgwdmqdiacgkq8tdcy+ oczzyy3wcgtdcwlaq20w0cnuxfllneeuafftwani6rhn80mosvaddtrkzzacju3m5qieweehecaawfakeocoqfgwawmggacgkqocor9d1qil/ 83qceitz9wio7xamjc6y4zwul4m+edzsaomohriri42fmrnfuvnzbnmgej81vieweehecaawfakkaptqfgwuj/ 1gacgkqba3ahxydn6jjjaccd1a4utxk84j13jqyoh9+dy24714aniwlsso/ 9ndicjokqs2j5dlhfq6oieweexecaawfaj5ntyqfgwlxvwgacgkqlbt2v63uytmfdacglt5g5nvkf5mj65bfslpzb92zk2qan1uc2h19/ iwwrsbiyk/9poj+jmp7ieweexecaawfakhxghyfgwxnjbyacgkqzu/bym2c/t4/vacfxe67xishb80wkmfz2krb+oz/ Gbaanjr2ucpbaonkqqgnc3gnbqmcvnajieweexecaawfakiygq4fgwwmi34acgkqdsedhkixbqgg7gcfqi2hcrhn+ Ylfunlh1osoh48zm0oan3hkv0uirjphonhauyiup1ttwgdbigueexecab0fcwckawqdfqmcaxycaqixgaucs3avygujeppzpwasb2vhuecaaqejeixxjttqcu h1snsaniypybgqy/ Hhmnw3we8kxahoor5kaj4xumwpgyp4l3hkxynk9oaubpdvyih7bdaraga7bqjcdzx1nb0at29wcy4ulibzag91bgqgagf2zsbizwvuigxvy2fsisbjj20gknn vkibzdhvwawquli4acgkqocor9d1qil/ Vrwcdfo08f66okliueaqzlf9idlpozeean2egvcylcchjfgosrkru3wk5nfvgii8embecae8fakvval9ihqbtag91bgqgagf2zsbizwvuigegbg9jywwgc2ln bmf0dxjllcbvcibzb21ldghpbmcglsbxveygd2fziekgdghpbmtpbmc/aaojednkk/ q9aopfopsan3bvqkoaljef0xpsvlr90psrlnmgaj44oisy7tl3njbpgzal8w32fbqgbikcigqqaqiadaucqyhlhqwdbilzbwakcrcq4+ bozqfeakgveaccernahgyuya0wetjj6dlexsqeoixad4i9abqxnd35gugcfofc/ncy4xcncmmenmdq9ofuuu3obj6bnjibeusaabglooebp/ 3keaiciiyhhyu5jarpzah+zopgs3oc11mq1tias69ijxrgtlodkasajaeeuwtpq9fhffzc1egbysoyfwg4bijz/zcli+ qytbfa5g6troixto8ko7qhy2aa5ugeg+83hdb6akc04z2qrerxkaqrphhzj8xpjvosqadai/qvkqenkrolj+iq6+ Yesmcwgfzeb87dgnwevfdjiga0qy27ptb2lexyjsrfn4cb13nfodabmtoxcawz7japcxaplhug++mhmrhqxetoznbfe4nbnc7vobngwdjugxcpkuckop4b17bfpr+k8ztylss8p2llz4uaeccsm2/msjxt7rc/fvoh8428ohincqs2ico9zo/ud4hmmo0o+ sszdvkiijingyovwb4oozkalnnhez3o6hahcreisbgpweyvtj/9zdc0ao44nj9cu7awaqgtrnwwfr/o4v2gl8blskltzu27/ 29heuoefgjlfe0yrdd/arnsxbyb2o28h4sg1cvzmc5uk1iqbdisya7q0bbdofcwoqzm5twlpkwny8oe0ub9xp5p/svfck4fcewfhwv+/ pc9rzsl33lq6vm2wikcigqtaqiadaucqp8khawdbqwacaakcrdywgojwirxzye+d/9uc7z6fisalfoyoln60ajabqbi/ urkbfugyz5roaitusn9z2ratn61wrfhu4ucsjtfn1ny2rerg40f56ptghkrd+yet+nze6+fkq5abgidfsr/2buk+zzrst83e14lcb6ii/ fjfzkoiox9ltkifqxqy7tvk4noku4olsc8o1wsfc/y0b9syuucmufcnq58demgie9ovuslmyt5npnvexxp5uearc5rqt9tk2b4a+7/ cqenrdzjbamsunt2+2fkyirunafpkpbdjbsy1sxel/a9ake0vikexqdawqdnzknci8rd/oop99/ 9lmbfudabx6nl2dsb1og2z7nweqgiazjmpwyypckevz5q8r+if9/fe5+sty/55oai33fj2h3v+ u435vjyqbrerwe36xjitcjequzw71fqtxi1ctel3w2ch7vf5oj/qyjablnalhgslksi6p7by5c2mnbchlcfpniinphforcrgpjje9nfwgs+ qblvs/chzc2wx3s/2swm4geukrx4zsaj5ocyfa/vkxcksxk/erwlcpf/j1t70+i5waxdn/e3enset/wl7h94pqkpjz8odgl4jsbhuavga+a+ Dknqnpf0kmklhjrgv+l7o84fhbmap7pxm3xmimprixf+el5fzzequqoiagf8rdrhhhrjxqgi0hnknkaoqs8dtrkcdqq+pqmdeaga7+gjfxbmdy4wslpnjh9rf4n2qfwsen/ lxazojyc3a6m02wcnhl6aht2/tbk2w1qi4yfter47gcvtgb6o1jhffoo2hflmrdrirjd1dtchqeyx7chhcghj/ dnrlw2z0l5qfecmv9u0vhp3affwc4ujfs3lu+hkawze7zad5ch9j7yv/6xuzvw411x0h4uqstcwmu0im1bzelqx1dy7lwopeb/ o9rkbf4fmle11eziaca4pqarxqzc4dhsinmt6k3x4brrsktfozbu74f47d8ilbf5vsyhbue5p/1oidznkg/p8kw+ 3fxuwrycciqftcnz215yyx39lxfnllzkub/f5gwadbqf+ lwqqa8cgrrfsoajxim63chfty5muc5rusntslgyeiocr1beqauypzbpdsdd9mz1zasafanfvwfg6llx9xku7tzq+ Vklowkm4u5xf3vn55vjnsd1aq9eqnucxil4cnbgotbowi39ecyzgslzbdc++ mpjcqtca7p6juvsp6oab3fqwg54tuuo0ec8bsm8b3ev42lmuqt5ndkhgwhsxtptl0klk4bqk4oajhsiy1bmahpt27jwjjlmijc+ iwj0mghkkht926s/ ymfdf5hkdq1cyvsz5tryvi3fx78xesyfqvuuwqp2h139pxgekg0n6kduoetdzwhe70ygnpw1yjwjt1ihubbgragambqjodz3tbqkt+ Wg4abihzudqrwabaqkqjhgno1by4fuumwcbbyr2+bben/l2bocnw9z/qfwuhrmaokvgcfm5fadq3afi+uqlacophrnj=443i-----END  Pgp public key block-----

3 Importing the MySQL public key

GPG--import MYSQL_PUBKEY.ASC

4 Verifying signatures

GPG--keyserver keys.gnupg.net--recv-keys 5072e1f5

5 Installing MySQL

In the event of a timeout, you can first Yum Makecache

Yum Install Mysql-community-server

6 starting the MySQL service

Service mysqld Start

7 Confirm Installation

can set MySQL root password and delete empty account, etc.

Mysql_secure_installation

Source Installation :

Install compilation dependencies

Yum install-y wget Ncurses-devel

1 Download MySQL source package in official

wget http://dev.mysql.com/get/Downloads/MySQL-5.6/mysql-5.6.34.tar.gz

2 Decompression

Tar zxf mysql-5.6.34.tar.gz

3 adding MySQL user groups and users

Groupadd mysqluseradd-g MySQL mysql-s/bin/false

4 Create a data directory and give permissions

Mkdir-p/data/mysqlchown Mysql:mysql/data/mysql

5 Configuring compilation Parameters

CD mysql-5.6.12cmake-dcmake_install_prefix=/usr/local/mysql-dmysql_unix_addr=/tmp/mysql.sock-ddefault_charset= Utf8-ddefault_collation=utf8_general_ci-dwith_extra_charsets:string=utf8,gbk-dwith_innobase_storage_engine=1- dwith_readline=1-denabled_local_infile=1-dmysql_datadir=/data/mysql/-dmysql_tcp_port=3306

6 compiling

Makemake Install

7 Setting up MySQL

Cd/usr/local/mysqlchown-r MySQL. chgrp-r mysql. #初始化数据库scripts/mysql_install_db--user=mysqlchown-r root. Chown-r Mys QL databin/mysqld_safe--user=mysql & #配置服务cp support-files/mysql.server/etc/init.d/mysqld

Additional parameters can be specified during initialization of the database configuration

scripts/mysql_install_db--user=mysql--basedir=/usr/local/mysql--datadir=/data/mysql

8 starting the MySQL service

Service MySQL Start

9 default initialization of the database after the root password is empty, can be configured via mysql_secure_installation MySQL security

Bin/mysql_secure_installation

10 Configuring the firewall to turn on port 3306

Iptables-i input-p TCP--dport 3306-j ACCEPT

Note: If you do not have dependencies installed, you may see an error similar to the following. At the end of the error, the dependencies of each system are given, the CMake cache should be cleared after installation, the CMakeCache.txt files can be deleted directly, and the compilation will be reconfigured.

--Could not find Curses (missing:curses_library curses_include_path)
CMake Error at cmake/readline.cmake:85 (MESSAGE):
Curses Library not found. Please install the appropriate package,

Remove CMakeCache.txt and rerun CMake. On Debian/ubuntu, package name was Libncurses5-dev, on Redhat and derivates it was ncurses-devel.

After initializing the database by default, you need to modify the MY.CNF configuration file related configuration to the actual value

This article is from the "Morrowind" blog, make sure to keep this source http://morrowind.blog.51cto.com/1181631/1874491

LNMP (nginx php-fpm mysql) environment deployment--mysql