1 配置DNS
vi /var/named/yesgo.loc
# 追加如下一行,当然你可以自定义其他别名或主机名
mysql IN CNAME ns.yesgo.loc.
/etc/rc.d/init.d/named restart //重启DNS服务
nslookup //测试是否解析成功
2 建立FTP
##在安装MySQL的时候,我们已经建立了一个叫做mysql的帐号,如果你还没有建立,可以按照下面的语句建立:
useradd mysq -s /dev/null -g ftpchroot
passwd mysql
3 安装phpMyAdmin
tar xvzf /home/src/phpMy*
cp /home/src/phpMyAdmin/* /home/mysql
chown -R mysql /home/mysql
chown -R mysql /home/mysql/*
chmod 701 /home/mysql
chmod 701 /home/mysql/*
4 添加虚拟主机
vi /usr/local/apache/conf/httpd.conf
<VirtualHost mysql.yesgo.loc>
ServerAdmin
webmaster@yesgo.loc
DocumentRoot /home/mysql
ServerName mysql.yesgo.loc
ErrorLog logs/mysql.yesgo.loc-error_log
CustomLog logs/mysql.yesgo.loc-access_log common
</VirtualHost>
5 添加身份验证
##添加MySQL用户
##使用身份验证功能,phpMyAdmin需要一个启动用户,这个用户对mysql的相关表具有查询权限,具体定义如下:
shell>mysql -p
mysql>GRANT USAGE ON mysql.* TO '<stduser>'@'localhost' IDENTIFIED BY '<stdpass>';
mysql>GRANT SELECT (Host, User, Select_priv, Insert_priv, Update_priv, Delete_priv, Create_priv, Drop_priv, Reload_priv, Shutdown_priv, Process_priv, File_priv, Grant_priv, References_priv, Index_priv, Alter_priv) ON mysql.user TO '<stduser>'@'localhost';
mysql>GRANT SELECT ON mysql.db TO '<stduser>'@'localhost';
mysql>GRANT SELECT (Host, Db, User, Table_name, Table_priv, Column_priv) ON mysql.tables_priv TO '<stduser>'@'localhost';
##修改配置文件