MySQLµÄ°²×°£¨Ãâ°²×°°æ±¾£©
Ò»¡¢ÏÂÔØMySQL
¹Ù·½ÍøÕ¾£ºwww.mysql.org
¶þ¡¢°²×°
1.½«´ËѹËõ°ü½âѹËõµ½Öƶ¨Îļþ¼ÐÏ£¬ÒÔ"C:/mysql"ΪÀý
2.½«my-midium.ini¸´ÖÆÒ»·Ý£¬²¢ÖØÃüÃûΪmy.ini
3.½«C:/mysql/bin/libmysql.dll¸´ÖƵ½ÏµÍ³Ä¿Â¼Ï£¬ÀýÈ縴ÖƵ½"C:/windows"ÏÂ
4.ÔÚÃüÁîÐÐģʽÏ£¬ÔËÐÐC:/mysql/bin/mysqld£¬¼´¿É¿ªÆôMySQL·þÎñÆ÷µÄÊØ»¤¹ý³Ì£¬Èç¹û¹Ø±Õ£¬¿É½øÈëC:/mysql/binÏ£¬ÊäÈ룺
mysql admin -u root -p shutdown(rootÓÐÃÜÂë)
mysql admin -u root shutdown(rootÎÞÃÜÂë)
ÐÞ¸ÄrootÃÜÂ룺
£¨Ò»£©Ã»ÃÜÂëʱ
1.¿ªÆôÊØ»¤½ø³Ì£¬¼´ÔËÐÐ"C:/mysql/bin/mysql"
2.ÔÚÃüÁîÐÐģʽÏ£¬½øÈë"C:/mysql/bin"Ŀ¼£¬ÊäÈ룺mysqladmin -u root password 'your password'
ÆäÖÐ'your password'ΪÄãÒªÉ趨µÄÃÜÂë
£¨¶þ£©ÓÐÃÜÂëʱ
1.ÔÚÃüÁîÐÐģʽÏ£¬½øÈë"C:/mysql/bin"Ŀ¼£¬ÊäÈ루¿ªÆôÊØ»¤½ø³Ì£©£ºmysqld --skip -grant -tables
2.ÊäÈ룺mysql ½øÈëmysqlÃüÁîÐУ¬Ìáʾ·ûΪ"mysql>"
3.ÊäÈ룺
use mysql
update user set password=''
where user='root' and host='local host';
exit
4.ÊäÈë mysqladmin -uroot password 'your password'£¬ÉèÖÃÄúµÄÃÜÂë
Ïà¹ØÎĵµ£º
1¡¢½âѹ mysql-noinstall-5.1.30-win32.zip
2¡¢ÔÚ F Å̽¨Á¢Ä¿Â¼ MySql\MySqlServer5.1\
3¡¢°Ñ½âѹµÄÄÚÈݸ´ÖƵ½ F:\MySql\MySqlServer5.1\
4¡¢ÔÚ F:\MySql\MySqlServer5.1\ ÖÐÕÒ my-large.ini °ÑËü¸´ÖÆ³É my.ini
5¡¢ÔÚ my.ini ÖÐÕÒ [mysqld] £¬Ìí¼ÓÒÔÏÂÓï¾ä;
basedir="F:/MySql/MySqlServer5.1/"
datadir="F:/My ......
Ò»¡¢mysql·þÎñ²Ù×÷
1¡¢net start mysql //Æô¶¯mysql·þÎñ
2¡¢net stop mysql //Í£Ö¹mysql·þÎñ¡¡
3¡¢mysql -hÖ÷»úµØÖ· -uÓû§Ãû £pÓû§ÃÜÂë //½øÈëmysqlÊý¾Ý¿â
4¡¢quit //Í˳ömysql²Ù×÷
5¡¢mysqladmin -uÓû§Ãû -p¾ÉÃÜÂë password ÐÂÃÜÂë //¸ü¸ÄÃÜÂë
6¡¢grant select on Êý¾Ý¿â.* to Óû§Ãû@µÇ¼Ö÷»ú identifie ......
À´Ô´£ºccidnet.com ×÷ÕߣºSabine¡¡ ʱ¼ä£º2006-10-09
ÔÚÊý¾Ý¿â±í¶ªÊ§»òË𻵵ÄÇé¿öÏ£¬±¸·ÝÄãµÄÊý¾Ý¿âÊǺÜÖØÒªµÄ¡£Èç¹û·¢Éúϵͳ±ÀÀ££¬Äã¿Ï¶¨ÏëÄܹ»½«ÄãµÄ±í¾¡¿ÉÄܶªÊ§×îÉÙµÄÊý¾Ý»Ö¸´µ½±ÀÀ£·¢ÉúʱµÄ״̬¡£ÓÐʱ£¬ÕýÊÇMySQL¹ÜÀíÔ±Ôì³ÉÆÆ»µ¡£¹ÜÀíÔ±ÒѾ֪µÀ±íÒÑÆÆ»µ£¬ÓÃÖîÈçvi»òEmacsµÈ±à¼Æ÷ÊÔͼֱ½Ó±à¼ËüÃÇ£¬Õâ¶Ô±í¾ø¶Ô²»ÊǼ ......
......
Êý¾Ý¿âĿ¼ÊÇMySQLÊý¾Ý¿â·þÎñÆ÷´æ·ÅÊý¾ÝÎļþµÄµØ·½£¬²»½ö°üÀ¨ÓйرíµÄÎļþ£¬»¹°üÀ¨Êý¾ÝÎļþºÍMySQLµÄ·þÎñÆ÷Ñ¡ÏîÎļþ¡£²»Í¬µÄ·Ö·¢£¬Êý¾Ý¿âĿ¼µÄȱʡλÖÃÊDz»Í¬µÄ¡£
Êý¾ÝĿ¼µÄλÖÃ
ȱʡµÄÊý¾Ý¿âλÖÃ
ȱʡÊý¾Ý¿âµÄλÖñàÒëÔÚ·þÎñÆ÷ÖС£
¡ôÈç¹ûÄúÊÇÔÚÒ»¸öÔ´³ÌÐò·Ö·¢°üÖа²×° MySQL£¬µäÐ͵ÄȱʡλÖÿÉÄÜÊÇ /usr/local/var ......