quando tento configurar o mysql no ubuntu da este erro

Arthurgomesp
(usa XUbuntu)

Enviado em 05/05/2024 - 16:58h

quando tento configurar o mysql no ubuntu da este erro

mysql> create user 'root'@'localhost' identifield by 'root';

ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'identifield by 'root'' at line 1

alguem sabe como corrigir ?

alexabolada
(usa Debian)

Enviado em 05/05/2024 - 16:58h

{
"error": {
"message": "We could not parse the JSON body of your request. (HINT: This likely means you aren't using your HTTP library correctly. The OpenAI API expects a JSON payload, but what was sent was not valid JSON. If you have trouble figuring out how to fix this, please contact us through our help center at help.openai.com.)",
"type": "invalid_request_error",
"param": null,
"code": null
}
}

leandropscardua
(usa Ubuntu)

Enviado em 05/05/2024 - 21:11h

identifield by 'root';
O correto é
Identified by 'root ;