centos 6.5 yum安裝 mysql 5.6

最近切換到很久不用的centos還略有不適應(yīng)，默認(rèn)yum只能安裝mysql 5.1，需要升級(jí)又不想編譯。于是有了此文。

? 具體文檔地址：

1.?http://dev.mysql.com/doc/mysql-repo-excerpt/5.6/en/linux-installation-yum-repo.html?

2.??http://dev.mysql.com/doc/mysql-yum-repo-quick-guide/en/

下面是我取其中的部分，完成安裝mysql 5.6 的過(guò)程

?1. 查看系統(tǒng)里面有沒(méi)有mysql 的repo

#?yum?repolist?all?|?grep?mysql
#

?2. 如果沒(méi)有發(fā)現(xiàn)，則需要配置repo

? ?注意，如果要使用5.7 或者其他任何版本，只能有一個(gè)是?enabled=1的，其他的都得enabled=0。

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

3. 再看看是否存在mysql的repo

#?yum?repolist?enabled?|?grep?mysql
mysql56-community?????MySQL?5.6?Community?Server?????????????????????????????214

? ?ok，說(shuō)明已經(jīng)有了，下面就可以安裝mysql5.6了

4. 注意，

? ?可能想當(dāng)然的以為是

#?yum?install?mysql56
//你只會(huì)得到
No?package?mysql56?available

? 實(shí)際上官方的安裝命令是?

?#?yum?install?mysql-community-server
?//但是，失敗了呢
?mysql-community-server-5.6.28-2.el6.x86_64.rpm?????|??53?MB?????00:10?????
?
warning:?rpmts_HdrFromFdno:?Header?V3?DSA/SHA1?Signature,?key?ID?5072e1f5:?NOKEY
Retrieving?key?from?file:///etc/pki/rpm-gpg/RPM-GPG-KEY-mysql
獲取?GPG?密鑰失?。篬Errno?14]?Could?not?open/read?file:///etc/pki/rpm-gpg/RPM-GPG-KEY-mysql

5.失敗乃成功的媽媽

? ? 從錯(cuò)誤提示看：需要驗(yàn)證 GnuPG 簽名，還好可以手動(dòng)，毛主席說(shuō)，自己動(dòng)手豐衣足食嘛。

? ? 當(dāng)然，還有一招，我們暫且不用：

http://repo.mysql.com/yum/mysql-5.6-community/el/6/x86_64/mysql-community-server-5.6.28-2.el6.x86_64.rpm

? ?我們接下來(lái)按照錯(cuò)誤處理過(guò)出來(lái)搞，把簽名先搞起來(lái)，參考地址：?http://dev.mysql.com/doc/refman/5.6/en/checking-gpg-signature.html?

? ??

#?vim?/etc/pki/rpm-gpg/RPM-GPG-KEY-mysql?
寫(xiě)入如下內(nèi)容

-----BEGIN?PGP?PUBLIC?KEY?BLOCK-----
Version:?GnuPG?v1.4.9?(SunOS)

