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

mysql Êý¾Ý¿âÐ¶ÔØ²»ÍêÈ«£¬ÅäÖóö´í½â¾ö°ì·¨

The security settings could not be applied to the database because the connection has failed with the following error.
Error Nr. 2003
Can't connect to MySQL server on 'localhost' (10061)
If a personal firewall is running on your machine, please make sure you have opened the TCP port 3306 for connections. Otherwise no client application can connect to the server. After you have opened the port please press [Retry] to apply the security settings.
If you are re-installing after you just uninstalled the MySQL server please note that the data directory was not removed automatically. Therefore the old password from your last installation is still needed to connect to the server. In this case please select skip now and re-run the Configuration Wizard from the start menu.
*****************************************************************************************
The security settings could not be applied to the database because the connection has failed with the following error.
Error Nr. 1045
Access denied for user 'root'@'localhost' (using password: YES)
If a personal firewall is running on your machine, please make sure you have opened the TCP port 3306 for connections. Otherwise no client application can connect to the server. After you have opened the port please press [Retry] to apply the security settings.
If you are re-installing after you just uninstalled the MySQL server please note that the data directory was not removed automatically. Therefore the old password from your last installation is still needed to connect to the server. In this case please select skip now and re-run the Configuration Wizard from the start menu.
MySQL 5.1 °²×°¹ý³ÌÖб¨apply security setting´íÎóµÄ½â¾ö°ì·¨
1, Ð¶ÔØMySQL
2, ɾ³ýĿ¼ C:\Documents and Settings\All Users\Application Data\MySQL
3, ÖØÐ°²×°MySQL ¾Í OK À²
------------------------------------------
[MySQL] Could not start the service MySQL ½â¾ö·½·¨
°²×°mysql 5.1.33,ÔÚÔËÐÐServer Instance Configuration wizardʱµÄExecut


Ïà¹ØÎĵµ£º

nagios¼à¿ØmysqlÖ÷´Ó¸´ÖÆ


nagios¼à¿ØmysqlÖ÷´Ó¸´ÖÆ
×÷ÕߣºÌïÒÝ(sery@163.com
)
ÆðÒò£ºnagios¿ÉÄÜ¼à¿Øµ½mysql·þÎñµÄÔËÐÐÇé¿ö£¬µ«È·²»ÄÜ¼à¿ØmysqlµÄÖ÷´Ó¸´ÖÆÊÇ·ñÕý³££ºÓÐʱºò£¬Í¬²½ÒѾ­Í£Ö¹£¬µ«¹ÜÀíÈËԱȴ²»ÖªµÀ¡£
ÏÂÊÖ´¦£ºµÇ½mysql´Ó·þÎñÆ÷£¬Í¨¹ýÖ´ÐÐ mysql> show slave status\G
²é¿´ÆäÊä³ö£¬¼´¿ÉÅж¨Ö÷´Ó¸´ÖÆÊÇ·ñÕý³£¡£ÏÂÃæÊÇij¸ö´Ó·þÎ ......

MySQLѧϰ(6)SHOW,USER

1.SELECT USER();
»ñµÃµ±Ç°µÇ½Óû§µÄÓû§ÃûÓëÖ÷»úÐÅÏ¢£¬Ê¹ÓøÃÃüÁî»áÏÔʾÀàËÆÓÚÈçÏÂÐÅÏ¢£ºroot@zxj.lest.vicp.cc£¬@Ç°ÃæÊÇÓû§Ãû£¬ºóÃæÊÇÖ÷»úÃû¡£
2.SHOWÓ÷¨£¬
SHOW DATABASES--ÏÔʾ¶àÉÙ¸öÊý¾Ý¿â£¬Ò²¿ÉÒÔ½Ð×ö±í¿Õ¼ä¡£
SHOW TABLES--ÏÔʾÓжàÉÙ¸ö±í¡£
SHOW VARIABLES--ÏÔʾÊý¾Ý¿â±äÁ¿¡£
SHOW MASTER STATUS.
SHOW C ......

MySQLѧϰ(7)varchar

      ½ñÌ콨һ¸öUTF-8µÄ±í£¬ÆäÖÐÈýÁж¼ÓÃÁËvarcharÕâ¸öÊý¾ÝÀàÐÍ£¬ÎÊÌâ¾ÍÕâôÀ´ÁË£¬ÎÒµÄÈý¸ö×ֶγ¤¶È¼ÓÆðÀ´³¬¹ýÁË65535×Ö½Ú¡£ÒÔǰÒÔΪÿһ¸ö×Ö¶Î×î´óΪ65535£¬Ïë²»µ½Ò»¸ö±í¹²Ïí65535×Ö½Ú¡£Òâ˼ÊÇ˵Èý¸ö×ֶγ¤¶È¼ÓÆðÀ´²»Äܳ¬¹ý65535£¬¶ø²ÉÓÃUTF-8µÄ»°£¬Ò»¸ö×Ö·ûÊÇÕ¼Èý¸ö×ֽڵġ£¼´Èý×Ö¶Î¼ÓÆðÀ´µÄ×Ü ......

MySql Êý¾ÝÀàÐÍ´óÈ«

MySQLÖ§³Ö´óÁ¿µÄÁÐÀàÐÍ£¬Ëü¿ÉÒÔ±»·ÖΪ3ÀࣺÊý×ÖÀàÐÍ¡¢ÈÕÆÚºÍʱ¼äÀàÐÍÒÔ¼°×Ö·û´®(×Ö·û)ÀàÐÍ¡£±¾½ÚÊ×Ïȸø³ö¿ÉÓÃÀàÐ͵ÄÒ»¸ö¸ÅÊö£¬²¢ÇÒ×ܽáÿ¸öÁÐÀàÐ͵Ĵ洢ÐèÇó£¬È»ºóÌṩÿ¸öÀàÖеÄÀàÐÍÐÔÖʵĸüÏêϸµÄÃèÊö¡£¸ÅÊöÓÐÒâ¼ò»¯£¬¸üÏêϸµÄ˵Ã÷Ó¦¸Ã¿¼Âǵ½ÓйØÌض¨ÁÐÀàÐ͵ĸ½¼ÓÐÅÏ¢£¬ÀýÈçÄãÄÜΪÆäÖ¸¶¨ÖµµÄÔÊÐí¸ñʽ¡£
ÓÉMySQLÖ§³ÖµÄÁÐ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