centos6 安裝mysql (5.5/5.6/5.7版本可以在安裝源后安裝服務(wù)端前設(shè)置切換)

0.更換阿里的鏡像源
1.檢查本機(jī)是否已裝mysql組件,有的話刪掉(防止后續(xù)安裝組件引用沖突)

[root@linux ~]# yum list installed | grep mysql
mysql-libs.x86_64       5.1.73-8.el6_8 @anaconda-CentOS-201806291108.x86_64/6.10
[root@linux ~]# yum -y remove mysql-libs.x86_64

2.下載mysql源安裝包

wget http://repo.mysql.com/mysql57-community-release-el6-10.noarch.rpm

3.安裝yum源,選擇版本

yum -y localinstall mysql57-community-release-el6-10.noarch.rpm

源安裝后,根據(jù)需要,設(shè)置安裝的mysql版本,通過vim 編輯源文件,如果要安裝mysql哪個版本展姐,選擇后把里面的enable設(shè)置為1,其他設(shè)0.例如我的,就是5.6是1,其他版本是0

[root@linux ~]# vim /etc/yum.repos.d/mysql-community.repo
[mysql-connectors-community]
name=MySQL Connectors Community
baseurl=http://repo.mysql.com/yum/mysql-connectors-community/el/6/$basearch/
enabled=1
gpgcheck=1
gpgkey=file:/etc/pki/rpm-gpg/RPM-GPG-KEY-mysql

[mysql-tools-community]
name=MySQL Tools Community
baseurl=http://repo.mysql.com/yum/mysql-tools-community/el/6/$basearch/
enabled=1
gpgcheck=1
gpgkey=file:/etc/pki/rpm-gpg/RPM-GPG-KEY-mysql

# Enable to use MySQL 5.5
[mysql55-community]
name=MySQL 5.5 Community Server
baseurl=http://repo.mysql.com/yum/mysql-5.5-community/el/6/$basearch/
enabled=0
gpgcheck=1
gpgkey=file:/etc/pki/rpm-gpg/RPM-GPG-KEY-mysql

# 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=file:/etc/pki/rpm-gpg/RPM-GPG-KEY-mysql

# Note: MySQL 5.7 is currently in development. For use at your own risk.
# Please read with sub pages: https://dev.mysql.com/doc/relnotes/mysql/5.7/en/
[mysql57-community-dmr]
name=MySQL 5.7 Community Server Development Milestone Release
baseurl=http://repo.mysql.com/yum/mysql-5.7-community/el/6/$basearch/
enabled=0
gpgcheck=1
gpgkey=file:/etc/pki/rpm-gpg/RPM-GPG-KEY-mysql

也可以通過命令直接設(shè)置

yum-config-manager --disable mysql55-community
yum-config-manager --enable mysql56-community
yum-config-manager --disable mysql57-community

4.安裝mysql服務(wù)端(如果網(wǎng)絡(luò)不好,安裝途中沒下載完成,提示更換源,可以多此執(zhí)行以下安裝命令,他會在原下載的進(jìn)度上繼續(xù)下載,等下載完成就可以順利安裝完成了)

[root@linux ~]# yum install mysql-community-server

5.啟動 mysql 服務(wù)

[root@linux ~]# service mysqld start

6.查看服務(wù)啟動是否成功

[root@linux ~]# service mysqld status
mysqld (pid  3687) 正在運(yùn)行...

7.查看mysql是否開機(jī)自啟動(如不是,設(shè)置開啟,1-6代表不同的設(shè)備狀態(tài),詳情自己百度)

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

8.修改默認(rèn)字符集為UTF8(在[mysqld]部分添加:character-set-server=utf8)

[root@linux ~]# vim /etc/my.cnf

修改前:

# For advice on how to change settings please see
# http://dev.mysql.com/doc/refman/5.6/en/server-configuration-defaults.html

[mysqld]
#
# Remove leading # and set to the amount of RAM for the most important data
# cache in MySQL. Start at 70% of total RAM for dedicated server, else 10%.
# innodb_buffer_pool_size = 128M
#
# Remove leading # to turn on a very important data integrity option: logging
# changes to the binary log between backups.
# log_bin
#
# Remove leading # to set options mainly useful for reporting servers.
# The server defaults are faster for transactions and fast SELECTs.
# Adjust sizes as needed, experiment to find the optimal values.
# join_buffer_size = 128M
# sort_buffer_size = 2M
# read_rnd_buffer_size = 2M
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock

修改后:

# For advice on how to change settings please see
# http://dev.mysql.com/doc/refman/5.6/en/server-configuration-defaults.html

[mysqld]
character-set-server=utf8
#
# Remove leading # and set to the amount of RAM for the most important data
# cache in MySQL. Start at 70% of total RAM for dedicated server, else 10%.
# innodb_buffer_pool_size = 128M
#
# Remove leading # to turn on a very important data integrity option: logging
# changes to the binary log between backups.
# log_bin
#
# Remove leading # to set options mainly useful for reporting servers.
# The server defaults are faster for transactions and fast SELECTs.
# Adjust sizes as needed, experiment to find the optimal values.
# join_buffer_size = 128M
# sort_buffer_size = 2M
# read_rnd_buffer_size = 2M
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock

9.重啟服務(wù)

[root@linux ~]# service mysqld restart
停止 mysqld: [確定]
正在啟動 mysqld: [確定]

10.設(shè)置密碼,設(shè)置root賬戶遠(yuǎn)程登錄和修改配置:執(zhí)行:mysql_secure_installation
(如裝的是5.7,需要先去關(guān)閉密碼檢查,再查安裝好后生成的文件中查找初始密碼,修改密碼)
關(guān)閉密碼檢查:在[mysqld]后面增加validate_password=off

vim /etc/my.cnf

# For advice on how to change settings please see
# http://dev.mysql.com/doc/refman/5.7/en/server-configuration-defaults.html

[mysqld]
character-set-server=utf8
validate_password=off

再重啟mysql服務(wù)

service myslqd restart

5.7版本,查看初始密碼,跟在 root@localhost后的就是初始的密碼

[root@linux ~]# cat /var/log/mysqld.log | grep root@localhost

再登錄myslq,修改密碼

mysql -uroot -p
#輸入查詢到的初始密碼登錄
SET PASSWORD = PASSWORD('123456');

再退出mysql修改配置(修改同下方的5.6版本):

mysql> exit
mysql_secure_installation

5.6版本

[root@linux ~]# mysql_secure_installation



NOTE: RUNNING ALL PARTS OF THIS SCRIPT IS RECOMMENDED FOR ALL MySQL
      SERVERS IN PRODUCTION USE!  PLEASE READ EACH STEP CAREFULLY!

In order to log into MySQL to secure it, we'll need the current
password for the root user.  If you've just installed MySQL, and
you haven't set the root password yet, the password will be blank,
so you should just press enter here.

Enter current password for root (enter for none): 
OK, successfully used password, moving on...

Setting the root password ensures that nobody can log into the MySQL
root user without the proper authorisation.

Set root password? [Y/n] y
New password: 
Re-enter new password: 
Sorry, passwords do not match.

New password: 
Re-enter new password: 
Password updated successfully!
Reloading privilege tables..
 ... Success!


By default, a MySQL installation has an anonymous user, allowing anyone
to log into MySQL without having to have a user account created for
them.  This is intended only for testing, and to make the installation
go a bit smoother.  You should remove them before moving into a
production environment.

Remove anonymous users? [Y/n] y
 ... Success!

Normally, root should only be allowed to connect from 'localhost'.  This
ensures that someone cannot guess at the root password from the network.

Disallow root login remotely? [Y/n] n
 ... skipping.

By default, MySQL comes with a database named 'test' that anyone can
access.  This is also intended only for testing, and should be removed
before moving into a production environment.

Remove test database and access to it? [Y/n] y
 - Dropping test database...
ERROR 1008 (HY000) at line 1: Can't drop database 'test'; database doesn't exist
 ... Failed!  Not critical, keep moving...
 - Removing privileges on test database...
 ... Success!

Reloading the privilege tables will ensure that all changes made so far
will take effect immediately.

Reload privilege tables now? [Y/n] y
 ... Success!




All done!  If you've completed all of the above steps, your MySQL
installation should now be secure.

Thanks for using MySQL!

11.允許root用戶(密碼123456)遠(yuǎn)程接入:

mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'%'IDENTIFIED BY '123456' WITH GRANT OPTION;
Query OK, 0 rows affected (0.00 sec)
mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)

12.重啟mysql服務(wù)