mQGiBD4+owwRBAC14GIfUfCyEDSIePvEW3SAFUdJBtoQHH/nJKZyQT7h9bPlUWC3
RODjQReyCITRrdwyrKUGku2FmeVGwn2u2WmDMNABLnpprWPkBdCk96+OmSLN9brZ
fw2vOUgCmYv2hW0hyDHuvYlQA/BThQoADgj8AW6/0Lo7V1W9/8VuHP0gQwCgvzV3
BqOxRznNCRCRxAuAuVztHRcEAJooQK1+iSiunZMYD1WufeXfshc57S/+yeJkegNW
hxwR9pRWVArNYJdDRT+rf2RUe3vpquKNQU/hnEIUHJRQqYHo8gTxvxXNQc7fJYLV
K2HtkrPbP72vwsEKMYhhr0eKCbtLGfls9krjJ6sBgACyP/Vb7hiPwxh6rDZ7ITnE
kYpXBACmWpP8NJTkamEnPCia2ZoOHODANwpUkP43I7jsDmgtobZX9qnrAXw+uNDI
QJEXM6FSbi0LLtZciNlYsafwAPEOMDKpMqAK6IyisNtPvaLd8lH0bPAnWqcyefep
rv0sxxqUEMcM3o7wwgfN83POkDasDbs3pjwPhxvhz6//62zQJ7Q2TXlTUUwgUmVs
ZWFzZSBFbmdpbmVlcmluZyA8bXlzcWwtYnVpbGRAb3NzLm9yYWNsZS5jb20+iGkE
ExECACkCGyMGCwkIBwMCBBUCCAMEFgIDAQIeAQIXgAIZAQUCUwHUZgUJGmbLywAK
CRCMcY07UHLh9V+DAKCjS1gGwgVI/eut+5L+l2v3ybl+ZgCcD7ZoA341HtoroV3U
6xRD09fUgeq0O015U1FMIFBhY2thZ2Ugc2lnbmluZyBrZXkgKHd3dy5teXNxbC5j
b20pIDxidWlsZEBteXNxbC5jb20+iG8EMBECAC8FAk53Pa0oHSBidWlsZEBteXNx
bC5jb20gd2lsbCBzdG9wIHdvcmtpbmcgc29vbgAKCRCMcY07UHLh9bU9AJ9xDK0o
xJFL9vTl9OSZC4lX0K9AzwCcCrS9cnJyz79eaRjL0s2r/CcljdyIZQQTEQIAHQUC
R6yUtAUJDTBYqAULBwoDBAMVAwIDFgIBAheAABIJEIxxjTtQcuH1B2VHUEcAAQGu
kgCffz4GUEjzXkOi71VcwgCxASTgbe0An34LPr1j9fCbrXWXO14msIADfb5piEwE
ExECAAwFAj4+o9EFgwlmALsACgkQSVDhKrJykfIk4QCfWbEeKN+3TRspe+5xKj+k
QJSammIAnjUz0xFWPlVx0f8o38qNG1bq0cU9iEwEExECAAwFAj5CggMFgwliIokA
CgkQtvXNTca6JD+WkQCgiGmnoGjMojynp5ppvMXkyUkfnykAoK79E6h8rwkSDZou
iz7nMRisH8uyiEYEEBECAAYFAj+s468ACgkQr8UjSHiDdA/2lgCg21IhIMMABTYd
p/IBiUsP/JQLiEoAnRzMywEtujQz/E9ono7H1DkebDa4iEYEEBECAAYFAj+0Q3cA
CgkQhZavqzBzTmbGwwCdFqD1frViC7WRt8GKoOS7hzNN32kAnirlbwpnT7a6NOsQ
83nk11a2dePhiEYEEBECAAYFAkNbs+oACgkQi9gubzC5S1x/dACdELKoXQKkwJN0
gZztsM7kjsIgyFMAnRRMbHQ7V39XC90OIpaPjk3a01tgiEYEExECAAYFAkTxMyYA
CgkQ9knE9GCTUwwKcQCgibak/SwhxWH1ijRhgYCo5GtM4vcAnAhtzL57wcw1Kg1X
m7nVGetUqJ7fiEwEEBECAAwFAkGBywEFgwYi2YsACgkQGFnQH2d7oexCjQCcD8sJ
NDc/mS8m8OGDUOx9VMWcnGkAnj1YWOD+Qhxo3mI/Ul9oEAhNkjcfiEwEEBECAAwF
AkGByzQFgwYi2VgACgkQgcL36+ITtpIiIwCdFVNVUB8xe8mFXoPm4d9Z54PTjpMA
niSPA/ZsfJ3oOMLKar4F0QPPrdrGiEwEEBECAAwFAkGBy2IFgwYi2SoACgkQa3Ds
2V3D9HMJqgCbBYzr5GPXOXgP88jKzmdbjweqXeEAnRss4G2G/3qD7uhTL1SPT1SH
jWUXiEwEEBECAAwFAkHQkyQFgwXUEWgACgkQfSXKCsEpp8JiVQCghvWvkPqowsw8
w7WSseTcw1tflvkAni+vLHl/DqIly0LkZYn5jzK1dpvfiEwEEBECAAwFAkIrW7oF
gwV5SNIACgkQ5hukiRXruavzEwCgkzL5QkLSypcw9LGHcFSx1ya0VL4An35nXkum
g6cCJ1NP8r2I4NcZWIrqiEwEEhECAAwFAkAqWToFgwd6S1IACgkQPKEfNJT6+GEm
XACcD+A53A5OGM7w750W11ukq4iZ9ckAnRMvndAqn3YTOxxlLPj2UPZiSgSqiEwE
EhECAAwFAkA9+roFgwdmqdIACgkQ8tdcY+OcZZyy3wCgtDcwlaq20w0cNuXFLLNe
EUaFFTwAni6RHN80moSVAdDTRkzZacJU3M5QiEwEEhECAAwFAkEOCoQFgwaWmggA
CgkQOcor9D1qil/83QCeITZ9wIo7XAMjC6y4ZWUL4m+edZsAoMOhRIRi42fmrNFu
vNZbnMGej81viEwEEhECAAwFAkKApTQFgwUj/1gACgkQBA3AhXyDn6jjJACcD1A4
UtXk84J13JQyoH9+dy24714Aniwlsso/9ndICJOkqs2j5dlHFq6oiEwEExECAAwF
Aj5NTYQFgwlXVwgACgkQLbt2v63UyTMFDACglT5G5NVKf5Mj65bFSlPzb92zk2QA
n1uc2h19/IwwrsbIyK/9POJ+JMP7iEwEExECAAwFAkHXgHYFgwXNJBYACgkQZu/b
yM2C/T4/vACfXe67xiSHB80wkmFZ2krb+oz/gBAAnjR2ucpbaonkQQgnC3GnBqmC
vNaJiEwEExECAAwFAkIYgQ4FgwWMI34ACgkQdsEDHKIxbqGg7gCfQi2HcrHn+yLF
uNlH1oSOh48ZM0oAn3hKV0uIRJphonHaUYiUP1ttWgdBiGUEExECAB0FCwcKAwQD
FQMCAxYCAQIXgAUCS3AvygUJEPPzpwASB2VHUEcAAQEJEIxxjTtQcuH1sNsAniYp
YBGqy/HhMnw3WE8kXahOOR5KAJ4xUmWPGYP4l3hKxyNK9OAUbpDVYIh7BDARAgA7
BQJCdzX1NB0AT29wcy4uLiBzaG91bGQgaGF2ZSBiZWVuIGxvY2FsISBJJ20gKnNv
KiBzdHVwaWQuLi4ACgkQOcor9D1qil/vRwCdFo08f66oKLiuEAqzlf9iDlPozEEA
n2EgvCYLCCHjfGosrkrU3WK5NFVgiI8EMBECAE8FAkVvAL9IHQBTaG91bGQgaGF2
ZSBiZWVuIGEgbG9jYWwgc2lnbmF0dXJlLCBvciBzb21ldGhpbmcgLSBXVEYgd2Fz
IEkgdGhpbmtpbmc/AAoJEDnKK/Q9aopfoPsAn3BVqKOalJeF0xPSvLR90PsRlnmG
AJ44oisY7Tl3NJbPgZal8W32fbqgbIkCIgQQAQIADAUCQYHLhQWDBiLZBwAKCRCq
4+bOZqFEaKgvEACCErnaHGyUYa0wETjj6DLEXsqeOiXad4i9aBQxnD35GUgcFofC
/nCY4XcnCMMEnmdQ9ofUuU3OBJ6BNJIbEusAabgLooebP/3KEaiCIiyhHYU5jarp
ZAh+Zopgs3Oc11mQ1tIaS69iJxrGTLodkAsAJAeEUwTPq9fHFFzC1eGBysoyFWg4
bIjz/zClI+qyTbFA5g6tRoiXTo8ko7QhY2AA5UGEg+83Hdb6akC04Z2QRErxKAqr
phHzj8XpjVOsQAdAi/qVKQeNKROlJ+iq6+YesmcWGfzeb87dGNweVFDJIGA0qY27
pTb2lExYjsRFN4Cb13NfodAbMTOxcAWZ7jAPCxAPlHUG++mHMrhQXEToZnBFE4nb
nC7vOBNgWdjUgXcpkUCkop4b17BFpR+k8ZtYLSS8p2LLz4uAeCcSm2/msJxT7rC/
FvoH8428oHincqs2ICo9zO/Ud4HmmO0O+SsZdVKIIjinGyOVWb4OOzkAlnnhEZ3o
6hAHcREIsBgPwEYVTj/9ZdC0AO44Nj9cU7awaqgtrnwwfr/o4V2gl8bLSkltZU27
/29HeuOeFGjlFe0YrDd/aRNsxbyb2O28H4sG1CVZmC5uK1iQBDiSyA7Q0bbdofCW
oQzm5twlpKWnY8Oe0ub9XP5p/sVfck4FceWFHwv+/PC9RzSl33lQ6vM2wIkCIgQT
AQIADAUCQp8KHAWDBQWacAAKCRDYwgoJWiRXzyE+D/9uc7z6fIsalfOYoLN60ajA
bQbI/uRKBFugyZ5RoaItusn9Z2rAtn61WrFhu4uCSJtFN1ny2RERg40f56pTghKr
D+YEt+Nze6+FKQ5AbGIdFsR/2bUk+ZZRSt83e14Lcb6ii/fJfzkoIox9ltkifQxq
Y7Tvk4noKu4oLSc8O1Wsfc/y0B9sYUUCmUfcnq58DEmGie9ovUslmyt5NPnveXxp
5UeaRc5Rqt9tK2B4A+7/cqENrdZJbAMSunt2+2fkYiRunAFPKPBdJBsY1sxeL/A9
aKe0viKEXQdAWqdNZKNCi8rd/oOP99/9lMbFudAbX6nL2DSb1OG2Z7NWEqgIAzjm
pwYYPCKeVz5Q8R+if9/fe5+STY/55OaI33fJ2H3v+U435VjYqbrerWe36xJItcJe
qUzW71fQtXi1CTEl3w2ch7VF5oj/QyjabLnAlHgSlkSi6p7By5C2MnbCHlCfPnIi
nPhFoRcRGPjJe9nFwGs+QblvS/Chzc2WX3s/2SWm4gEUKRX4zsAJ5ocyfa/vkxCk
SxK/erWlCPf/J1T70+i5waXDN/E3enSet/WL7h94pQKpjz8OdGL4JSBHuAVGA+a+
dknqnPF0KMKLhjrgV+L7O84FhbmAP7PXm3xmiMPriXf+el5fZZequQoIagf8rdRH
HhRJxQgI0HNknkaOqs8dtrkCDQQ+PqMdEAgA7+GJfxbMdY4wslPnjH9rF4N2qfWs
EN/lxaZoJYc3a6M02WCnHl6ahT2/tBK2w1QI4YFteR47gCvtgb6O1JHffOo2HfLm
RDRiRjd1DTCHqeyX7CHhcghj/dNRlW2Z0l5QFEcmV9U0Vhp3aFfWC4Ujfs3LU+hk
AWzE7zaD5cH9J7yv/6xuZVw411x0h4UqsTcWMu0iM1BzELqX1DY7LwoPEb/O9Rkb
f4fmLe11EzIaCa4PqARXQZc4dhSinMt6K3X4BrRsKTfozBu74F47D8Ilbf5vSYHb
uE5p/1oIDznkg/p8kW+3FxuWrycciqFTcNz215yyX39LXFnlLzKUb/F5GwADBQf+
Lwqqa8CGrRfsOAJxim63CHfty5mUc5rUSnTslGYEIOCR1BeQauyPZbPDsDD9MZ1Z
aSafanFvwFG6Llx9xkU7tzq+vKLoWkm4u5xf3vn55VjnSd1aQ9eQnUcXiL4cnBGo
TbOWI39EcyzgslzBdC++MPjcQTcA7p6JUVsP6oAB3FQWg54tuUo0Ec8bsM8b3Ev4
2LmuQT5NdKHGwHsXTPtl0klk4bQk4OajHsiy1BMahpT27jWjJlMiJc+IWJ0mghkK
Ht926s/ymfdf5HkdQ1cyvsz5tryVI3Fx78XeSYfQvuuwqp2H139pXGEkg0n6KdUO
etdZWhe70YGNPw1yjWJT1IhUBBgRAgAMBQJOdz3tBQkT+wG4ABIHZUdQRwABAQkQ
jHGNO1By4fUUmwCbBYr2+bBEn/L2BOcnw9Z/QFWuhRMAoKVgCFm5fadQ3Afi+UQl
AcOphrnJ
=443I
-----END?PGP?PUBLIC?KEY?BLOCK-----

