Ò׽ؽØͼÈí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

ÔÚ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


Ïà¹ØÎĵµ£º

MySQLÊý¾Ý¿â±¸·ÝºÍ»¹Ô­µÄ³£ÓÃÃüÁת¡¿


MySQLÊý¾Ý¿â±¸·ÝºÍ»¹Ô­µÄ³£ÓÃÃüÁî
Ô­Îļûhttp://www.21andy.com/blog/20071102/655.html
ʱ¼ä£º2007-11-02 23:29:09   Àà±ð£º¼¼Êõ   ·ÃÎÊ£º3,731 views   RSS 2.0   ÆÀÂÛ  
±¸·ÝMySQLÊý¾Ý¿âµÄÃüÁî
mysqldump -hhostname -uusername -ppassword database ......

mysqlµ¼Èëµ¼³öÊý¾Ý¿â

¼¸¸ö³£ÓÃÓÃÀý£º
1.µ¼³öÕû¸öÊý¾Ý¿â mysqldump -u Óû§Ãû -p Êý¾Ý¿âÃû > µ¼³öµÄÎļþÃû     mysqldump -u wcnc -p smgp_apps_wcnc > wcnc.sql2.µ¼³öÒ»¸ö±í mysqldump -u Óû§Ãû -p Êý¾Ý¿âÃû ±íÃû> µ¼³öµÄÎļþÃû mysqldump -u wcnc -p smgp_apps_wcnc users> wcnc_users.sql3.µ¼³öÒ»¸öÊý¾Ý¿â½ ......

MySQL³£Óõĵ¼Èëµ¼³öÃüÁî

³£ÓõÄ:
µ¼³ö
mysqldump -hyour_host -uyour_username -pyour_password database_name > file.sql
µ¼Èë
mysql -hyour_host -uyour_username -pyour_password database_name < file.sql
»òÕßÏÈÓÃmysql¿Í»§¶ËµÇ½ºó£¬
>\. file.sql
Ò²¿ÉÒÔÍê³Éµ¼È빦ÄÜ
ÉÏÃæµÄÁ½¸öÃüÁî½áºÏÆðÀ´Ó㬿ÉÒÔÍê³É½«Ò»¸öÊý¾Ý¿âµÄ ......

MySQLÊý¾Ý¿ârootȨÏÞ¶ªÊ§½â¾ö·½°¸

MySQLÊý¾Ý¿ârootȨÏÞ¶ªÊ§½â¾ö·½°¸
Ò»Ì첻СÐÄ°ÑROOTµÄȨÏ޸ĵ½×îСÁË(Ö»ÄܵǼ,ʲô¶¼×ö²»ÁË),Õâ¿É¼±ËÀÎÒÁË.ÖØ×°µÄ»°Ì«Âé·³£¬¶øÇÒÀïÃæÓкܶàµÄÓû§£¬Ò»¸ö¸öÖØÐÂŪ²»ÖªµÀµ½Ê²Ã´Ê±ºò¡£
ºóÀ´ÎÒÏëÁËÒ»¸ö°ì·¨£¬ÏȰѵ±Ç°·þÎñÆ÷µÄMySQL·þÎñÍ£Ö¹£¬°ÑMySQL DATaĿ¼ÏµÄmysqlĿ¼¸ÄÃûΪmysql_OLD,µ½ÁíÒ»¸ö·þÎñÆ÷Ï°ÑmysqlĿ¼ÏµÄ/ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