mysqlÖØ×°ÎÊÌâ½â¾ö·½°¸
mysqlfrontÁ¬½Óʱ³öÏÖ“³ÌÐò×¢²áʱ¼äµ½ÆÚÁË£¬³ÌÐò½«±»ÏÞÖÆÔڵģʽÏÂÔËÐДÕâ¸öÎÊÌâʱ£¬²»ÓÃÖØ×°£¬Ö»ÐèÔÚMysql Front µÄ°ïÖú²Ëµ¥ÏîµÄµÇ¼ÇÀïÊäÈëÒÔÏÂMysql FrontµÄ×¢²áÂë¼´¿É¡£
MysqlFront×¢²áÂëÈçÏ£º
0hjwKUddagvS41S9TIb8EwuiXwo4+dlr
t8z9sq/YRlP9e0zTx7jVlriD8bWlwoJM
TRlllybJ0+wce5rRZGaMBnWJH5H0/Pwv
mUPx27SCgyNM1zkDOo5Mj8qnpR9195QN
yv4Fsr4lVYLx5qWHxqpILfqw7PgE3piH
fXEnZ5GprnXuKAanAsmx6omli+kXkHBq
/fT5B62tSXIZQ3euMYCzclaYW47MpKhR
3BUTBoHFzhiGXM5R0ApItyPkgDKnaOlV
ocvgFY3JOeHAP1KF6/mufA==
ÎÒ°Ñ£º
D:\Program Files\MySQL
ɾ³ýÁË¡£×¢²á±íÀïËùÓеÄMySQLÏÇå³ýÁË¡£ÖØÆôºó£¬»¹ÊÇûÓа취½â¾ö¡£MySQLÊǸöÁ÷Ã¥Èí¼þ£¬ËüÔÚϵͳµÄÆäËüµØ·½Ð´Á˺ܶàÊý¾Ý¡£¹âÔÚProgram FilesºÍ×¢²á±íÀïÊÇûÓа취³¹µ×ɾ³ýÁË¡£
ºóÀ´£¬ÎÒ×Ô¼º½â¾öÁË¡£ÉèÖÃÏòµ¼Ç°£¬ÏÈÔÚÏòµ¼Àïɾ³ýʵÀý¡£ÈçÏÂͼ¡£
£¨ÏÈÔÚ¿ØÖÆÃæ°åÀïɾ³ýMySQL³ÌÐò£¬ÔÙɾ³ýProgram FilesµÄMySQLÎļþ¼Ð¡££©
Ïà¹ØÎĵµ£º
http://www.3d308.cn/article.asp?id=37
shell> mysql -u root mysql
mysql> Update user SET Password=PASSWORD('new_password')
Where user='root';
mysql> FLUSH PRIVILEGES;
......
ÐÞ¸Ä /etc/mysql/my.cnf Îļþ£¬
ÔÚ £Ûclient£Ý ϼÓÈë default-character-set=utf8,
ÔÚ [mysqld] ϼÓÈë default-character-set=utf8,
ÔòÔÚviÀï¿ÉÒÔÕýÈ·µÄÏÔʾÖÐÎÄÁË£¨Ç°ÌáÊÇviҲʹÓÃutf8£©¡£
²»¹ýÔÚ²éѯµÄʱºò£¬½á¹ûÀïµÄÖÐÎÄÈ´»áÏÔʾ³É "?"£¬Õâ¸öÎÊÌâ±È½Ï¼òµ¥µÄ·½·¨Óм¸ÖÖ£¬·Ö±ðÊÇ£º
1.ÔÚ´´½¨Ê ......
MySql°æ±¾£ºmysql-noinstall-5.1.43-win32
ϵͳ£ºVista
ÔÚC:\myProgram Files\mysql-5.1.43-win32£¨½âѹµÄĿ¼£©Ï½«Ñ¡Ò»¸öÅäÖÃÎļþ£¨my-small.ini£©±à¼£º
1.ÔÚ[client]ÏÂÌí¼Ó£º
default-character-set=utf8 ......
£¨1£©Æô¶¯
MySQL°²×°Íê³ÉºóÆô¶¯ÎļþmysqlÔÚ/etc/init.dĿ¼Ï£¬ÔÚÐèÒªÆô¶¯MySQL·þÎñʱÔËÐÐÏÂÃæÃüÁî¼´¿É¡£ [root@test1 init.d]# /etc/init.d/mysql start
£¨2£©Í£Ö¹
/usr/bin/mysqladmin -u root -p shutdown
£¨3£©ÉèÖÃMySQL×Ô¶¯Æô¶¯
1£©²ì¿´mysqlÊÇ·ñÔÚ×Ô¶ ......
ÎÊÌ⣺һ¿ªÊ¼ÎÒÓÃNavicat Lite for mysql ½«Êý¾Ý¿âת´æ´¢Î»sqlÎļþ¡£´ò¿ªÖ®ºó·¢ÏÖ£¬ÖÐÎĶ¼±ä³ÉÁËÂÒÂë¡£
ËùÒÔ ÔÚÍøÉÏËÑË÷ÁËЩ×ÊÁÏ¿´¿´¡£·¢¾õ´ó¼Ò¶¼ÊÇÓÃÃüÁîµ¼³öµÄ¡£ÓÃÁËÖ®ºó£¬ÖÐÎľͲ»ÂÒÂëÁË¡£½â¾öÁËÎÒµÄÒ»¸öÄÑÌâ¡£Ìش˼ÇÏ¡£
·½·¨:
Ê×ÏÈÈ·ÈÏ mysql·þÎñÊÇ¿ªÆôµÄ¡£
È»ºóµã“¿ªÊ¼”ÔËÐÐÊäÈëcmd£¬½øÈëDOS»·¾³¡£cd ......