须马上修改r
r
10r
vimetcrcdrclocalr
加入如下配置r
cdusrlocalmysqlusrlocalmysqlbi
mysqld_safeusermysqlr
每次开机可自动启动MySQLr
r
11servicemysqlstartr
r
12创建数据库，分配用户权限等等r
showvariableslikecollatio
_r
showvariableslikecharacter_set_r
查看字符编码r
r
导出数据库：进入mysql下面的bi
目录，r
mysqldumpushoapshoadefaultcharactersetgbkshoadmydbsqlr
r
创建数据库r
showcreatedatabaseshoar
CREATEDATABASEshoaCHARACTERSETutf8COLLATEutf8_ge
eral_cir
r
导入数据库root登录r
sourcedmydbsqlr
r
建shoa用户r
gra
tallprivilegeso
toshoaide
tifiedby