linux下mysql安裝、目錄結(jié)構(gòu)、配置

1、linux下mysql安裝、目錄結(jié)構(gòu)、配置1、準(zhǔn)備安裝程序（官方網(wǎng)站下載）服務(wù)端：MySQL-server-community-5.i.44-i.rhel4.i386.rpm客戶端：MySQL-client-community-5.1.44-1.rhel4.i386.rpm2、安裝（打印信息略）rootlocalhost/#rpm-ivmMySQL-server-community-5.1.44-1.rhel4.i386.rpm;rootlocalhost/#rpm-ivmMySQL-client-community-5.1.44-1.rhel4.i386.rpm;3、查看安裝是否成功root

2、localhost/#netstat-ntpl;顯示3306端口開(kāi)放表示服務(wù)安裝成功4、測(cè)試連接rootlocalhost/#mysql出現(xiàn)mysql表示登陸成功5、對(duì)mysql用戶設(shè)置遠(yuǎn)程訪問(wèn)權(quán)限方法1、改表法：登陸mysql后，更改mysq數(shù)據(jù)庫(kù)里的user表里的host項(xiàng)，將loca山ost改“%”mysqlusemysql;mysqlupdateusersethost=%whereuser=root;mysqlselecthost,userfromuser;mysqlFLUSHPRIVILEGES方法2、授權(quán)法：假設(shè)允許用戶username通過(guò)密碼password從遠(yuǎn)程連接到mysql

3、服務(wù)器mysqlGRANTALLRRIVILEGESON*.*TOusername%IDENTIFIEDBYpasswordWITHGRANTOPTION;mysqlFLUSHPRIVILEGES;6、安裝目錄結(jié)構(gòu)數(shù)據(jù)庫(kù)目錄：/var/lib/mysql/配置文件：/usr/share/mysql（mysql.server命令及配置文件）相關(guān)命令：/usr/bin（mysqladmin、mysqldump等命令）（*mysql的一種安全啟動(dòng)方式:/usr/bin/mysqld_safe-user=root&）啟動(dòng)腳本：/etc/rc.d/init.d/7、數(shù)據(jù)庫(kù)目錄轉(zhuǎn)移（未實(shí)驗(yàn)過(guò)）在根目錄下新

4、建文件夾rootlocalhost/#mkdirmysqldata停止MYSQL服務(wù)器servicemysqlstop復(fù)制/var/lib/mysql下所有文件到/mysqldata查看原數(shù)據(jù)庫(kù)文件夾下各文件權(quán)限默認(rèn)為mysql更改/mysqldata下各文件權(quán)限r(nóng)ootlocalhost/#chgrp-Rmysql./mysqldata&chown-Rmysql./mysqldata檢查權(quán)限r(nóng)ootlocalhost/#ls-l配置f文件復(fù)制并更改文件到/etc目錄下rootlocalhostmysql#cp/usr/share/mysql/my-f/etc/f修改f#TheMySQLser

5、verclient#password=your_passwordport=3306#socket=/var/lib/mysql/mysql.socksocket=/mysqldata/mysql.sock-增加此行，并配置數(shù)據(jù)庫(kù)目錄mysqldport=3306#socket=/var/lib/mysql/mysql.socksocket=/mysqldata/mysql.sock-增加此行，并配置數(shù)據(jù)庫(kù)目錄修改啟動(dòng)文件修改/etc/rc.d/init.d/mysql找到datadir位置，修改內(nèi)容如下#Setsomedefaultspid_file=server_pid_file=use_m

6、ysqld_safe=1user=mysqliftest-z$basedirthenbasedir=/bindir=/usr/biniftest-z$datadirthen#datadir=/var/lib/mysql-修改前內(nèi)容datadir=/mysqldata-修改后內(nèi)容fisbindir=/usr/sbin8、停止/啟動(dòng)mysql服務(wù)rootlocalhost/#servicemysqlstop;rootlocalhost/#servicemysqlstart;9、修改字符編碼查看字符編碼:rootlocalhost/#showvariableslikecharacter_set_%;rootlocalhost/#showvariableslikecollation_%;停止mysql服務(wù)將目錄/u