Troubleshooting of MySQL errors: Difference between revisions

Troubleshooting of MySQL errors (edit)

1,170 bytes removed , 12 May 2024

15,024

edits

@@ Line 289: / Line 289: @@
 ** CHARACTER SETS (aka 字元集、字符集): {{kbd | key=utf8mb4}}
 ** COLLATION (aka 定序、字元序): {{kbd | key=utf8mb4_unicode_ci}}
-== Error!: SQLSTATE[28000]: Invalid authorization specification: 1045 Access denied ==
-Message: Error!: {{kbd | key=<nowiki>SQLSTATE[28000]: Invalid authorization specification: 1045 Access denied for user 'user'@'localhost' (using password: YES)</nowiki>}}
-Solution:
-* If you executed the query{{kbd | key=INTO OUTFILE}}, you need to grant the file permission e.g. {{kbd | key=GRANT FILE ON *.* TO 'user'@'localhost';}}<ref>[https://dev.mysql.com/doc/refman/5.7/en/privileges-provided.html#priv_file MySQL :: MySQL 5.7 Reference Manual :: 6.2.1 Privileges Provided by MySQL]</ref><ref>[https://stackoverflow.com/questions/6091427/mysql-into-outfile-access-denied-but-my-user-has-all-access-and-the-fold MYSQL into outfile "access denied" - but my user has "ALL" access.. and the folder is CHMOD 777 - Stack Overflow]</ref>.
-Related issue: "Error!: SQLSTATE[HY000]: General error: 1290 The MySQL server is running with the --secure-file-priv option so it cannot execute this statement"<ref>[https://stackoverflow.com/questions/32737478/how-should-i-tackle-secure-file-priv-in-mysql database - How should I tackle --secure-file-priv in MySQL? - Stack Overflow]</ref>
 == Database and Table Operation Errors ==