rpm --import /etc/pki/rpm-gpg/RPM*? ?

好的，似乎ok了。我們?cè)賮?lái)一次吧，嘿嘿

??

#?yum?install?mysql-community-server

? ? 經(jīng)過(guò)一系列Y/N的選擇，進(jìn)度條漂亮的到達(dá)了終點(diǎn)。

? ?至此，MySQL 5.6 成功的從yum安裝了呢 :-)

? ?啟動(dòng)服務(wù)，開(kāi)啟新的旅程吧。

四、mysql數(shù)據(jù)庫(kù)的初始化及相關(guān)配置

我們?cè)诎惭b完mysql數(shù)據(jù)庫(kù)以后，會(huì)發(fā)現(xiàn)會(huì)多出一個(gè)mysqld的服務(wù)，這個(gè)就是咱們的數(shù)據(jù)庫(kù)服務(wù)，我們通過(guò)輸入?service mysqld start?命令就可以啟動(dòng)我們的mysql服務(wù)。

注意：如果我們是第一次啟動(dòng)mysql服務(wù)，mysql服務(wù)器首先會(huì)進(jìn)行初始化的配置，如：

[root@xiaoluo?~]#?service?mysqld?start

初始化?MySQL?數(shù)據(jù)庫(kù)：?WARNING:?The?host?'xiaoluo'?could?not?be?looked?up?with?resolveip.
This?probably?means?that?your?libc?libraries?are?not?100?%?compatible
with?this?binary?MySQL?version.?The?MySQL?daemon,?mysqld,?should?work
normally?with?the?exception?that?host?name?resolving?will?not?work.
This?means?that?you?should?use?IP?addresses?instead?of?hostnames
when?specifying?MySQL?privileges?!
Installing?MySQL?system?tables...
OK
Filling?help?tables...
OK

