Forums

I cant use this command : mysql> ALTER DATABASE fbDB CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

The above command throws error:

ERROR 1044 (42000): Access denied for user 'eyal360'@'%' to database 'fbDB'

I want to change the database and table's encoding to utf8mb4 because the database throws error like this:

django.db.utils.OperationalError: (1366, "Incorrect string value: '\\xF0\\x9F\\x93\\xA2 \\xD7...' for column 'post_detail' at row 1")

Beloved premium user eyal360 | 38 posts | Feb. 2, 2022, 5:43 p.m. | permalink

Your database is not called 'fbDB'. The names of your databases are shown on your Databases page.

Staff glenn | 9498 posts | PythonAnywhere staff | Feb. 2, 2022, 6:18 p.m. | permalink

okay, yes and sorry for the silly mistake

Beloved premium user eyal360 | 38 posts | Feb. 3, 2022, 4:51 a.m. | permalink