This is a read-only copy of the MariaDB Knowledgebase generated on 2025-04-23. For the latest, interactive version please visit https://mariadb.com/kb/.

Created: 1 year, 3 months ago
Modified: 1 month, 3 weeks ago
Type: article
Status: active
License: CC BY-SA / Gnu FDL

Attachments

No attachments exist

Error 1044: Access denied for user

Error Code	SQLSTATE	Error	Description
1044	42000	ER_DBACCESS_DENIED_ERROR	Access denied for user '%s'@'%s' to database '%s'

Possible Causes and Solutions

The user is trying to access a database/schema they do not have access to. See Troubleshooting Connection Issues for more, as well as GRANT for details on setting permissions.

↑ MariaDB Error Codes 1000 to 1099 ↑
Error 1000: hashchk
Error 1001: isamchk
Error 1002: NO
Error 1003: YES
Error 1004: Can't create file
Error 1005: Can't create table
Error 1006: Can't create database
Error 1007: Can't create database, database exists
Error 1008: Can't drop database; database doesn't exist
Error 1009: Error dropping database (can't delete)
Error 1010: Error dropping database (can't rmdir)
Error 1011: Error on delete of
Error 1012: Can't read record in system table
Error 1013: Can't get status of
Error 1014: Can't get working directory
Error 1015: Can't lock file
Error 1016: Can't open file
Error 1017: Can't find file
Error 1018: Can't read dir of
Error 1019: Can't change dir to
Error 1020: Record has changed since last read in table
Error 1021: Disk full (%s); waiting for someone to free some space
Error 1022: Can't write; duplicate key in table
Error 1023: Error on close of
Error 1024: Error reading file
Error 1025: Error on rename of
Error 1026: Error writing file
Error 1027: is locked against change
Error 1028: Sort aborted
Error 1029: View doesn't exist for
Error 1030: Got error from storage engine
Error 1031: Table storage engine doesn't have this option
Error 1032: Can't find record in
Error 1033: Incorrect information in file
Error 1034: Incorrect key file for table; try to repair it
Error 1035: Old key file for table; repair it!
Error 1036: Table is read only
Error 1037: Out of memory; restart server and try again
Error 1038: Out of sort memory, consider increasing server sort buffer size
Error 1039: Unexpected EOF found when reading file
Error 1040: Too many connections
Error 1041: Out of memory
Error 1042: Can't get hostname for your address
Error 1043: Bad handshake
Error 1044: Access denied for user
Error 1045: Access denied for user (using password)
Error 1046: No database selected
Error 1047: Unknown command
Error 1048: Column cannot be null
Error 1049: Unknown database
Error 1050: Table already exists
Error 1051: Unknown table
Error 1052: Column is ambiguous
Error 1053: Server shutdown in progress
Error 1054: Unknown column
Error 1055: isn't in GROUP BY
Error 1056: Can't group on
Error 1057: Statement has sum functions and columns in same statement
Error 1058: Column count doesn't match value count
Error 1059: Identifier name is too long
Error 1060: Duplicate column name
Error 1061: Duplicate key name
Error 1062: Duplicate entry for key
Error 1063: Incorrect column specifier for column
Error 1064: near at line
Error 1065: Query was empty
Error 1066: Not unique table/alias
Error 1067: Invalid default value for
Error 1068: Multiple primary key defined
Error 1069: Too many keys specified; max keys allowed
Error 1070: Too many key parts specified; max parts allowed
Error 1071: Specified key was too long; max key length is
Error 1072: Key column doesn't exist in table
Error 1073: BLOB column can't be used in key specification with the used table type
Error 1074: Column length too big for column; use BLOB or TEXT instead
Error 1075: Incorrect table definition; there can be only one auto column and it must be defined as a key
Error 1076: ready for connections
Error 1077: Normal shutdown
Error 1078: Got signal. Aborting!
Error 1079: Shutdown complete
Error 1080: Forcing close of thread
Error 1081: Can't create IP socket
Error 1082: Table has no index like the one used in CREATE INDEX; recreate the table
Error 1083: Field separator argument is not what is expected; check the manual
Error 1084: You can't use fixed rowlength with BLOBs; please use 'fields terminated by'
Error 1085: The file must be in the database directory or be readable by all
Error 1086: File already exists
Error 1087: Records Deleted Skipped Warnings
Error 1088: Records Duplicates
Error 1089: Incorrect prefix key; the used key part isn't a string, the used length is longer than the key part, or the storage engine doesn't support unique prefix keys
Error 1090: You can't delete all columns with ALTER TABLE; use DROP TABLE instead
Error 1091: Can't DROP; check that column/key exists
Error 1092: Records Duplicates Warnings
Error 1093: You can't specify target table for update in FROM clause
Error 1094: Unknown thread id
Error 1095: You are not owner of thread
Error 1096: No tables used
Error 1097: Too many strings for column and SET
Error 1098: Can't generate a unique log-filename
Error 1099: Table was locked with a READ lock and can't be updated

Error 1044: Access denied for user

Possible Causes and Solutions

See Also

Products

Solutions

Resources

Company

Pricing

Download MariaDB