To?start?mysqld?at?boot?time?you?have?to?copy
support-files/mysql.server?to?the?right?place?for?your?system

PLEASE?REMEMBER?TO?SET?A?PASSWORD?FOR?THE?MySQL?root?USER?!
To?do?so,?start?the?server,?then?issue?the?following?commands:

/usr/bin/mysqladmin?-u?root?password?'new-password'
/usr/bin/mysqladmin?-u?root?-h?xiaoluo?password?'new-password'

Alternatively?you?can?run:
/usr/bin/mysql_secure_installation

which?will?also?give?you?the?option?of?removing?the?test
databases?and?anonymous?user?created?by?default.??This?is
strongly?recommended?for?production?servers.

See?the?manual?for?more?instructions.

You?can?start?the?MySQL?daemon?with:
cd?/usr?;?/usr/bin/mysqld_safe?&

You?can?test?the?MySQL?daemon?with?mysql-test-run.pl
cd?/usr/mysql-test?;?perl?mysql-test-run.pl

Please?report?any?problems?with?the?/usr/bin/mysqlbug?script!

???????????????????????????????????????????????????????????[確定]
正在啟動(dòng)?mysqld：????????????????????????????????????????????[確定]

?

這時(shí)我們會(huì)看到第一次啟動(dòng)mysql服務(wù)器以后會(huì)提示非常多的信息，目的就是對(duì)mysql數(shù)據(jù)庫(kù)進(jìn)行初始化操作，當(dāng)我們?cè)俅沃匦聠?dòng)mysql服務(wù)時(shí)，就不會(huì)提示這么多信息了，如：

