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Îļþ¼Ð¡££©
Ïà¹ØÎĵµ£º
MysqlÖеÄÊÂÎñ¿ÉÒÔÔËÐÐÔÚÏÂÃæ4¸öisolation levelÖУ¬Ó°Ïì×Åselect²Ù×÷µÄ½á¹û£º
1. Read Uncommitted
ÊÂÎñ¿ÉÒÔ¶Áµ½ÆäËûÊÂÎñûÓÐÌá½»µÄÄÚÈÝ
2. Read Committed
ÊÂÎñ¿ÉÒÔ¶Áµ½ÆäËûÊÂÎñÒѾÌá½»µÄÄÚÈÝ
3. Repeatable Read
InnoDBµÄĬÈÏlevel£¬¿ÉÒÔÈ·±££¬ÔÚÊÂÎñÖÐÿ´ÎÖ´ÐеĶÁ²Ù×÷·µ»ØµÄ½á¹û¶¼ÓëµÚÒ»´ÎʱµÄÒ»ÖÂ
4. Seriali ......
£¨1£©¸ñʽ£ºgrant select on Êý¾Ý¿â.* to Óû§Ãû@µÇ¼Ö÷»ú identified by "ÃÜÂë"
£¨2£©Àý1¡¢Ôö¼ÓÒ»¸öÓû§user_1ÃÜÂëΪ123£¬ÈÃËû¿ÉÒÔÔÚÈκÎÖ÷»úÉϵǼ£¬²¢¶ÔËùÓÐÊý¾Ý¿âÓвéѯ¡¢²åÈë¡¢Ð޸ġ¢É¾³ýµÄȨÏÞ¡£Ê×ÏÈÓÃÒÔrootÓû§Á¬ÈëMySQL£¬È»ºó¼üÈëÒÔÏÂÃüÁ
mysql> grant select,insert,update,delete on *.* to use ......
ÔËÐгÌÐò¿ÉÄܻᱨ´í£ºCan’t connect to local MySQL Server through socket ‘/tmp/mysql.sock’
Õâ¸ö´íÎóµÄÌáʾÊÇ˵£¬²»ÄÜͨ¹ý’/tmp/mysql.sock’Á¬½Óµ½·þÎñÆ÷¡£Mysql.sockÊÇ´´½¨Óëmysqld·þÎñÆ÷Ïà¹ØµÄMySQLͨÐŶ˵ãËùʹÓõÄÌ×½Ó×Ö¡£¶øPHP±ê×¼ÅäÖÃÕýÊÇͨ¹ý’/tmp/mysql.sock’À´Á¬½Ó ......
£¨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ÊÇ·ñÔÚ×Ô¶ ......
ÎÊÌâ½â¾öÁË£¬ÔÒòÊÇÔÚmy.cnfÖÐȱÉÙÁËÈçÏ´úÂ룺
[client]
default-character-set=utf8
[mysqld]
default-character-set=utf8
Èç¹û²»¼ÓÒÔÉÏ´úÂ룬ÄÇô¼´±ãMYSQL±àÒ밲װʱָ¶¨µÄ±àÂëÊÇUTF8£¬ÄÇôÔÚ½¨¿âʱÆäĬÈϱàÂëÈÔÊÇLATIN1£¬¶øÓÉÓÚ×Ö·û¼¯µÄ¼Ì³ÐÐÔ£¬¿âÖеıíÒ²ÊÇLATIN1µÄÁË¡£
ÕâÀïÁм¸ÌõÃüÁ´ó¼Ò¿ÉÒÔ×Ô¼ºÊÔÏ ......