MySql数据库的安装配置及简单操作
RPM安装Mysql
mysql需要perlDBI和perlDBDMySQL的支持，因此先安装perlDBI及perlDBDMySQL
perlDBI安装
rootli
uxarpmivh
mediaServerperlDBI1521fc6i386rpm
war
i
gmediaServerperlDBI1521fc6i386rpmHeaderV3
DSAsig
atureNOKEYkeyID37017186
Prepari
g

100
1perlDBI

100
rootli
uxa
perlDBDMySQL安装
rootli
uxarpmivhmediaServerperlDBDMySQL300071fc6i386rpmwar
i
gmediaServerperlDBDMySQL300071fc6i386rpmHeaderV3DSAsig
atureNOKEYkeyID37017186Prepari
g100
1perlDBDMy100rootli
uxa
开始安装mysql
rootli
uxarpmivh
mediaServermysql502221i386rpm
war
i
gmediaServermysql502221i386rpmHeaderV3DSA
sig
atureNOKEYkeyID37017186
Prepari
g
100
1mysql

100
rootli
uxa
安装mysqlserver
1
frootli
uxarpmivhmediaServermysqlserver502221i386rpmwar
i
gmediaServermysqlserver502221i386rpmHeaderV3DSAsig
atureNOKEYkeyID37017186Prepari
g100
1mysqlserve100rootli
uxa
初始化MySql数据库
rootli
uxamysql_i
stall_dbI
stalli
gallpreparedtablesFillhelptables
Tostartmysqldatboottimeyouhavetocopysupportfilesmysqlservertotherightplaceforyoursystem
PLEASEREMEMBERTOSETAPASSWORDFORTHEMySQLrootUSERTodosostarttheserverthe
issuethefollowi
gcomma
dsusrbi
mysqladmi
urootpassword
ewpasswordusrbi
mysqladmi
uroothli
uxatestcompassword
ewpasswordSeethema
ualformorei
structio
s
Youca
starttheMySQLdaemo
withcdusrusrbi
mysqld_safe
Youca
testtheMySQLdaemo
withthebe
chmarksi
thesqlbe
chdirectorycdsqlbe
chperlru
alltests
Pleasereporta
yproblemswiththeusrbi
mysqlbugscript
Thelatesti
formatio
aboutMySQLisavailableo
thewebathttpwwwmysqlcomSupportMySQLbybuyi
gsupportlice
sesathttpshopmysqlcomrootli
uxa
修改mysql目录权限
安装好之后mysql目录权限如下
2
frootli
uxalslvarlibmysql总计8drwx2rootroot409608161655mysqldrwx2rootroot409608161655test
将mysql目录所有者及用户组修改为mysql
rootli
uxachow
Rmysqlvarlibmysqlrootli
uxachgrpRmysqlvarlibmysql
启动mysql服务
rootli
uxaservicemysqldstart启动MySQL：确定rootli
uxamysqlWelcometotheMySQLmo
itorComma
dse
dwithorgYourMr