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Ö÷´Ó¸´ÖÆ
×÷ÕߣºÌïÒÝ(sery@163.com
)
ÆðÒò£ºnagios¿ÉÄܼà¿Øµ½mysql·þÎñµÄÔËÐÐÇé¿ö£¬µ«È·²»Äܼà¿ØmysqlµÄÖ÷´Ó¸´ÖÆÊÇ·ñÕý³££ºÓÐʱºò£¬Í¬²½ÒѾֹͣ£¬µ«¹ÜÀíÈËԱȴ²»ÖªµÀ¡£
ÏÂÊÖ´¦£ºµÇ½mysql´Ó·þÎñÆ÷£¬Í¨¹ýÖ´ÐÐ mysql> show slave status\G
²é¿´ÆäÊä³ö£¬¼´¿ÉÅж¨Ö÷´Ó¸´ÖÆÊÇ·ñÕý³£¡£ÏÂÃæÊÇij¸ö´Ó·þÎ ......
MySQLË÷Òý¼ò½é... 1
Ò»¡¢Ë÷Òý·Öµ¥ÁÐË÷ÒýºÍ×éºÏË÷Òý…………………………………………………………………………………&hel ......
1. mysqldump -u username -h somehost -p --compatible=mysql40 db_name > temp.sql
2. ÓÃphpmyadminÇå¿ÕÊý¾Ý¿â²¢ÉèÖÃÊý¾Ý¿âÕûÀíΪutf8_general_ci
3. mysql -u username -h somehost -p --default-character-set=utf8 db_name < temp.sql ......
phpmyadmin2.11.92 --APMSEVR5.2.6
д´æ´¢¹ý³ÌʱÌáʾerror 1307 (HY000):Failed to create procedure...
-----------------------------------------------------------------------
½«phpmyadminÖеÄmysqlÊý¾Ý¿âÖеıíprocɾ³ý
Ö´ÐÐÒÔÏ´úÂëÖؽ¨¸Ã±í
-------------------------------------------------------------- ......
1¡¢ÏÂÔØMySQLÃâ°²×°°æ/¶þ½øÖÆ°æÈí¼þ£¨²»ÓñàÒ룩
Îļþ¸ñʽ£ºMYSQL-VERSION-OS.tar.gz
2¡¢´´½¨MySQL×飬½¨Á¢MySQLÓû§²¢¼ÓÈëµ½mysql×éÖÐ
£¨²»Í¬°æ±¾µÄUnixÖУ¬groupaddºÍuseraddµÄÓï·¨¿ÉÄÜ»áÉÔÓв»Í¬¡££©
#groupadd mysql
#useradd -g mysql mysql
3¡¢½øÈëĿ¼/usr/local£¬½âѹËõÃâ°²×°°æ£¬²¢ÔÚ ......