[{"_1":2,"_801":-5,"_802":-5},"loaderData",{"_3":4,"_22":23},"root",{"_5":6},"current",{"_7":8,"_9":10,"_21":8},"development",false,"env",{"_11":12,"_13":14,"_15":16,"_17":18,"_19":20},"COMMIT_SHA","032c64b08f7dd5f7f1f6f3923a1c6d1445f4fb68","IMAGE_CDN","https://planetscale-images.imgix.net","IMAGE_CDN_ENABLED","true","INTERNAL_API","https://api.planetscale.com","SENTRY_DSN","https://bd81903b44804e22a06bdc0c1a91b303@o499952.ingest.us.sentry.io/4504531942572032","userSignedIn","routes/blog.author.$slug",{"_24":25,"_30":31,"_791":792,"_3":800},"author",{"_26":27,"_28":29},"slug","mary","name","Mary Gathoni","blogs",[32],{"_26":33,"_34":35,"_729":730,"_731":-7,"_732":733,"_740":772,"_773":774,"_777":778,"_780":781,"_782":783,"_784":785},"common-mysql-errors-how-to-fix-them","body",[36,46,61,66,94,106,111,120,125,164,175,180,191,196,212,217,222,227,260,271,299,325,336,341,380,391,396,401,412,424,435,440,451,456,468,479,484,495,507,522,532,537,542,553,570,581,586,596,607,630,635,646,657,668,673,684,689,700,711],["SingleFetchClassInstance",37],{"_38":39,"_28":40,"_41":42,"_43":44},"$$mdtype","Tag","p","attributes",{},"children",[45],"While MySQL error codes are useful, understanding what they mean can be difficult. This article looks at common MySQL error codes, non-coded errors, and how to fix them.",["SingleFetchClassInstance",47],{"_38":39,"_28":48,"_41":49,"_43":52},"h2",{"_50":51},"id","mysql-error-code-format",[53],["SingleFetchClassInstance",54],{"_38":39,"_28":55,"_41":56,"_43":59},"a",{"_57":58},"href","#mysql-error-code-format",[60],"MySQL error code format",["SingleFetchClassInstance",62],{"_38":39,"_28":40,"_41":63,"_43":64},{},[65],"Each MySQL error includes:",["SingleFetchClassInstance",67],{"_38":39,"_28":68,"_41":69,"_43":70},"ul",{},[71,77,89],["SingleFetchClassInstance",72],{"_38":39,"_28":73,"_41":74,"_43":75},"li",{},[76],"An error number: A MySQL-specific number corresponding to a particular error.",["SingleFetchClassInstance",78],{"_38":39,"_28":73,"_41":79,"_43":80},{},[81,82,88],"An ",["SingleFetchClassInstance",83],{"_38":39,"_28":84,"_41":85,"_43":86},"code",{},[87],"SQLSTATE"," value: A five-character string that indicates the error condition.",["SingleFetchClassInstance",90],{"_38":39,"_28":73,"_41":91,"_43":92},{},[93],"An error message: A textual description of the error.",["SingleFetchClassInstance",95],{"_38":39,"_28":96,"_41":97,"_43":99},"h3",{"_50":98},"mysql-error-example",[100],["SingleFetchClassInstance",101],{"_38":39,"_28":55,"_41":102,"_43":104},{"_57":103},"#mysql-error-example",[105],"MySQL error example",["SingleFetchClassInstance",107],{"_38":39,"_28":40,"_41":108,"_43":109},{},[110],"Here’s an example of what a MySQL error code looks like:",["SingleFetchClassInstance",112],{"_38":39,"_28":113,"_41":114,"_43":119},"CodeBlock",{"_115":116,"_117":118},"html","

ERROR 1146 (42S02): Table 'test.no_such_table' doesn't exist\n

","language","sql",[],["SingleFetchClassInstance",121],{"_38":39,"_28":40,"_41":122,"_43":123},{},[124],"In the error above:",["SingleFetchClassInstance",126],{"_38":39,"_28":68,"_41":127,"_43":128},{},[129,139,154],["SingleFetchClassInstance",130],{"_38":39,"_28":73,"_41":131,"_43":132},{},[133,138],["SingleFetchClassInstance",134],{"_38":39,"_28":84,"_41":135,"_43":136},{},[137],"1146"," is the error number.",["SingleFetchClassInstance",140],{"_38":39,"_28":73,"_41":141,"_43":142},{},[143,148,149,153],["SingleFetchClassInstance",144],{"_38":39,"_28":84,"_41":145,"_43":146},{},[147],"42S02"," is the ",["SingleFetchClassInstance",150],{"_38":39,"_28":84,"_41":151,"_43":152},{},[87]," value.",["SingleFetchClassInstance",155],{"_38":39,"_28":73,"_41":156,"_43":157},{},[158,163],["SingleFetchClassInstance",159],{"_38":39,"_28":84,"_41":160,"_43":161},{},[162],"Table test.no_such_table doesn't exist"," is the error message.",["SingleFetchClassInstance",165],{"_38":39,"_28":48,"_41":166,"_43":168},{"_50":167},"common-mysql-error-codes",[169],["SingleFetchClassInstance",170],{"_38":39,"_28":55,"_41":171,"_43":173},{"_57":172},"#common-mysql-error-codes",[174],"Common MySQL error codes",["SingleFetchClassInstance",176],{"_38":39,"_28":40,"_41":177,"_43":178},{},[179],"Let’s explore some common error codes, what they mean, and how to resolve them.",["SingleFetchClassInstance",181],{"_38":39,"_28":96,"_41":182,"_43":184},{"_50":183},"error-1040-too-many-connections",[185],["SingleFetchClassInstance",186],{"_38":39,"_28":55,"_41":187,"_43":189},{"_57":188},"#error-1040-too-many-connections",[190],"Error 1040: Too many connections",["SingleFetchClassInstance",192],{"_38":39,"_28":40,"_41":193,"_43":194},{},[195],"Error 1040 occurs when MySQL reaches the maximum number of client connections, forcing you to close connections so the server can accept new connections.",["SingleFetchClassInstance",197],{"_38":39,"_28":40,"_41":198,"_43":199},{},[200,201,206,207,211],"By default, MySQL can handle up to 151 connections. If needed, you can change this by editing the value held by the ",["SingleFetchClassInstance",202],{"_38":39,"_28":84,"_41":203,"_43":204},{},[205],"max_connections"," variable. One approach to fixing this error is setting the ",["SingleFetchClassInstance",208],{"_38":39,"_28":84,"_41":209,"_43":210},{},[205]," value to a number corresponding to connection usage.",["SingleFetchClassInstance",213],{"_38":39,"_28":40,"_41":214,"_43":215},{},[216],"For instance, if you think you need around 200 connections, you can set it to 250.",["SingleFetchClassInstance",218],{"_38":39,"_28":113,"_41":219,"_43":221},{"_115":220,"_117":118},"

SET GLOBAL max_connections = 250;\n

",[],["SingleFetchClassInstance",223],{"_38":39,"_28":40,"_41":224,"_43":225},{},[226],"Note that the more you increase the number of connections, the more memory-intensive MySQL gets, increasing the chance of the server crashing.",["SingleFetchClassInstance",228],{"_38":39,"_28":40,"_41":229,"_43":230},{},[231],["SingleFetchClassInstance",232],{"_38":39,"_28":233,"_41":234,"_43":237},"Callout",{"_235":236},"type","tip",[238,239,245,246,252,253,259]," ",["SingleFetchClassInstance",240],{"_38":39,"_28":55,"_41":241,"_43":243},{"_57":242},"/docs/what-is-planetscale",[244],"PlanetScale, a MySQL-compatible database",", supports ",["SingleFetchClassInstance",247],{"_38":39,"_28":55,"_41":248,"_43":250},{"_57":249},"/blog/one-million-connections",[251],"nearly unlimited connections",". You can ",["SingleFetchClassInstance",254],{"_38":39,"_28":55,"_41":255,"_43":257},{"_57":256},"https://auth.planetscale.com/sign-up",[258],"sign up for an account"," today to get increased connections, no downtime schema changes, an advanced query monitoring dashboard, and more. ",["SingleFetchClassInstance",261],{"_38":39,"_28":96,"_41":262,"_43":264},{"_50":263},"error-1045-access-denied",[265],["SingleFetchClassInstance",266],{"_38":39,"_28":55,"_41":267,"_43":269},{"_57":268},"#error-1045-access-denied",[270],"Error 1045: Access denied",["SingleFetchClassInstance",272],{"_38":39,"_28":40,"_41":273,"_43":274},{},[275,276,281,282,281,287,292,293,298],"Error 1045 occurs when a user is denied permission to perform operations such as ",["SingleFetchClassInstance",277],{"_38":39,"_28":84,"_41":278,"_43":279},{},[280],"SELECT",", ",["SingleFetchClassInstance",283],{"_38":39,"_28":84,"_41":284,"_43":285},{},[286],"INSERT",["SingleFetchClassInstance",288],{"_38":39,"_28":84,"_41":289,"_43":290},{},[291],"UPDATE",", and ",["SingleFetchClassInstance",294],{"_38":39,"_28":84,"_41":295,"_43":296},{},[297],"DELETE"," on the database. Below is a list of some reasons why MySQL denies access and possible fixes.",["SingleFetchClassInstance",300],{"_38":39,"_28":68,"_41":301,"_43":302},{},[303,308,320],["SingleFetchClassInstance",304],{"_38":39,"_28":73,"_41":305,"_43":306},{},[307],"The user doesn’t exist. Check if the user exists in the database, and if they don’t, create a new user.",["SingleFetchClassInstance",309],{"_38":39,"_28":73,"_41":310,"_43":311},{},[312,313,319],"The password is incorrect. To fix this, ",["SingleFetchClassInstance",314],{"_38":39,"_28":55,"_41":315,"_43":317},{"_57":316},"https://dev.mysql.com/doc/refman/8.0/en/resetting-permissions.html",[318],"reset the MySQL password",".",["SingleFetchClassInstance",321],{"_38":39,"_28":73,"_41":322,"_43":323},{},[324],"Connecting to the wrong host. Double check that the host you’re connecting to is correct.",["SingleFetchClassInstance",326],{"_38":39,"_28":96,"_41":327,"_43":329},{"_50":328},"error-1064-syntax-error",[330],["SingleFetchClassInstance",331],{"_38":39,"_28":55,"_41":332,"_43":334},{"_57":333},"#error-1064-syntax-error",[335],"Error 1064: Syntax error",["SingleFetchClassInstance",337],{"_38":39,"_28":40,"_41":338,"_43":339},{},[340],"SQL syntax issues are often to blame for this error, such as reserved keywords, missing data, or mistyped commands. The best way of identifying the syntax issue is by comparing the query with the error message to identify the specific point in the query that raised the error. To troubleshoot this error:",["SingleFetchClassInstance",342],{"_38":39,"_28":68,"_41":343,"_43":344},{},[345,350,359,364,369],["SingleFetchClassInstance",346],{"_38":39,"_28":73,"_41":347,"_43":348},{},[349],"Proofread your code and correct mistyped commands.",["SingleFetchClassInstance",351],{"_38":39,"_28":73,"_41":352,"_43":353},{},[354,355,319],"If you have to use reserved keywords, place them in backticks like this: ",["SingleFetchClassInstance",356],{"_38":39,"_28":84,"_41":357,"_43":358},{},[286],["SingleFetchClassInstance",360],{"_38":39,"_28":73,"_41":361,"_43":362},{},[363],"Replace obsolete commands with current ones.",["SingleFetchClassInstance",365],{"_38":39,"_28":73,"_41":366,"_43":367},{},[368],"Add missing data to the database.",["SingleFetchClassInstance",370],{"_38":39,"_28":73,"_41":371,"_43":372},{},[373,374,319],"Use an automated syntax checker, like ",["SingleFetchClassInstance",375],{"_38":39,"_28":55,"_41":376,"_43":378},{"_57":377},"https://www.eversql.com/sql-syntax-check-validator/",[379],"EverSQL",["SingleFetchClassInstance",381],{"_38":39,"_28":96,"_41":382,"_43":384},{"_50":383},"error-1114-table-is-full",[385],["SingleFetchClassInstance",386],{"_38":39,"_28":55,"_41":387,"_43":389},{"_57":388},"#error-1114-table-is-full",[390],"Error 1114: Table is full",["SingleFetchClassInstance",392],{"_38":39,"_28":40,"_41":393,"_43":394},{},[395],"Error 1114 occurs when you try to insert data into a table due to a shortage of disk memory. Disk full issues can also occur when creating a backup for large databases alongside the original database.",["SingleFetchClassInstance",397],{"_38":39,"_28":40,"_41":398,"_43":399},{},[400],"To fix this error, check the partition in which the MySQL server is installed and ensure it’s less than 80% full.",["SingleFetchClassInstance",402],{"_38":39,"_28":96,"_41":403,"_43":405},{"_50":404},"error-2006-mysql-server-connection-closed",[406],["SingleFetchClassInstance",407],{"_38":39,"_28":55,"_41":408,"_43":410},{"_57":409},"#error-2006-mysql-server-connection-closed",[411],"Error 2006: MySQL server connection closed",["SingleFetchClassInstance",413],{"_38":39,"_28":40,"_41":414,"_43":415},{},[416,417,423],"Error 2006 occurs when the MySQL server connection has timed out and closed the connection. The

",["SingleFetchClassInstance",418],{"_38":39,"_28":55,"_41":419,"_43":421},{"_57":420},"https://dev.mysql.com/doc/refman/8.0/en/server-system-variables.html#sysvar_wait_timeout",[422],"wait_timeout","

value determines how long the server waits before closing a connection due to inactivity. To fix this, check the wait_timeout value (28800 seconds by default) and increase it if it’s too low.",["SingleFetchClassInstance",425],{"_38":39,"_28":96,"_41":426,"_43":428},{"_50":427},"error-2008-client-ran-out-of-memory",[429],["SingleFetchClassInstance",430],{"_38":39,"_28":55,"_41":431,"_43":433},{"_57":432},"#error-2008-client-ran-out-of-memory",[434],"Error 2008: Client ran out of memory",["SingleFetchClassInstance",436],{"_38":39,"_28":40,"_41":437,"_43":438},{},[439],"This error message means there’s not enough memory to store the entire query result. To solve this problem, check the specifics of the query. Do you need to return this many results from the database? If not, modify the query to return only the necessary rows.",["SingleFetchClassInstance",441],{"_38":39,"_28":96,"_41":442,"_43":444},{"_50":443},"error-2013-lost-connection-during-query",[445],["SingleFetchClassInstance",446],{"_38":39,"_28":55,"_41":447,"_43":449},{"_57":448},"#error-2013-lost-connection-during-query",[450],"Error 2013: Lost connection during query",["SingleFetchClassInstance",452],{"_38":39,"_28":40,"_41":453,"_43":454},{},[455],"Error 2013 occurs when the connection drops between the MySQL client and the database server, usually because the database took too long to respond.",["SingleFetchClassInstance",457],{"_38":39,"_28":40,"_41":458,"_43":459},{},[460,461,467],"To fix the error, first, check that your internet connection is stable. Delayed results may be due to network connectivity issues. Also, try increasing the

",["SingleFetchClassInstance",462],{"_38":39,"_28":55,"_41":463,"_43":465},{"_57":464},"https://dev.mysql.com/doc/refman/8.0/en/server-system-variables.html#sysvar_net_read_timeout",[466],"net-read-timeout","

value to give more time for the query to complete.",["SingleFetchClassInstance",469],{"_38":39,"_28":48,"_41":470,"_43":472},{"_50":471},"non-coded-errors",[473],["SingleFetchClassInstance",474],{"_38":39,"_28":55,"_41":475,"_43":477},{"_57":476},"#non-coded-errors",[478],"Non-coded errors",["SingleFetchClassInstance",480],{"_38":39,"_28":40,"_41":481,"_43":482},{},[483],"In addition to coded errors, there are several common non-coded MySQL errors that you might encounter.",["SingleFetchClassInstance",485],{"_38":39,"_28":96,"_41":486,"_43":488},{"_50":487},"packet-too-large",[489],["SingleFetchClassInstance",490],{"_38":39,"_28":55,"_41":491,"_43":493},{"_57":492},"#packet-too-large",[494],"Packet too large",["SingleFetchClassInstance",496],{"_38":39,"_28":40,"_41":497,"_43":498},{},[499,500,506],"The maximum possible size of a packet transmitted to or from a MySQL 8.0 server or client is 1GB. The

",["SingleFetchClassInstance",501],{"_38":39,"_28":55,"_41":502,"_43":504},{"_57":503},"https://dev.mysql.com/doc/refman/8.0/en/server-system-variables.html#sysvar_max_allowed_packet",[505],"max_allowed_packet","

variable stores the allowable packet size.",["SingleFetchClassInstance",508],{"_38":39,"_28":40,"_41":509,"_43":510},{},[511,512,516,517,521],"For the client, the default ",["SingleFetchClassInstance",513],{"_38":39,"_28":84,"_41":514,"_43":515},{},[505]," value is 16MB and for the server is 64MB. To fix this error, increase the ",["SingleFetchClassInstance",518],{"_38":39,"_28":84,"_41":519,"_43":520},{},[505]," value for the client and the server.",["SingleFetchClassInstance",523],{"_38":39,"_28":40,"_41":524,"_43":525},{},[526,527,531],"For example, increase the ",["SingleFetchClassInstance",528],{"_38":39,"_28":84,"_41":529,"_43":530},{},[505]," for the client to 32MB:",["SingleFetchClassInstance",533],{"_38":39,"_28":113,"_41":534,"_43":536},{"_115":535,"_117":118},"

mysql --max_allowed_packet=32M\n

",[],["SingleFetchClassInstance",538],{"_38":39,"_28":40,"_41":539,"_43":540},{},[541],"Note that MySQL needs to restart for the change to take effect.",["SingleFetchClassInstance",543],{"_38":39,"_28":96,"_41":544,"_43":546},{"_50":545},"cant-createwrite-file",[547],["SingleFetchClassInstance",548],{"_38":39,"_28":55,"_41":549,"_43":551},{"_57":550},"#cant-createwrite-file",[552],"Can’t create/write file",["SingleFetchClassInstance",554],{"_38":39,"_28":40,"_41":555,"_43":556},{},[557,558,563,564,569],"You’ll get this error when MySQL can’t create the temporary file for the result in the temporary directory. This might be because there’s no memory left in the ",["SingleFetchClassInstance",559],{"_38":39,"_28":84,"_41":560,"_43":561},{},[562],"/tmp"," folder, or if there’s an incorrect configuration that doesn’t allow MySQL to write in the",["SingleFetchClassInstance",565],{"_38":39,"_28":84,"_41":566,"_43":567},{},[568]," /tmp"," folder.",["SingleFetchClassInstance",571],{"_38":39,"_28":40,"_41":572,"_43":573},{},[574,575,580],"To solve the memory issue, try starting the MySQL server with the ",["SingleFetchClassInstance",576],{"_38":39,"_28":84,"_41":577,"_43":578},{},[579],"--tmpdir"," option and specifying a directory for the server to write to. For example, to specify C:/temp:",["SingleFetchClassInstance",582],{"_38":39,"_28":113,"_41":583,"_43":585},{"_115":584,"_117":118},"

tmpdir=C:/temp\n

",[],["SingleFetchClassInstance",587],{"_38":39,"_28":40,"_41":588,"_43":589},{},[590,591,319],"If the configuration is incorrect, make sure MySQL has permission to write to the directory specified by ",["SingleFetchClassInstance",592],{"_38":39,"_28":84,"_41":593,"_43":594},{},[595],"tmpdir",["SingleFetchClassInstance",597],{"_38":39,"_28":96,"_41":598,"_43":600},{"_50":599},"commands-out-of-sync",[601],["SingleFetchClassInstance",602],{"_38":39,"_28":55,"_41":603,"_43":605},{"_57":604},"#commands-out-of-sync",[606],"Commands out of sync",["SingleFetchClassInstance",608],{"_38":39,"_28":40,"_41":609,"_43":610},{},[611,612,617,618,623,624,629],"The ",["SingleFetchClassInstance",613],{"_38":39,"_28":84,"_41":614,"_43":615},{},[616],"commands out of sync"," error occurs when you call client functions in the wrong order. For example, using ",["SingleFetchClassInstance",619],{"_38":39,"_28":84,"_41":620,"_43":621},{},[622],"mysql_use_result()"," before calling ",["SingleFetchClassInstance",625],{"_38":39,"_28":84,"_41":626,"_43":627},{},[628],"mysql_free_result()"," will raise this error.",["SingleFetchClassInstance",631],{"_38":39,"_28":40,"_41":632,"_43":633},{},[634],"To fix this error, check your functions and make sure you are calling them in the correct order.",["SingleFetchClassInstance",636],{"_38":39,"_28":96,"_41":637,"_43":639},{"_50":638},"hostname-is-blocked",[640],["SingleFetchClassInstance",641],{"_38":39,"_28":55,"_41":642,"_43":644},{"_57":643},"#hostname-is-blocked",[645],"Hostname is blocked",["SingleFetchClassInstance",647],{"_38":39,"_28":40,"_41":648,"_43":649},{},[650,651,656],"This error occurs when the MySQL server receives too many connections that have been interrupted by the host. The server assumes something is wrong, like someone trying to break in, and blocks the hostname until you execute the ",["SingleFetchClassInstance",652],{"_38":39,"_28":84,"_41":653,"_43":654},{},[655],"flush-hosts"," command.",["SingleFetchClassInstance",658],{"_38":39,"_28":40,"_41":659,"_43":660},{},[661,662,667],"The number of interrupted connect requests is determined by the ",["SingleFetchClassInstance",663],{"_38":39,"_28":84,"_41":664,"_43":665},{},[666],"max_connect_errors ","variable, 10 by default. Modify the value by starting the MySQL server like this:",["SingleFetchClassInstance",669],{"_38":39,"_28":113,"_41":670,"_43":672},{"_115":671,"_117":118},"

mysqld_safe --max_connect_errors=10000\n

",[],["SingleFetchClassInstance",674],{"_38":39,"_28":96,"_41":675,"_43":677},{"_50":676},"aborted-connections",[678],["SingleFetchClassInstance",679],{"_38":39,"_28":55,"_41":680,"_43":682},{"_57":681},"#aborted-connections",[683],"Aborted connections",["SingleFetchClassInstance",685],{"_38":39,"_28":40,"_41":686,"_43":687},{},[688],"This error occurs when clients attempt and fail to connect to the MySQL server, often due to the client using incorrect credentials or lacking access privileges.",["SingleFetchClassInstance",690],{"_38":39,"_28":40,"_41":691,"_43":692},{},[693,694,699],"To fix this error, start by checking the error logs and general logs at ",["SingleFetchClassInstance",695],{"_38":39,"_28":84,"_41":696,"_43":697},{},[698],"/var/log/mysql/"," to determine the cause of the aborted connections.",["SingleFetchClassInstance",701],{"_38":39,"_28":48,"_41":702,"_43":704},{"_50":703},"conclusion",[705],["SingleFetchClassInstance",706],{"_38":39,"_28":55,"_41":707,"_43":709},{"_57":708},"#conclusion",[710],"Conclusion",["SingleFetchClassInstance",712],{"_38":39,"_28":40,"_41":713,"_43":714},{},[715,716,721,722,728],"Error handling can be exhausting and time-consuming, so it's important to understand how to fix the common MySQL errors. If you're looking for a straightforward, developer-friendly way to run MySQL, ",["SingleFetchClassInstance",717],{"_38":39,"_28":55,"_41":718,"_43":719},{"_57":256},[720],"try PlanetScale",". You can import your application's existing database with no downtime using our ",["SingleFetchClassInstance",723],{"_38":39,"_28":55,"_41":724,"_43":726},{"_57":725},"/docs/vitess/imports/database-imports",[727],"Import tool"," and be up and running in no time.","body_text","While MySQL error codes are useful, understanding what they mean can be difficult. This article looks at common MySQL error codes, non-coded errors, and how to fix them.\nMySQL error code format\nEach MySQL error includes:\nAn error number: A MySQL-specific number corresponding to a particular error.\nAn SQLSTATE value: A five-character string that indicates the error condition.\nAn error message: A textual description of the error.\nMySQL error example\nHere’s an example of what a MySQL error code looks like:ERROR 1146 (42S02): Table 'test.no_such_table' doesn't exist\n\nIn the error above:\n1146 is the error number.\n42S02 is the SQLSTATE value.\nTable test.no_such_table doesn't exist is the error message.\nCommon MySQL error codes\nLet’s explore some common error codes, what they mean, and how to resolve them.\nError 1040: Too many connections\nError 1040 occurs when MySQL reaches the maximum number of client connections, forcing you to close connections so the server can accept new connections.\nBy default, MySQL can handle up to 151 connections. If needed, you can change this by editing the value held by the max_connections variable. One approach to fixing this error is setting the max_connections value to a number corresponding to connection usage.\nFor instance, if you think you need around 200 connections, you can set it to 250.SET GLOBAL max_connections = 250;\n\nNote that the more you increase the number of connections, the more memory-intensive MySQL gets, increasing the chance of the server crashing.\n PlanetScale, a MySQL-compatible database, supports nearly unlimited connections. You can sign up for an account today to get increased connections, no downtime schema changes, an advanced query monitoring dashboard, and more. \nError 1045: Access denied\nError 1045 occurs when a user is denied permission to perform operations such as SELECT, INSERT, UPDATE, and DELETE on the database. Below is a list of some reasons why MySQL denies access and possible fixes.\nThe user doesn’t exist. Check if the user exists in the database, and if they don’t, create a new user.\nThe password is incorrect. To fix this, reset the MySQL password.\nConnecting to the wrong host. Double check that the host you’re connecting to is correct.\nError 1064: Syntax error\nSQL syntax issues are often to blame for this error, such as reserved keywords, missing data, or mistyped commands. The best way of identifying the syntax issue is by comparing the query with the error message to identify the specific point in the query that raised the error. To troubleshoot this error:\nProofread your code and correct mistyped commands.\nIf you have to use reserved keywords, place them in backticks like this: INSERT.\nReplace obsolete commands with current ones.\nAdd missing data to the database.\nUse an automated syntax checker, like EverSQL.\nError 1114: Table is full\nError 1114 occurs when you try to insert data into a table due to a shortage of disk memory. Disk full issues can also occur when creating a backup for large databases alongside the original database.\nTo fix this error, check the partition in which the MySQL server is installed and ensure it’s less than 80% full.\nError 2006: MySQL server connection closed\nError 2006 occurs when the MySQL server connection has timed out and closed the connection. The wait_timeout value determines how long the server waits before closing a connection due to inactivity. To fix this, check the wait_timeout value (28800 seconds by default) and increase it if it’s too low.\nError 2008: Client ran out of memory\nThis error message means there’s not enough memory to store the entire query result. To solve this problem, check the specifics of the query. Do you need to return this many results from the database? If not, modify the query to return only the necessary rows.\nError 2013: Lost connection during query\nError 2013 occurs when the connection drops between the MySQL client and the database server, usually because the database took too long to respond.\nTo fix the error, first, check that your internet connection is stable. Delayed results may be due to network connectivity issues. Also, try increasing the net-read-timeout value to give more time for the query to complete.\nNon-coded errors\nIn addition to coded errors, there are several common non-coded MySQL errors that you might encounter.\nPacket too large\nThe maximum possible size of a packet transmitted to or from a MySQL 8.0 server or client is 1GB. The max_allowed_packet variable stores the allowable packet size.\nFor the client, the default max_allowed_packet value is 16MB and for the server is 64MB. To fix this error, increase the max_allowed_packet value for the client and the server.\nFor example, increase the max_allowed_packet for the client to 32MB:mysql --max_allowed_packet=32M\n\nNote that MySQL needs to restart for the change to take effect.\nCan’t create/write file\nYou’ll get this error when MySQL can’t create the temporary file for the result in the temporary directory. This might be because there’s no memory left in the /tmp folder, or if there’s an incorrect configuration that doesn’t allow MySQL to write in the /tmp folder.\nTo solve the memory issue, try starting the MySQL server with the --tmpdir option and specifying a directory for the server to write to. For example, to specify C:/temp:tmpdir=C:/temp\n\nIf the configuration is incorrect, make sure MySQL has permission to write to the directory specified by tmpdir.\nCommands out of sync\nThe commands out of sync error occurs when you call client functions in the wrong order. For example, using mysql_use_result() before calling mysql_free_result() will raise this error.\nTo fix this error, check your functions and make sure you are calling them in the correct order.\nHostname is blocked\nThis error occurs when the MySQL server receives too many connections that have been interrupted by the host. The server assumes something is wrong, like someone trying to break in, and blocks the hostname until you execute the flush-hosts command.\nThe number of interrupted connect requests is determined by the max_connect_errors variable, 10 by default. Modify the value by starting the MySQL server like this:mysqld_safe --max_connect_errors=10000\n\nAborted connections\nThis error occurs when clients attempt and fail to connect to the MySQL server, often due to the client using incorrect credentials or lacking access privileges.\nTo fix this error, start by checking the error logs and general logs at /var/log/mysql/ to determine the cause of the aborted connections.\nConclusion\nError handling can be exhausting and time-consuming, so it's important to understand how to fix the common MySQL errors. If you're looking for a straightforward, developer-friendly way to run MySQL, try PlanetScale. You can import your application's existing database with no downtime using our Import tool and be up and running in no time.","aside","toc",[734,742,758,770],{"_43":735,"_50":51,"_738":741,"_740":60},[736],{"_43":737,"_50":98,"_738":739,"_740":105},[],"level",3,"title",2,{"_43":743,"_50":167,"_738":741,"_740":174},[744,746,748,750,752,754,756],{"_43":745,"_50":183,"_738":739,"_740":190},[],{"_43":747,"_50":263,"_738":739,"_740":270},[],{"_43":749,"_50":328,"_738":739,"_740":335},[],{"_43":751,"_50":383,"_738":739,"_740":390},[],{"_43":753,"_50":404,"_738":739,"_740":411},[],{"_43":755,"_50":427,"_738":739,"_740":434},[],{"_43":757,"_50":443,"_738":739,"_740":450},[],{"_43":759,"_50":471,"_738":741,"_740":478},[760,762,764,766,768],{"_43":761,"_50":487,"_738":739,"_740":494},[],{"_43":763,"_50":545,"_738":739,"_740":552},[],{"_43":765,"_50":599,"_738":739,"_740":606},[],{"_43":767,"_50":638,"_738":739,"_740":645},[],{"_43":769,"_50":676,"_738":739,"_740":683},[],{"_43":771,"_50":703,"_738":741,"_740":710},[],"Common MySQL errors and how to fix them","authors",[775],{"_26":27,"_28":29,"_776":-7},"x","categories",[779],"tutorials","excerpt","An overview of some common MySQL error codes you may run into, what they mean, and how to solve them.","createdAt","2023-01-27T14:00:35.694Z","meta",{"_786":787,"_788":781,"_789":790,"_740":772},"canonical","https://planetscale.com/blog/common-mysql-errors-how-to-fix-them","description","image","/assets/social-DtnN8vYG.png","pagination",{"_793":794,"_795":8,"_796":8,"_797":794,"_798":799},"page",1,"hasPrev","hasNext","totalPages","url","https://planetscale.com/blog/author/mary","https://planetscale.com","actionData","errors"]

Posts by Mary Gathoni

Common MySQL errors and how to fix them