F
F
Forque2015-08-29 11:41:22
MySQL
Forque, 2015-08-29 11:41:22

ERROR 1044 (42000): Access denied for user 'root'@'localhost' to database. How to cope?

Googled in my opinion deeply and dofiga - did not help.
Error after
mysql> CREATE DATABASE ttdb;
or under linux c gui advise something to create.
just in case:
mysql> show grants for 'root'@'localhost';
+------------------------------------------------- ------------------------+
| Grants for [email protected] |
+------------------------------------------------- ------------------------+
| GRANT USAGE ON *.* TO 'root'@'localhost' IDENTIFIED BY PASSWORD |
| GRANT ALL PRIVILEGES ON `testdb`.* TO 'root'@'localhost' |
+------------------------------------------------- ------------------------+

Answer the question

In order to leave comments, you need to log in

1 answer(s)
L
Lebnik, 2020-06-19
@Lebnik

Try to comment string "sql-mode=..." in file my.cnf and than restart mysql.

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question