?

[root@xiaoluo?~]#?service?mysqld?restart
停止?mysqld：?????????????????????????????????????????????[確定]
正在啟動(dòng)?mysqld：??????????????????????????????????????????[確定]

?

我們?cè)谑褂胢ysql數(shù)據(jù)庫(kù)時(shí)，都得首先啟動(dòng)mysqld服務(wù)，我們可以 通過(guò)??chkconfig --list | grep mysqld?命令來(lái)查看mysql服務(wù)是不是開(kāi)機(jī)自動(dòng)啟動(dòng)，如：

?

[root@xiaoluo?~]#?chkconfig?--list?|?grep?mysqld
mysqld?????????????0:關(guān)閉????1:關(guān)閉????2:關(guān)閉????3:關(guān)閉????4:關(guān)閉????5:關(guān)閉????6:關(guān)閉

?

我們發(fā)現(xiàn)mysqld服務(wù)并沒(méi)有開(kāi)機(jī)自動(dòng)啟動(dòng)，我們當(dāng)然可以通過(guò)?chkconfig mysqld on?命令來(lái)將其設(shè)置成開(kāi)機(jī)啟動(dòng)，這樣就不用每次都去手動(dòng)啟動(dòng)了

?

[root@xiaoluo?~]#?chkconfig?mysqld?on
[root@xiaoluo?~]#?chkconfig?--list?|?grep?mysql
mysqld?????????????0:關(guān)閉????1:關(guān)閉????2:啟用????3:啟用????4:啟用????5:啟用????6:關(guān)閉

