Centos7安装mysql缺乏yum源怎么安装？ Centos7下使用yum安装mysql数据库的详细教程(增...
Centos7\u5b89\u88c5mysql\u7f3a\u4e4fyum\u6e90\u600e\u4e48\u5b89\u88c51. \u4e0b\u8f7dmysql\u7684repo\u6e90
?
1
$ wget http://repo.mysql.com/mysql-community-release-el7-5.noarch.rpm
2. \u5b89\u88c5mysql-community-release-el7-5.noarch.rpm\u5305
?
1
$ sudo rpm -ivh mysql-community-release-el7-5.noarch.rpm
\u5b89\u88c5\u8fd9\u4e2a\u5305\u540e\uff0c\u4f1a\u83b7\u5f97\u4e24\u4e2amysql\u7684yum repo\u6e90\uff1a/etc/yum.repos.d/mysql-community.repo\uff0c/etc/yum.repos.d/mysql-community-source.repo\u3002
3. \u5b89\u88c5mysql
?
1
$ sudo yum install mysql-server
\u6839\u636e\u6b65\u9aa4\u5b89\u88c5\u5c31\u53ef\u4ee5\u4e86\uff0c\u4e0d\u8fc7\u5b89\u88c5\u5b8c\u6210\u540e\uff0c\u6ca1\u6709\u5bc6\u7801\uff0c\u9700\u8981\u91cd\u7f6e\u5bc6\u7801\u3002
4. \u91cd\u7f6e\u5bc6\u7801
\u91cd\u7f6e\u5bc6\u7801\u524d\uff0c\u9996\u5148\u8981\u767b\u5f55
?
1
$ mysql -u root
\u767b\u5f55\u65f6\u6709\u53ef\u80fd\u62a5\u8fd9\u6837\u7684\u9519\uff1aERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)\uff0c\u539f\u56e0\u662f/var/lib/mysql\u7684\u8bbf\u95ee\u6743\u9650\u95ee\u9898\u3002\u4e0b\u9762\u7684\u547d\u4ee4\u628a/var/lib/mysql\u7684\u62e5\u6709\u8005\u6539\u4e3a\u5f53\u524d\u7528\u6237\uff1a
?
1
$ sudo chown -R openscanner:openscanner /var/lib/mysql
\u7136\u540e\uff0c\u91cd\u542f\u670d\u52a1\uff1a
?
1
$ service mysqld restart
\u63a5\u4e0b\u6765\u767b\u5f55\u91cd\u7f6e\u5bc6\u7801\uff1a
?
1
$ mysql -u root
?
1
2
3
mysql > use mysql;
mysql > update user set password=password('123456') where user='root';
mysql > exit;
5. \u5f00\u653e3306\u7aef\u53e3
?
1
$ sudo vim /etc/sysconfig/iptables
\u6dfb\u52a0\u4ee5\u4e0b\u5185\u5bb9\uff1a
?
1
-A INPUT -p tcp -m state --state NEW -m tcp --dport 3306 -j ACCEPT
\u4fdd\u5b58\u540e\u91cd\u542f\u9632\u706b\u5899\uff1a
?
1
$ sudo service iptables restart
6. \u521b\u5efa\u666e\u901a\u7528\u6237\u5e76\u6388\u6743
\u793a\u4f8b\uff08\u4f7f\u7528root\u7528\u6237\u767b\u5f55\uff0c\u5e76\u5047\u5b9a\u5df2\u7ecf\u521b\u5efa\u4e86openscannerstore\u6570\u636e\u5e93\uff09\uff1a
?
1
mysql > use mysql;
?
1
2
3
\uff03\u521b\u5efaopenscanner\u7528\u6237\u4e0e\u5bc6\u7801\u5e76\u8bbe\u7f6e\u4e3a\u4ece\u5b89\u88c5mysql\u670d\u52a1\u7684\u673a\u5668\u672c\u5730\u8bbf\u95ee
mysql > grant all on openscannerstore.* to 'openscanner'@'localhost'
identified by 'scanner888';
?
1
2
#\u8bbe\u7f6eopenscanner\u7528\u6237\u4e0e\u5bc6\u7801\uff0c\u5e76\u4ece\u4efb\u4f55\u673a\u5668\u90fd\u53ef\u4ee5\u8bbf\u95eemysql
mysql > grant all on openscannerstore.* to 'openscanner'@'%' identified by 'scanner888';
?
1
mysql > flush privileges; #\u5237\u65b0\u624d\u4f1a\u751f\u6548
\u73b0\u5728\u5c31\u53ef\u4ee5\u4ece\u5ba2\u6237\u673a\u8fde\u63a5mysql\u670d\u52a1\u5668\u4e86\uff0c\u5982\u679c\u8fde\u63a5\u62a5\u8fd9\u6837\u7684\u9519\uff1aERROR 2003 (HY000): Can't connect to MySQL server on '192.168.x.xxx' (113)\u3002\u56e0\u4e3a\u6211\u4eec\u662fcentos7\uff0c\u8bf7\u5148\u786e\u8ba4\u9632\u706b\u5899\u662f\u5426\u5f00\u542f\u6765\uff0ccentos7\u9ed8\u8ba4\u662ffirewall\uff0c\u6211\u4eec\u53ef\u4ee5\u628a\u5b83\u505c\u6b62\u5e76\u7981\u6b62\u4f7f\u7528\uff0c\u7136\u540e\u542f\u52a8\u6211\u4eec\u719f\u6089\u7684iptables\uff0c\u8fd9\u6837\u5c31\u597d\u4e86\uff01
\u5728\u4e4b\u524d\u7ed9\u5927\u5bb6\u5206\u4eab\u8fc7\u8fd9\u7bc7\u6587\u7ae0\uff1aCentOS
7.0\u4e0b\u4f7f\u7528yum\u5b89\u88c5mysql\u7684\u65b9\u6cd5\u8be6\u89e3\uff0c\u5c0f\u7f16\u89c9\u5f97\u4e0d\u591f\u8be6\u7ec6\uff0c\u4eca\u5929\u7ed9\u5927\u5bb6\u901a\u8fc7\u672c\u6587\u7ed9\u5927\u5bb6\u505a\u4e2a\u8865\u5145\uff0c\u611f\u5174\u8da3\u7684\u670b\u53cb\u53ef\u4ee5\u53c2\u8003\u4e0b\u3002
1.
\u4e0b\u8f7dmysql\u7684repo\u6e90
$
wget
http://repo.mysql.com/mysql-community-release-el7-5.noarch.rpm
2.
\u5b89\u88c5mysql-community-release-el7-5.noarch.rpm\u5305
$
sudo
rpm
-ivh
mysql-community-release-el7-5.noarch.rpm
\u5b89\u88c5\u8fd9\u4e2a\u5305\u540e\uff0c\u4f1a\u83b7\u5f97\u4e24\u4e2amysql\u7684yum
repo\u6e90\uff1a/etc/yum.repos.d/mysql-community.repo\uff0c/etc/yum.repos.d/mysql-community-source.repo\u3002
3.
\u5b89\u88c5mysql
$
sudo
yum
install
mysql-server
\u6839\u636e\u6b65\u9aa4\u5b89\u88c5\u5c31\u53ef\u4ee5\u4e86\uff0c\u4e0d\u8fc7\u5b89\u88c5\u5b8c\u6210\u540e\uff0c\u6ca1\u6709\u5bc6\u7801\uff0c\u9700\u8981\u91cd\u7f6e\u5bc6\u7801\u3002
4.
\u91cd\u7f6e\u5bc6\u7801
\u91cd\u7f6e\u5bc6\u7801\u524d\uff0c\u9996\u5148\u8981\u767b\u5f55
$
mysql
-u
root
\u767b\u5f55\u65f6\u6709\u53ef\u80fd\u62a5\u8fd9\u6837\u7684\u9519\uff1aERROR
2002
(HY000):
Can\u2018t
connect
to
local
MySQL
server
through
socket
\u2018/var/lib/mysql/mysql.sock\u2018
(2)\uff0c\u539f\u56e0\u662f/var/lib/mysql\u7684\u8bbf\u95ee\u6743\u9650\u95ee\u9898\u3002\u4e0b\u9762\u7684\u547d\u4ee4\u628a/var/lib/mysql\u7684\u62e5\u6709\u8005\u6539\u4e3a\u5f53\u524d\u7528\u6237\uff1a
$
sudo
chown
-R
openscanner:openscanner
/var/lib/mysql
\u7136\u540e\uff0c\u91cd\u542f\u670d\u52a1\uff1a
$
service
mysqld
restart
5.
\u9632\u706b\u5899\u8bbe\u7f6e\uff0c\u5f00\u653e3306\u7aef\u53e3
firewall-cmd
--permanent
--zone=public
--add-port=3306/tcp
firewall-cmd
--permanent
--zone=public
--add-port=3306/udp
firewall-cmd
--reload
6.
mysql\u5b89\u5168\u8bbe\u7f6e
mysql_secure_installation;
MySQL
\u4f1a\u63d0\u793a\u4f60\u91cd\u7f6e
root
\u5bc6\u7801\uff0c\u79fb\u9664\u5176\u4ed6\u7528\u6237\u8d26\u53f7\uff0c\u7981\u7528
root
\u8fdc\u7a0b\u767b\u5f55\uff0c\u79fb\u9664
test
\u6570\u636e\u5e93\uff0c\u91cd\u65b0\u52a0\u8f7d
privilege
\u8868\u683c\u7b49\u3002
7.
\u521b\u5efa\u8fdc\u7a0b\u8bbf\u95ee\u7528\u6237
--\u5b9e\u65bd\u73af\u5883\u7528\u6237
CREATE
USER
'dbuser'@'%'
IDENTIFIED
BY
'123456';
GRANT
SELECT,INSERT,UPDATE,DELETE
ON
*.*
TO
'dbuser'@'%';
--\u7ba1\u7406\u5458\u7528\u6237
CREATE
USER
'admin'@'%'
IDENTIFIED
BY
'123456';
CREATE
USER
'admin'@'%'
IDENTIFIED
BY
'123456';
GRANT
ALL
ON
*.*
TO
'admin'@'%';
flush
privileges;
8.
\u66f4\u6539\u6570\u636e\u5b58\u653e\u76ee\u5f55
mkdir
/home/data
--\u5173\u95edmysql\u670d\u52a1\u8fdb\u7a0b
systemctl
status
mysqld
mv
/var/lib/mysql
/home/data
\u4fee\u6539
/etc/my.cnf
\u6587\u4ef6
datadir=/home/data/mysql
socket=/home/data/mysql/mysql.sock
socket=/home/data/mysql/mysql.sock
\u4ee5\u4e0a\u6240\u8ff0\u662f\u5c0f\u7f16\u7ed9\u5927\u5bb6\u4ecb\u7ecd\u7684Centos7\u4e0b\u4f7f\u7528yum\u5b89\u88c5mysql\u6570\u636e\u5e93\u7684\u8be6\u7ec6\u6559\u7a0b\uff0c\u5e0c\u671b\u5bf9\u5927\u5bb6\u6709\u6240\u5e2e\u52a9\uff0c\u5982\u679c\u5927\u5bb6\u6709\u4efb\u4f55\u7591\u95ee\u8bf7\u7ed9\u6211\u7559\u8a00\uff0c\u5c0f\u7f16\u4f1a\u53ca\u65f6\u56de\u590d\u5927\u5bb6\u7684\u3002\u5728\u6b64\u4e5f\u975e\u5e38\u611f\u8c22\u5927\u5bb6\u5bf9\u811a\u672c\u4e4b\u5bb6\u7f51\u7ad9\u7684\u652f\u6301\uff01
我首先想到的是安装VMware Tools，安装成功后，配置好共享文件夹后，总是报这个错
无奈，只好另寻他法。
随后又想到了，做个iso镜像，然后挂载在CDrom上，然后安装JDK成功，但是mysql安装失败，可能由于只从官网上下载了server，而没有解决依赖关系。
最后，找到mysql5.6的centos的repo源，终于解决mysql的安装问题：
1.确保centos安装了wget，没有的话安装wgetyum install wget
2.下载mysql的repo源
1：wget http://repo.mysql.com/mysql-community-release-el7-5.noarch.rpm
2：安装mysql-community-release-el7-5.noarch.rpm包
3：rpm -ivh mysql-community-release-el7-5.noarch.rpm
4.安装这个包后，会获得两个mysql的yum repo源
[root@localhost
~]# ls -1 /etc/yum.repos.d/mysql-community*
/etc/yum.repos.d/mysql-community.repo
/etc/yum.repos.d/mysql-community-source.repo
[root@localhost
~]#
5.然后安装mysql
yum install mysql-server
根据步骤安装就可以了，不过安装完成后，没有密码，需要充值密码：
mysql_secure_installation
可以根据这个命令，重置密码。也可以登录mysql再重置
mysql -u root
根据mysql的命令行来更改：
mysql> use
mysql;
mysql> update
user set password=PASSWORD("GIVE-NEW-ROOT-PASSWORD")
where User='root';
mysql> flush
privileges;
mysql> quit
绛旓細1銆侀厤缃甕UM婧 鍦∕ySQL瀹樼綉涓笅杞結UM婧恟pm瀹夎鍖咃細妫鏌ysql婧愭槸鍚﹀畨瑁呮垚鍔 shell> yum repolist enabled | grep "mysql.*-community.*"2銆瀹夎MySQL shell> systemctl start mysqld 鏌ョ湅MySQL鐨勫惎鍔ㄧ姸鎬 4銆佸紑鏈哄惎鍔 shell> systemctl enable mysqld shell> systemctl daemon-reload ...
绛旓細涓嶅悓linux鐗堟湰锛屽畨瑁呬笉鍚岀増鏈殑mysql鏂规硶鍚勪笉鐩稿悓锛屼笅闈互CentOS 6.5缂栬瘧瀹夎MySQL 5.6.16浠嬬粛锛氫竴.鍑嗗宸ヤ綔 1.yum瀹夎鍚勪釜渚濊禆鍖 [root@WebServer ~]# yum -y install gcc gcc-devel gcc-c++ gcc-c++-devel autoconf* automake* zlib* libxml* ncurses-devel ncurses libgcrypt* libtool* c...
绛旓細centos7鎶 鐩存帴瀹夎mariadb yum -y install mariadb-server mariadb mariadb-devel systemctl start mariadb systemctl enable mariadb mysql_secure_installation firewall-cmd --permanent --add-service mysql systemctl restart firewalld.service iptables -L -n|grep 3306 ...
绛旓細rpm -qa|grep mysql 娌℃湁瀹夎灏辨寜鐓ф湰姝ラ杩涜涓嬭浇鍜屽畨瑁,鏈夊垯璺宠繃 涓嬭浇repo,鍛戒护:wget 鍦板潃璇峰弬鑰冨浘鐗 瀹夎repo,鍛戒护:sudo rpm -ivh mysql-community-release-el7-5.noarch.rpm 瀹夎鍚,鍦/etc/yum.repos.d/ 浼氭湁涓や釜 repo 鏂囦欢 mysql-community.repo,mysql-community-source.repo 瀹夎 mysql 鍛戒护...
绛旓細6銆佷俊浠讳箣鍚庡氨鍙互瀹夎浜嗐7銆佺瓑寰呮彃浠跺畨瑁呭畬鎴愩8銆佸湪淇濆瓨鐨勬枃浠堕噷锛屽弻鍑绘彃浠讹紝杩涘叆瀹夎杞欢椤甸潰銆9銆佽繘鍏ラ〉闈紝鐐瑰嚮Next銆10銆佸嬀閫夊悓鎰忚鍒欙紝鐐瑰嚮Next銆11銆佷竴鑸嚜宸变娇鐢ㄧ殑绫诲瀷锛岄兘鏄夋嫨Typical锛屾墍浠ョ偣鍑绘爣绀恒12銆佽繘鍏ラ〉闈紝鍐嶇偣鍑籌nstall銆13銆佺瓑寰瀹夎MySQL 5.7銆14銆佺偣鍑籉inish銆15銆佺偣鍑诲紑濮嬮〉闈...
绛旓細centos7瀹夎mysql8鏃堕渶瑕佷笅杞絣inux鐗堟湰锛岀劧鍚庡mysql閰嶇疆鏂囦欢杩涜淇敼锛屾鏃秏ysqld鏄竴涓彲鎵ц鏂囦欢銆傚惎鍔∕ySQLd浠庤屽惎鍔╩ysql銆
绛旓細鍥犱负MYSQL 瀹屽叏灞炰簬oracle锛岃繖涓拰oracle鏈韩鍒╃泭瀛樺湪鍐茬獊锛屽洜涓轰粬杩樻湁涓濂椾粯璐圭殑鏁版嵁搴撹蒋浠讹紝鎵浠ヤ粬鎷垮埌MYSQL鍚庨殢鏃舵湁鎶奙YSQL姣欐帀鐨勫嵄闄┿傛墍浠MYSQL鐨浣滆呬篃鎰忚瘑鍒拌繖涓簨鎯咃紝浠栧湪MYSQL鐨勫熀纭涓婇噸鏂板紑鍙戝畬鍏ㄥ吋瀹筂YSQL锛屽姛鑳借秴杩嘙YSQL鐨凪ariaDB銆侻ariaDB鐜伴樁娈垫潵璁插墠鏅細鍏夋槑寰楀銆
绛旓細棣栧厛閫夋嫨姝ｇ‘鐨勪簯yum婧 MYSQL鐨yum婧愬湪瀹樼綉 浠ヤ笅浠centos7鍜宑entos8涓轰緥 涓嬭浇婧 瀹夎婧愶紙杩欎釜婧愰噷闈㈡湁8.0鍜5.7,涓や釜鐗堟湰锛屼笅涓绡囦細浠嬬粛濡備綍澧炲姞鍏朵粬鐗堟湰锛夋煡鐪嬪綋鍓嶅彲瀹夎鐨mysql鐗堟湰 浠ヤ笂婧愰粯璁ゆ槸8.0鐗堟湰鐨 闇瑕8.0鍙互鐩存帴杩愯瀹夎锛堟洿鎹5.7鐣ヨ繃姝ゆ楠わ級鏌ョ湅搴撲腑鎵鏈夌増鏈 濡傛灉鎴戜滑瑕侀夋嫨鐗堟湰锛...
绛旓細瀹夎鍥捐В 瑙ｅ帇缂╁悗杩愯绋嬪簭寮濮嬪畨瑁咃紝閫夋嫨鎺ュ彈鍗忚锛岀偣鍑讳笅涓姝ャ傞夋嫨developer default锛岀偣鍑烩漬ext鈥溿傛鏌ユ槸鍚︽弧瓒冲畨瑁呴渶姹傘傜偣鍑烩淓xecute鈥濇寜閽悗锛屽彲鑳戒細涓嬭浇涓浜涚▼搴忥紝鍒版椂浣犺嚜宸辩偣鍑诲畨瑁呭氨琛屼簡锛岀洿鍒版墍鏈夊畨瑁呭畬鎴愬氨OK浜嗐傚綋鐒朵綘涔熷彲浠ラ夋嫨涓嶄笅杞借繖浜涚幆澧冪偣鍑烩漬ext鈥滅洿鎺ュ畨瑁呫傜偣鍑烩淓xecute鈥濇寜閽悗锛...
绛旓細杩欑鎯呭喌鍙戠敓浜巑ysql琚鐩瀹夎鎴栧崌绾у悗锛屽綋鐒秏ysql鏃犳晠瀹曟満鍚庝篃浼氭湁杩欑鎯呭喌锛屽彲鑳戒細褰卞搷mysql鍚姩鐨勬暟鎹枃浠讹紝涓鑸瓨鍦ㄤ簬mysql鐨鏁版嵁瀛樺偍鐩綍锛堣繖涓洰褰曚緷鎹甿y.cnf閰嶇疆鏂囦欢涓殑datadir鑰屽紓锛夛紝涔熷氨鏄瓨鍦ㄤ簬mysql鏁版嵁瀛樺偍鐩綍涓嬬殑mysql-bin.index鏂囦欢锛屽垹闄や箣鍗冲彲銆備簲銆乻elinux鐨勯棶棰橈紝centos涓嬫渶瀹规槗鍑虹幇 se...
