centos怎么安装mysql centos 安装的mysql在哪
linux centos\u600e\u4e48\u5b89\u88c5mysql\u5b89\u88c5Mysql
1
Centos 6.6\u4e0b\u5b89\u88c5Mysql\u5f88\u7b80\u5355\uff0c
yum list mysql-server
2
\u5f53\u53ea\u6709\u4e00\u4e2a\u65f6\u5019\u5c31\u53ef\u4ee5\u76f4\u63a5
yum install mysql-server
\u8fdb\u884c\u5b89\u88c5
3
\u8fc7\u7a0b\u4e2d\u9009\u62e9Y\u7ee7\u7eed\u5b89\u88c5\uff0c\u6700\u540e\u5b89\u88c5\u6210\u529f
END
\u8bbe\u7f6eMysql\u7684\u670d\u52a1
1
\u5148\u542f\u52a8Mysql\u670d\u52a1
service mysqld start
2
\u8fde\u63a5\u4e00\u4e0b\u8bd5\u4e00\u4e0b\uff0c\u76f4\u63a5
mysql
\u7136\u540e
\q
\u5173\u95ed\u8fde\u63a5
3
\u8bbe\u7f6eMysql\u5f00\u673a\u542f\u52a8
chkconfig mysqld on
4
\u5f00\u542f3306\u7aef\u53e3\u5e76\u4fdd\u5b58
/sbin/iptables -I INPUT -p tcp --dport 3306 -j ACCEPT
/etc/rc.d/init.d/iptables save
END
\u4fee\u6539\u5bc6\u7801\u5e76\u8bbe\u7f6e\u8fdc\u7a0b\u8bbf\u95ee
1
\u8fde\u63a5mysql\u6570\u636e\u5e93
\u8bbe\u7f6e\u5bc6\u7801
use mysql;
update user set password=password('\u5bc6\u7801') where user='root';
flush privileges;
2
\u8bbe\u7f6eMysql\u8fdc\u7a0b\u8bbf\u95ee
grant all privileges on *.* to 'root'@'%' identified by '123456' with grant option;
END
\u89e3\u51b3Mysql\u4e71\u7801\u95ee\u9898
1
\u627e\u4e00\u4e2a\u914d\u7f6e\u6587\u4ef6\uff0c\u590d\u5236\u5230/etc/\u76ee\u5f55\uff0c\u547d\u540d\u4e3amy.cnf
\uff08\u6709\u65f6\u5019\u6ca1\u6709my.cnf\uff09
cp /usr/share/doc/mysql-server-5.1.73/my-medium.cnf /etc/my.cnf
2
vim my.cnf
\u5728[client]\u548c[mysqld]\u4e0b\u9762\u90fd\u6dfb\u52a0\u4e0a
default-character-set=utf8
3
\u6700\u540e\u6309Esc\u8f93\u5165
:wq
\u4fdd\u5b58\u9000\u51fa
END
\u91cd\u542fmysql\u670d\u52a1
1
\u6700\u540e\u91cd\u65b0\u542f\u52a8\u670d\u52a1\u5c31\u53ef\u4ee5\u4e86
service mysqld restart
\u7cfb\u7edf\u5df2\u7ecf\u5b89\u88c5\u597dSQL Server2000\u5e76\u4e14\u6253\u4e0a\u4e86SP3\u8865\u4e01\uff1b\u5b89\u88c5\u597dOffice\u5957\u4ef6\u91cc\u9762\u7684Access\uff1b\u4f7f\u7528\u4e00\u4e2a\u652f\u6301\u7eaf\u6587\u672c\u7f16\u8f91\u5e76\u4e14\u5e26\u6709\u884c\u53f7\u663e\u793a\u7684\u7f16\u8f91\u5668\uff0c
\u4e8c\u3001\u51c6\u5907
1\u3001\u7a0b\u5e8f\u63d0\u4f9b\u4e86SQL\u6570\u636e\u5e93\u683c\u5f0f\uff1a\u6709\u4e00\u4e2aMDF\u6587\u4ef6\uff0c\u6216\u8005\u63d0\u4f9b\u4e86\u521b\u5efaSQL\u6570\u636e\u5e93\u7684SQL\u811a\u672c\u6587\u4ef6\uff08\u540e\u7f00\u540d\u4e3a.sql\uff09\u3002
2\u3001\u66f4\u591a\u7684\u662f\u6ca1\u6709\u63d0\u4f9bSQL\u6570\u636e\u5e93\u6216\u811a\u672c\u6587\u4ef6\u7684\uff0c\u8fd9\u65f6\uff0c\u5c31\u8981\u81ea\u5df1\u6765\u505a\u8fd9\u4e00\u5207\u4e86\uff0c\u8fd9\u4e5f\u662f\u6211\u4eec\u8fd9\u4e2a\u5e16\u5b50\u4e3b\u8981\u89e3\u51b3\u7684\u95ee\u9898\u3002
\u5bf9\u7167\u539f\u6765\u7684access\uff0c\u6539\u5199\u4e0b\u9762\u7684\u90e8\u5206\uff1a
\uff081\uff09sql\u6570\u636e\u5e93\u8868\u662f\u6ca1\u6709\u81ea\u52a8\u5b57\u6bb5\u7684\uff0c\u56e0\u6b64\u539f\u6765access\u4e2d\u7684\u81ea\u52a8\u5b57\u6bb5\u88ab\u8f6c\u6362\u6210\u4e86\u666e\u901a\u5b57\u6bb5\uff0c\u9700\u8981\u624b\u5de5\u6539\u6210\u6807\u8bc6\u7c7b\u578b\uff0c\u589e\u91cf\u4e3a1\u3002
\uff082\uff09\u6240\u6709\u7684\u65f6\u95f4\u5b57\u6bb5\uff0c\u5982\u679c\u5b9a\u4e49\u4e86\u9ed8\u8ba4\u503c\uff0c\u90a3\u4e48\u539f\u6765\u80af\u5b9a\u662fnow()\uff0c\u9700\u8981\u6539\u6210getdate()
\uff083\uff09\u539f\u6765\u5b57\u6bb5\u7684\u9ed8\u8ba4\u503c\u4e00\u822c\u90fd\u4e0d\u4f1a\u81ea\u52a8\u5f15\u5165\uff0c\u9700\u8981\u5bf9\u7167\u539f\u8868\u7684\u5b57\u6bb5\u624b\u5de5\u6dfb\u52a0\u3002
\uff084\uff09\u7531\u4e8e\u6570\u636e\u5e93\u7684\u4e0d\u540c\uff0caccess\u548csql\u7684\u5b57\u6bb5\u7c7b\u578b\u5f88\u591a\u8f6c\u6362\u540e\u5c31\u53d8\u5316\u4e86\uff0c\u6bd4\u5982\u539f\u6765\u7684\u300a\u662f\u5426\u300b\u5b57\u6bb5\u4f1a\u88ab\u8f6c\u6362\u6210bit\u6216\u8005int\uff0c\u5907\u6ce8\u5b57\u6bb5\u88ab\u8f6c\u6362\u6210longtext\uff0ctext\u5b57\u6bb5\u8f6c\u6362\u6210varchar\u7b49\u7b49\uff0c\u4e00\u822c\u6765\u8bf4\u4e0d\u4f1a\u5f71\u54cd\u7a0b\u5e8f\u8fd0\u884c\uff0c\u5982\u679c\u6709\u95ee\u9898\uff0c\u6211\u4eec\u5728\u4e0b\u9762\u7684\u7a0b\u5e8f\u6539\u5199\u90e8\u5206\u518d\u8bf4\u3002
\uff085\uff09\u5982\u679c\u4f60\u8981\u7528\u4e00\u4e2aFor SQL\u7684\u7a0b\u5e8f\uff0c\u91cc\u9762\u7528\u5230\u4e86\u5b58\u50a8\u8fc7\u7a0b\uff0c\u90a3\u4e48\u4f60\u5e94\u8be5\u6709\u8fd9\u4e2a\u7a0b\u5e8f\u672c\u8eab\u5efa\u7acbSQL\u6570\u636e\u5e93\u7684\u65b9\u6cd5\uff1a\u6709\u5176\u672c\u8eab\u7684SQL\u6570\u636e\u5e93\u6587\u4ef6\uff0c\u6216\u8005sql\u811a\u672c\uff1b\u5982\u679c\u6ca1\u6709\u7684\u8bdd\uff0c\u91c7\u7528\u5bfc\u5165access\u6570\u636e\u5e93\u7684\u65b9\u5f0f\u662f\u65e0\u6cd5\u5efa\u7acb\u5b58\u50a8\u8fc7\u7a0b\u7684\uff0c\u8fd9\u6837\u4f60\u6700\u597d\u653e\u5f03\u8fd9\u4e2aFor SQL\u7684\u7a0b\u5e8f\u7248\u672c\uff0c\u4f7f\u7528\u540c\u6837\u7248\u672c\u7684For Access\u7684\u7a0b\u5e8f\uff0c\u5bfc\u5165access\u6570\u636e\u5e93\uff0c\u7136\u540e\u7528\u4e0b\u9762\u7684\u6539\u5199\u65b9\u6cd5\u81ea\u5df1\u6539\u6210SQL\u7248\u672c\u7684\u7a0b\u5e8f\u3002
\u4e09\u3001\u8fde\u63a5\u5b57\u7b26\u4e32\u7684\u6539\u5199
\u53ef\u53c2\u8003\u52a8\u7f51\u7684\u8fd9\u6bb5\uff0c\u5206\u522b\u662f\u9488\u5bf9access\u548cSQL\u7684
Dim ConnStr
If IsSqlDataBase = 1 Then
'sql\u6570\u636e\u5e93\u8fde\u63a5\u53c2\u6570\uff1a\u6570\u636e\u5e93\u540d\u3001\u7528\u6237\u5bc6\u7801\u3001\u7528\u6237\u540d\u3001\u8fde\u63a5\u540d\uff08\u672c\u5730\u7528local\uff0c\u5916\u5730\u7528IP\uff09
Dim SqlDatabaseName,SqlPassword,SqlUsername,SqlLocalName
SqlDatabaseName = "dvbbs7"
SqlPassword = ""
SqlUsername = "dvbbs"
SqlLocalName = "(local)"
ConnStr = "Provider = Sqloledb; User ID = " & SqlUsername & "; Password = " & SqlPassword & "; Initial Catalog = " & SqlDatabaseName & "; Data Source = " & SqlLocalName & ";"
yum install mysql
2、安装mysql 服务器端：
yum install mysql-server
yum install mysql-devel
3、 启动mysql服务：
service mysqld start
4、设置开机启动
chkconfig mysqld on
5、查看是否设置成功
chkconfig --list mysqld
6、创建root管理员：
mysqladmin -u root password 123456
登录：
mysql -u root -p
输入密码就可以了
7、停止mysql服务
service mysqld stop
8、忘记密码重新设置密码
service mysqld stop 停止服务
mysqld_safe --user=root --skip-grant-tables 清空mysql密码
mysql -u root 登录mysql
use mysql 使用mysql库
update user set password=password("new_pass") where user="root"; 设置新密码（原来用户名在这个表里啊）
flush privileges; 刷新
9、开启远程访问
insert into user(Host,User) values("%","root");
绛旓細棣栧厛閫夋嫨姝ｇ‘鐨勪簯yum婧 MYSQL鐨剏um婧愬湪瀹樼綉 浠ヤ笅浠centos7鍜宑entos8涓轰緥 涓嬭浇婧 瀹夎婧愶紙杩欎釜婧愰噷闈㈡湁8.0鍜5.7,涓や釜鐗堟湰锛屼笅涓绡囦細浠嬬粛濡備綍澧炲姞鍏朵粬鐗堟湰锛夋煡鐪嬪綋鍓嶅彲瀹夎鐨mysql鐗堟湰 浠ヤ笂婧愰粯璁ゆ槸8.0鐗堟湰鐨 闇瑕8.0鍙互鐩存帴杩愯瀹夎锛堟洿鎹5.7鐣ヨ繃姝ゆ楠わ級鏌ョ湅搴撲腑鎵鏈夌増鏈 濡傛灉鎴戜滑瑕侀夋嫨鐗堟湰锛...
绛旓細鍚庣(鐙珛mysql)ip:192.168.10.5 杞欢鐗堟湰:libiconv-1.14.tar.gz mysql-5.1.63.tar.gz php-5.2.17.tar.gz php-5.2.17-fpm-0.5.14.diff.gz php-5.2.17-max-input-vars.patch 1.鍏堝湪鍚庣瀹夎mysql 鍦192.168.10.5涓婂彧瀹夎mysql.鏂规硶鍙互鍘荤湅centos缂栬瘧瀹夎nginx+php-fpm+mysql閲...
绛旓細閰嶇疆璇存槑Linux绯荤粺锛CentOS-7.0MySQL鐗堟湰锛5.7.21Linux绯荤粺涓嬪惎鍔ㄥ涓狹ySQL瀹炰緥锛岀洰鍓嶇煡閬撴湁涓ょ鏂规硶锛屼竴绉嶆槸閫氳繃瀹樻柟鎻愪緵鐨mysqld_multi.server鏉ュ疄鐜帮紝浣嗘槸鎴戠幇鍦ㄨ繕娌＄爺绌惰繖绉嶆柟娉曟槸鎬庝箞鍋氱殑锛涘彟涓绉嶅氨鏄氳繃瀹夎澶氫釜MySQL鏈嶅姟鍣ㄧ殑鍘熷鏂规硶瀹炵幇銆傛垜鐜板湪鏄氳繃绗簩绉嶆柟娉曞疄鐜扮殑銆傛垚鍔熷惎鍔2涓狹ySQL瀹炰緥銆傛帴...
绛旓細windows鐗堬紝瀹夎easypanel鍓嶏紝闇瑕佸厛瀹夎kangle web鏈嶅姟鍣ㄨ蒋浠躲俥asypanel鏄湪kangle web鏈嶅姟鍣ㄨ蒋浠跺熀纭涓婃灦璁俱佹槸瀵筴angle鍔熻兘鐨勮皟鐢ㄣ倃indows鐗堬紝easypanel娌℃湁闆嗘垚myql锛mysql闇瑕佺敤鎴锋彁鍓嶄笅杞藉畨瑁呫2銆佷笅杞藉畨瑁卥angle,瀹夎璺緞鏈濂戒笉瑕佹湁绌烘牸濡:D:\kangle锛岀櫥闄嗗湴鍧涓:http://IP:3311 榛樿鐨勮处鍙峰拰瀵嗙爜鏄...
绛旓細centos 7.2 瀹夎mysql 杩愯鍒帮細/etc/init.d/mysqld start 鍚姩MySQL鏁版嵁搴撴槸璁剧疆閿欒閫犳垚鐨勶紝瑙ｅ喅鏂规硶涓猴細1銆佸厛鍚姩Mysql鏈嶅姟锛宻ervice mysqld start銆2銆佸皾璇曡繛鎺ユ暟鎹簱銆傝緭鍏ysql锛岀劧鍚 \q 鍏抽棴杩炴帴銆3銆佸紑鍚3306绔彛骞朵繚瀛樸4銆佽繛鎺ysql鏁版嵁搴撱傝缃瘑鐮併5銆佽缃甅ysql杩滅▼璁块棶璐︽埛瀵嗙爜灏卞彲浠ヤ簡銆
绛旓細mv /etc/yum.repos.d/CentOS-Base.repo /etc/yum.repos.d/CentOS-Base.repo.save wget http://mirrors.163.com/.help/CentOS6-Base-163.repo mv CentOS6-Base-163.repo /etc/yum.repos.d/CentOS-Base.repo 2.鏇存柊绯荤粺鍐呮牳 yum -y update 3.瀹夎Apahce銆Mysql銆丳HP yum -y install httpd ...
绛旓細鍦ㄤ笂涓绡囨枃绔犱腑锛屾垜浠帰璁ㄤ簡濡備綍鍦CentOS鐜涓瀹夎瀹濆鎺у埗闈㈡澘骞跺垱寤烘暟鎹簱銆傜劧鑰岋紝褰撳皾璇曞湪Windows涓婁娇鐢∟avicat for MySQL杩滅▼杩炴帴鏃讹紝鍗撮亣鍒颁簡10038閿欒銆傛鍒伙紝鎴戞壘鍒颁簡涓涓湁鏁堢殑瑙ｅ喅鏂规锛岃鎴戜滑涓璧锋⒊鐞嗚繖涓棶棰樼殑瑙ｅ喅杩囩▼銆傛垜浠殑鏈嶅姟鍣ㄧ幆澧冩槸鍩轰簬CentOS 7.5.1804锛屼竴涓己澶ц岀ǔ瀹氱殑鎿嶄綔绯荤粺锛歀SB ...
绛旓細Centos灏辨槸redhat鐨勭ぞ鍖哄彂琛岀増锛屽唴鏍告槸涓鏍风殑锛岄夋嫨涓巖edhat瀵瑰簲鐗堟湰鍗冲彲銆傛瘮濡備綘鏄centos 6 閭ｅ氨閫夋嫨redhat 6
绛旓細鎿嶄綔濡備笅:[root@CentOSCentOS_6.4]#/usr/sbin/groupaddmysql[root@CentOSCentOS_6.4]#/usr/sbin/useradd-gmysqlmysql[[email protected]]#./configure--prefix=/usr/local/mys... 鎿嶄綔濡備笅:[root@CentOS CentOS_6.4]# /usr/sbin/groupadd mysql[root@CentOS CentOS_6.4]# /usr/sbin/useradd -g ...
绛旓細杈撳叆锛歽um-yremovemysql-libs.x86_64锛岃嫢鏈夊涓緷璧栨枃浠跺垯渚濇鍗歌浇銆傚綋缁撴灉鏄剧ず涓篊omplete锛佸嵆鍗歌浇瀹屾瘯銆傛煡鐪媦um搴撲笂鐨刴ysql鐗堟湰淇℃伅(CentOS绯荤粺闇瑕佹甯歌繛鎺ョ綉缁)銆傝緭鍏ワ細yumlistgrepmysql鎴杫um-ylistmysql*浣跨敤yum瀹夎mysql鏁版嵁搴撱傝緭鍏ワ細yum-yinstallmysql-servermysqlmysql-devel锛屽懡浠ゅ皢锛歮ysql-server銆...