[root@linux ~]# service mysqld restart
停止 mysqld: [確定]
正在啟動 mysqld: [確定]
最后編輯于
?著作權(quán)歸作者所有,轉(zhuǎn)載或內(nèi)容合作請聯(lián)系作者
  • 序言:七十年代末恃慧,一起剝皮案震驚了整個濱河市贬循,隨后出現(xiàn)的幾起案子肝劲,更是在濱河造成了極大的恐慌映九,老刑警劉巖,帶你破解...
    沈念sama閱讀 217,657評論 6 505
  • 序言:濱河連續(xù)發(fā)生了三起死亡事件码荔,死亡現(xiàn)場離奇詭異是偷,居然都是意外死亡,警方通過查閱死者的電腦和手機(jī)纬霞,發(fā)現(xiàn)死者居然都...
    沈念sama閱讀 92,889評論 3 394
  • 文/潘曉璐 我一進(jìn)店門凌埂,熙熙樓的掌柜王于貴愁眉苦臉地迎上來,“玉大人诗芜,你說我怎么就攤上這事瞳抓。” “怎么了伏恐?”我有些...
    開封第一講書人閱讀 164,057評論 0 354
  • 文/不壞的土叔 我叫張陵孩哑,是天一觀的道長。 經(jīng)常有香客問我脐湾,道長臭笆,這世上最難降的妖魔是什么? 我笑而不...
    開封第一講書人閱讀 58,509評論 1 293
  • 正文 為了忘掉前任秤掌,我火速辦了婚禮愁铺,結(jié)果婚禮上,老公的妹妹穿的比我還像新娘闻鉴。我一直安慰自己茵乱,他們只是感情好,可當(dāng)我...
    茶點(diǎn)故事閱讀 67,562評論 6 392
  • 文/花漫 我一把揭開白布孟岛。 她就那樣靜靜地躺著瓶竭,像睡著了一般督勺。 火紅的嫁衣襯著肌膚如雪。 梳的紋絲不亂的頭發(fā)上斤贰,一...
    開封第一講書人閱讀 51,443評論 1 302
  • 那天智哀,我揣著相機(jī)與錄音,去河邊找鬼荧恍。 笑死瓷叫,一個胖子當(dāng)著我的面吹牛,可吹牛的內(nèi)容都是我干的送巡。 我是一名探鬼主播摹菠,決...
    沈念sama閱讀 40,251評論 3 418
  • 文/蒼蘭香墨 我猛地睜開眼,長吁一口氣:“原來是場噩夢啊……” “哼骗爆!你這毒婦竟也來了次氨?” 一聲冷哼從身側(cè)響起,我...
    開封第一講書人閱讀 39,129評論 0 276
  • 序言:老撾萬榮一對情侶失蹤摘投,失蹤者是張志新(化名)和其女友劉穎煮寡,沒想到半個月后,有當(dāng)?shù)厝嗽跇淞掷锇l(fā)現(xiàn)了一具尸體谷朝,經(jīng)...
    沈念sama閱讀 45,561評論 1 314
  • 正文 獨(dú)居荒郊野嶺守林人離奇死亡洲押,尸身上長有42處帶血的膿包…… 初始之章·張勛 以下內(nèi)容為張勛視角 年9月15日...
    茶點(diǎn)故事閱讀 37,779評論 3 335
  • 正文 我和宋清朗相戀三年圆凰,在試婚紗的時候發(fā)現(xiàn)自己被綠了。 大學(xué)時的朋友給我發(fā)了我未婚夫和他白月光在一起吃飯的照片体箕。...
    茶點(diǎn)故事閱讀 39,902評論 1 348
  • 序言:一個原本活蹦亂跳的男人離奇死亡专钉,死狀恐怖,靈堂內(nèi)的尸體忽然破棺而出累铅,到底是詐尸還是另有隱情跃须,我是刑警寧澤,帶...
    沈念sama閱讀 35,621評論 5 345
  • 正文 年R本政府宣布娃兽,位于F島的核電站菇民,受9級特大地震影響,放射性物質(zhì)發(fā)生泄漏投储。R本人自食惡果不足惜第练,卻給世界環(huán)境...
    茶點(diǎn)故事閱讀 41,220評論 3 328
  • 文/蒙蒙 一、第九天 我趴在偏房一處隱蔽的房頂上張望玛荞。 院中可真熱鬧娇掏,春花似錦、人聲如沸勋眯。這莊子的主人今日做“春日...
    開封第一講書人閱讀 31,838評論 0 22
  • 文/蒼蘭香墨 我抬頭看了看天上的太陽。三九已至塞蹭,卻和暖如春孽江,著一層夾襖步出監(jiān)牢的瞬間,已是汗流浹背番电。 一陣腳步聲響...
    開封第一講書人閱讀 32,971評論 1 269
  • 我被黑心中介騙來泰國打工竟坛, 沒想到剛下飛機(jī)就差點(diǎn)兒被人妖公主榨干…… 1. 我叫王不留,地道東北人钧舌。 一個月前我還...
    沈念sama閱讀 48,025評論 2 370
  • 正文 我出身青樓担汤,卻偏偏與公主長得像,于是被迫代替她去往敵國和親洼冻。 傳聞我的和親對象是個殘疾皇子崭歧,可洞房花燭夜當(dāng)晚...
    茶點(diǎn)故事閱讀 44,843評論 2 354

推薦閱讀更多精彩內(nèi)容

  • mysqladmin -u root -p oldpass password newpass mysqladmin...
    不排版閱讀 2,165評論 0 3
  • 安裝并配置MySQL數(shù)據(jù)庫 3.2.1安裝MySQL數(shù)據(jù)庫 1.MySQL數(shù)據(jù)庫的安裝環(huán)境準(zhǔn)備 如果讀者沒有物理服...
    SkTj閱讀 4,043評論 0 6
  • 什么是數(shù)據(jù)庫? 數(shù)據(jù)庫是存儲數(shù)據(jù)的集合的單獨(dú)的應(yīng)用程序撞牢。每個數(shù)據(jù)庫具有一個或多個不同的API率碾,用于創(chuàng)建,訪問屋彪,管理...
    chen_000閱讀 4,035評論 0 19
  • 操作系統(tǒng)環(huán)境: CentOS 7.4最小化安裝 [root@node3 src]# cat /etc/redhat...
    溫東閱讀 2,082評論 0 0
  • 《晨間日記》讀后感 四組崔華 三個金句: 1所宰,成功的人都寫日記! 日記是自律畜挥、精進(jìn)仔粥、計(jì)劃、反思蟹但、總結(jié)躯泰、與自己心靈對...
    鎧睿閱讀 91評論 0 0