，并授予外部访问的权限//在root的状态下，运用下面语句，分为二种情况，一种是mysql初始化没有口令的时候，二是有口令的时候
1、mysql --user=root mysql
2、mysql --user=root mysql -p

//进行mysql的提示符后，输入以下二条命令，一是建立用户，二是刷新权限，立即生效；(连结的用户名为kuke,密码为kuke.info)
//建立二个用户，一个用于操作比如数据库连结及报表连结，一个用于以后远程统一管理。
GRANT ALL PRIVILEGES ON *.* TO 'root' IDENTIFIED BY 'kuke.info' WITH GRANT OPTION;
GRANT ALL PRIVILEGES ON *.* TO 'kuke' IDENTIFIED BY 'kuke.info' WITH GRANT OPTION;

GRANT ALL PRIVILEGES ON *.* TO 'ctnweb' IDENTIFIED BY 'ctn' WITH GRANT OPTION;
GRANT ALL PRIVILEGES ON *.* TO 'kuke' IDENTIFIED BY 'kuke.info' WITH GRANT OPTION;
GRANT ALL PRIVILEGES ON *.* TO 'ctnweb' IDENTIFIED BY 'ctn' WITH GRANT OPTION;
FLUSH PRIVILEGES;

GRANT ALL PRIVILEGES ON *. TO 'ctnweb' IDENTIFIED BY 'ctn' WITH GRANT OPTION;
FLUSH PRIVILEGES;

当root的密码忘记时，以安全方式登陆，进行变更密码
/usr/bin/safe_mysqld --skip-grant-tables

备份：

rq=` date +"%Y%m%d" `.zjym.mysql.tar
mysqldump --default-character-set=utf8 mysql > mysql$rq.SQL
mysqldump --default-character-set=utf8 pocs > pocs$rq.SQL

GRANT ALL PRIVILEGES ON *.* TO 'kuke' IDENTIFIED BY '*' WITH GRANT OPTION;
FLUSH PRIVILEGES;


GRANT ALL PRIVILEGES ON *.* TO 'root' IDENTIFIED BY '*' WITH GRANT OPTION;
FLUSH PRIVILEGES;

UPDATE user SET Password = password ( '*' ) WHERE User = 'root' ;
\
rpm -e MySQL-devel-community-5.0.45-0.rhel5
rpm -e MySQL-server-community-5.0.45-0.rhel5
rpm -e MySQL-shared-compat-5.0.45-0.rhel5
rpm -e MySQL-client-community-5.0.45-0.rhel5


FIND / -NAME MYSQL

find / -name mysql

我深深地理解了“人外有人，天外有天”这句话。百家乐我终于相信了！