?

mysql數(shù)據(jù)庫(kù)安裝完以后只會(huì)有一個(gè)root管理員賬號(hào)，但是此時(shí)的root賬號(hào)還并沒(méi)有為其設(shè)置密碼，在第一次啟動(dòng)mysql服務(wù)時(shí)，會(huì)進(jìn)行數(shù)據(jù)庫(kù)的一些初始化工作，在輸出的一大串信息中，我們看到有這樣一行信息 ：

?

/usr/bin/mysqladmin?-u?root?password?'new-password'　　//?為root賬號(hào)設(shè)置密碼

?

所以我們可以通過(guò) 該命令來(lái)給我們的root賬號(hào)設(shè)置密碼(注意：這個(gè)root賬號(hào)是mysql的root賬號(hào)，非Linux的root賬號(hào))

?

[root@xiaoluo?~]#?mysqladmin?-u?root?password?'root'　　//?通過(guò)該命令給root賬號(hào)設(shè)置密碼為?root

?

此時(shí)我們就可以通過(guò)?mysql -u root -p?命令來(lái)登錄我們的mysql數(shù)據(jù)庫(kù)了

?

五、mysql數(shù)據(jù)庫(kù)的主要配置文件

1./etc/my.cnf?這是mysql的主配置文件

我們可以查看一下這個(gè)文件的一些信息

[root@xiaoluo?etc]#?ls?my.cnf?
my.cnf
[root@xiaoluo?etc]#?cat?my.cnf?
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
user=mysql
#?Disabling?symbolic-links?is?recommended?to?prevent?assorted?security?risks
symbolic-links=0

