ÔÚ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Êý¾Ý¿â±¸·ÝºÍ»¹ÔµÄ³£ÓÃÃüÁî
ÔÎļû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 ......
¼¸¸ö³£ÓÃÓÃÀý£º
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.µ¼³öÒ»¸öÊý¾Ý¿â½ ......
³£ÓõÄ:
µ¼³ö
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ȨÏÞ¶ªÊ§½â¾ö·½°¸
Ò»Ì첻СÐÄ°ÑROOTµÄȨÏ޸ĵ½×îСÁË(Ö»ÄܵǼ,ʲô¶¼×ö²»ÁË),Õâ¿É¼±ËÀÎÒÁË.ÖØ×°µÄ»°Ì«Âé·³£¬¶øÇÒÀïÃæÓкܶàµÄÓû§£¬Ò»¸ö¸öÖØÐÂŪ²»ÖªµÀµ½Ê²Ã´Ê±ºò¡£
ºóÀ´ÎÒÏëÁËÒ»¸ö°ì·¨£¬ÏȰѵ±Ç°·þÎñÆ÷µÄMySQL·þÎñÍ£Ö¹£¬°ÑMySQL DATaĿ¼ÏµÄmysqlĿ¼¸ÄÃûΪmysql_OLD,µ½ÁíÒ»¸ö·þÎñÆ÷Ï°ÑmysqlĿ¼ÏµÄ/ ......