ÔÚmysqlÊý¾Ý¿âÖÐÐÞ¸ÄrootµÄÃÜÂë

ÏÂÃæÎÒ¸ø´ó¼Ò½éÉܼ¸ÖÖÔÚmysqlÊý¾Ý¿âÖÐÐÞ¸ÄrootÃÜÂëµÄ·½·¨
·½·¨Ò»£º
ԭʼÃÜÂëÊÇ ckh
mysql -uroot -pckh
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 7 to server version: 5.0.22-community-nt
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> use mysql
Database changed
mysql> update user set password=password('newpass') where user='root';
Query OK, 1 row affected (0.00 sec)
Rows matched: 1  Changed: 1  Warnings: 0
mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)
mysql>
·½·¨¶þ£º
ԭʼÃÜÂëÊÇ newpass , ÐÂÃÜÂëÊÇ  mysql
mysqladmin -uroot -pnewpass password mysql
·½·¨Èý
ԭʼÃÜÂëÊÇ mysql , ÐÂÃÜÂëÊÇ  ckh
mysql -uroot -pmysql
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 19 to server version: 5.0.22-community-nt
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> set password for root@'localhost'=password('ckh');
Query OK, 0 rows affected (0.00 sec)
mysql>
ÏÂÃæÁгöһЩ³£ÓõÄmysqlÊý¾Ý¿â¹ÜÀíÃüÁ
°²×° ÀûÓÃRPM°ü°²×°Mysql ¡¡
ÉèÖÃTCP 3306¶Ë¿ÚµÄiptables ¡¡
¡¡
rootÃÜÂë¹ÜÀí ÉèÖÃrootÓû§µÄÃÜÂë mysqladmin -uroot password 'password'
                    ÐÞ¸ÄrootÓû§µÄÃÜÂë mysqladmin -uroot -p password 'password'
¡¡
Êý¾Ý¿â£¬±í¹ÜÀí ½øÈëmysql            mysql -h hostname -uroot -p
´´½¨Êý¾Ý¿â                                  mysql> create database location
µ¼ÈëÊý¾Ý½á¹¹                               mysql -uroot -p