[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid

2./var/lib/mysql?? mysql數(shù)據(jù)庫(kù)的數(shù)據(jù)庫(kù)文件存放位置

我們的mysql數(shù)據(jù)庫(kù)的數(shù)據(jù)庫(kù)文件通常是存放在了/ver/lib/mysql這個(gè)目錄下

?

[root@xiaoluo?~]#?cd?/var/lib/mysql/
[root@xiaoluo?mysql]#?ls?-l
總用量?20488
-rw-rw----.?1?mysql?mysql?10485760?4月???6?22:01?ibdata1
-rw-rw----.?1?mysql?mysql??5242880?4月???6?22:01?ib_logfile0
-rw-rw----.?1?mysql?mysql??5242880?4月???6?21:59?ib_logfile1
drwx------.?2?mysql?mysql?????4096?4月???6?21:59?mysql　　//?這兩個(gè)是mysql數(shù)據(jù)庫(kù)安裝時(shí)默認(rèn)的兩個(gè)數(shù)據(jù)庫(kù)文件
srwxrwxrwx.?1?mysql?mysql????????0?4月???6?22:01?mysql.sock
drwx------.?2?mysql?mysql?????4096?4月???6?21:59?test　　//?這兩個(gè)是mysql數(shù)據(jù)庫(kù)安裝時(shí)默認(rèn)的兩個(gè)數(shù)據(jù)庫(kù)文件

?

我們可以自己創(chuàng)建一個(gè)數(shù)據(jù)庫(kù)，來(lái)驗(yàn)證一下該數(shù)據(jù)庫(kù)文件的存放位置

?

創(chuàng)建一個(gè)我們自己的數(shù)據(jù)庫(kù)：
mysql>?create?database?xiaoluo;
Query?OK,?1?row?affected?(0.00?sec)

[root@xiaoluo?mysql]#?ls?-l
總用量?20492
-rw-rw----.?1?mysql?mysql?10485760?4月???6?22:01?ibdata1
-rw-rw----.?1?mysql?mysql??5242880?4月???6?22:01?ib_logfile0
-rw-rw----.?1?mysql?mysql??5242880?4月???6?21:59?ib_logfile1
drwx------.?2?mysql?mysql?????4096?4月???6?21:59?mysql
srwxrwxrwx.?1?mysql?mysql????????0?4月???6?22:01?mysql.sock
drwx------.?2?mysql?mysql?????4096?4月???6?21:59?test
drwx------.?2?mysql?mysql?????4096?4月???6?22:15?xiaoluo　　//?這個(gè)就是我們剛自己創(chuàng)建的xiaoluo數(shù)據(jù)庫(kù)
[root@xiaoluo?mysql]#?cd?xiaoluo/
[root@xiaoluo?xiaoluo]#?ls
db.opt

3./var/log?mysql數(shù)據(jù)庫(kù)的日志輸出存放位置

我們的mysql數(shù)據(jù)庫(kù)的一些日志輸出存放位置都是在/var/log這個(gè)目錄下

[root@xiaoluo?xiaoluo]#?cd?
[root@xiaoluo?~]#?cd?/var/log
[root@xiaoluo?log]#?ls
amanda????????????????cron???????????maillog-20130331???spice-vdagent.log
anaconda.ifcfg.log????cron-20130331??mcelog?????????????spooler
anaconda.log??????????cups???????????messages???????????spooler-20130331
anaconda.program.log??dirsrv?????????messages-20130331??sssd
anaconda.storage.log??dmesg??????????mysqld.log?????????tallylog
anaconda.syslog???????dmesg.old??????ntpstats???????????tomcat6
anaconda.xlog?????????dracut.log?????piranha????????????wpa_supplicant.log
anaconda.yum.log??????gdm????????????pm-powersave.log???wtmp
audit?????????????????httpd??????????ppp????????????????Xorg.0.log
boot.log??????????????ibacm.log??????prelink????????????Xorg.0.log.old
btmp??????????????????lastlog????????sa?????????????????Xorg.1.log
btmp-20130401?????????libvirt????????samba??????????????Xorg.2.log
cluster???????????????luci???????????secure?????????????Xorg.9.log
ConsoleKit????????????maillog????????secure-20130331????yum.log

?

其中mysqld.log 這個(gè)文件就是我們存放我們跟mysql數(shù)據(jù)庫(kù)進(jìn)行操作而產(chǎn)生的一些日志信息，通過(guò)查看該日志文件，我們可以從中獲得很多信息

?

因?yàn)槲覀兊膍ysql數(shù)據(jù)庫(kù)是可以通過(guò)網(wǎng)絡(luò)訪(fǎng)問(wèn)的，并不是一個(gè)單機(jī)版數(shù)據(jù)庫(kù)，其中使用的協(xié)議是 tcp/ip 協(xié)議，我們都知道m(xù)ysql數(shù)據(jù)庫(kù)綁定的端口號(hào)是 3306 ，所以我們可以通過(guò)?netstat -anp?命令來(lái)查看一下，Linux系統(tǒng)是否在監(jiān)聽(tīng) 3306 這個(gè)端口號(hào)：

結(jié)果如上所示，Linux系統(tǒng)監(jiān)聽(tīng)的3306端口號(hào)就是我們的mysql數(shù)據(jù)庫(kù)?。。。?/p>