MySQL??????????????????
???????????? ???????[ 2017/3/16 13:18:44 ] ????????????? MySQL
????18.Lost connection to MySQL server during query
????????MySQL???????????????????
???????
????????????????????????????????MySQL??????????????sql????????????????????
?????????????
?????????????????????????????????????????????????
????19.User 'red' has exceeded the 'max_updates' resource (current value: 500)
????????msql???red?????????'max_updates'(????′???)??'max_questions'(????????)??'max_connections'(????????)??????趨?500
???????
??????mysql????????????????mysql????????????????user??????????????????????mysql????????????????? max_questions max_updates max_connections?????????????? ??????? ?????????????????κ?????????????κ?????趨???????????????
?????????????
???????????????????????????????????????????mysql?????????????????mysql??????????FLUSH PRIVILEGES;
??????ú?????з??’;’
?????????????????????????????????????????Э??????
????20.Too many connections (1040)???????
??????????????????
???????
????????????????mysql??????????max_connections ??wait_timeout ???й????wait_timeout?????????????е???????????????????????????
?????????????
????1.???????????????????????? MySQL ????????????;
????2.?????????????????????????????? MySQL ???????????????ο???
??????? MySQL ??????? my.ini ???? my.cnf ?е??????
????max_connections= 1000
????wait_timeout = 10
???????????? MySQL ????????????????????????·????????????????
????21.There is no such grant defined for user '%s' on host '%s'
???????????1141
???????
????MySQL ??????????????????
?????????????
????1???????????????????????????????????????????????????????
????2?????????????????????????????????????????????????????й??????????????
????22.Error on rename of '%s' to '%s' (errno: %d)
????error.:1025
???????
???????????????????????????????????????
?????????????
????1.???????????????Щ?????????????????;
????2.????????????????????????????????????????????????????????????????????????????????????????????????
????23.Error reading file '%s' (errno: %d)
????error.:1023
???????
??????????????????????
?????????????
????1.????????????????????????????????á?
????2.????????????????????????????????? MySQL ????????????? MySQL ?????????????Linux ???????????? MySQL ????????????????????????????????????????
????24.Host '*****' is blocked because of many connection errors; unblock with 'mysqladmin flush-hosts'
????error.:1129
???????
???????????????????????????
?????????????
????????????????????????'****'?????Σ????????????????????????????????????????????????????????? MySQL ???????????????'mysqladmin flush-hosts'??????μ???????????? MySQL ?????
????25.dropping database (can't delete '%s'?? errno: %d)
????error.:1009
???????
?????????????????????????????????????
?????????????
????1.????????????????????????????????????
????2.???????????????
????26.Got error 28 from table handler
????error.:1030
???????
????????????????????????
?????????????
????1.????????????????????????? MySQL ??????????????????Щ???????;
????2.??????????????????????????????? MySQL ??????????????????Щ???????
????27.Can't create a new thread; if you are not out of available memory?? you can consult the manual for a possible OS-dependent bug??
????error.:11/35
???????
???????????????????????????????????????????????????
????1.????????????????
????2.?????????????????
?????????????
????1.?????????????????????????????????????????????????
????2.?????????????????????????????????????????????????????????????????????????????Щ???????????????????棬???????????????????????????????????????????
????28.Error: Client does not support authentication protocol requested by server; consider upgrading MySQL client
????error.:1251
???????
????????????? MySQL ?? 4.1 ????汾???????????????????????? MySQL Client ?? 4.1 ???????汾( Windows ????????????????????濴????????????? MySQL ?? Windows ?? client ?? server ?????????)??
?????????????
????1. Windows ??
??????????????? MySQL ??????????????MySQL 4.1/5.0 ????? PASSWORD ??????????????????????????????????????
????1) mysql->SET PASSWORD FOR 'some_user'@'some_host'=OLD_PASSWORD('new_password');
????2) mysql->UPDATE mysql.user SET Password=OLD_PASSWORD('new_password') WHERE Host='some_host' AND User='some_user';
????2. Linux/Unix ??
????Linux ????????????????? MySQL ???????????? rpm ????????Linux ???????
????rpm -ivh MySQL-client-4.1.15-0.i386.rpm
???????????? php ???????????
????--with-mysql=/your/path/to/mysql
??????????????????????????????????????????????????????????
????mysql->SET PASSWORD FOR 'some_user'@'some_host'=OLD_PASSWORD('new_password');
????mysql->UPDATE mysql.user SET Password=OLD_PASSWORD('new_password') WHERE Host='some_host' AND User='some_user';
????29.Error: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock'
????error.:2002
???????
???????????????????????????????????????
????1.MySQL ????????п????
????2.MySQL ?????????????????????? socket ?????
?????????????
????1.???????????????????????????????????????????
????2.???????????????????? MySQL ?????????????????п????????? MySQL ????;????????????????? Linux ??????????? MySQL ?? socket ??·???????? config.inc.php ???
????$dbhost = 'localhost'; ?? hostname ?????e??‘:’?? MySQL ?? socket ??·????
???????? MySQL ??????? localhost
????MySQL ?? socket ??·??? /tmp/mysql.sock
?????????????£?
????$dbhost = 'localhost:/temp/mysql.sock';
????30.Can't connect to MySQL server on 'localhost'
????error.:2003
???????
????MySQL ???????????????????????????? MySQL ?????????μ?????????????????my.ini ?? MySQL ?? basedir ·???????????
?????????????
????1.??????????????????????????????????????????á?
????2.??? my.ini ??? basedir ????????????????????????????? MySQL ????
????31.Lost connection to MySQL server during query
????error.:2013
???????
????????????????ж?????? MySQL ?????????????
?????????????
????1.???????????????????Ч?????????????Щ?????????ж????????????·????????????;
????2.?????????????????????????????????????????????????????????????????????????????·??????????????
????32.Got a packet bigger than 'max_allowed_packet' bytes
???????????1153
???????
?????????? Mantis ????????????С???е??? MySQL ???????????
?????????????
????1????????????????????·?????????
???????? MySQL ?????????(my.cnf ???? my.ini)
?????? [mysqld] ??????????(???????????????????)??
????max_allowed_packet=10M
???????? MySQL ????????????????????? 10MB??
????2?????????????????????????????????
???????????????????????漰???????????????????SPASVOС??(021-61079698-8054)?????????????????????????
??????
???mysql?????????????mysql????? distinct?÷?MySQL?н???????????з??Mysql?????????MySQL Cluster??δ????????????????ν?MySQL??????????300???????MySQL???Uber???????????????????MySql SQL??????????MySQL?????????????????λЧ?????SQL???Java???????:?????MySQL???????linux?°??mysql????MySQL ???????????????????binlog??MySQL????????????Щ??????MySQL???????Mysql???????JDBC?????mysql?????
???·???
??????????????????
2023/3/23 14:23:39???д?ò??????????
2023/3/22 16:17:39????????????????????Щ??
2022/6/14 16:14:27??????????????????????????
2021/10/18 15:37:44???????????????
2021/9/17 15:19:29???·???????·
2021/9/14 15:42:25?????????????
2021/5/28 17:25:47??????APP??????????
2021/5/8 17:01:11????????
?????????App Bug???????????????????????Jmeter?????????QC??????APP????????????????app?????е????????jenkins+testng+ant+webdriver??????????????JMeter????HTTP???????Selenium 2.0 WebDriver ??????