A
A
Alexander Vladimirovich2019-08-30 01:01:14
MariaDB
Alexander Vladimirovich, 2019-08-30 01:01:14

Why is the request from root not being fulfilled?

Greetings!
I need to change the encoding of the table, do this

ALTER TABLE news  CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

the result is Access denied for user 'root'@'localhost' to database 'information_schema'
while requesting
ALTER DATABASE `dbname` CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci;

is executed successfully.
I execute queries on a test base as root.

Answer the question

In order to leave comments, you need to log in

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question