How to fix error in MySQL under Ubuntu 14.04?

Question

linux

Hello.
Installed MySQL server and client on Ubuntu. I log in as root in MySQL, I try to create a new user using the command: grant all privileges on *.* to 'lrngsql '@' localhost' identified by 'PASSWORD';
As a result, I catch an error: ERROR 1290 (HY000): The MySQL server is running with the --skip-grant-tables option so it cannot execute this statement
How to solve this problem?

mysql Ver 14.14 Distrib 5.5.46, for debian-linux-gnu (x86_64) using readline 6.3

Answer 1

Restart mysql it looks like you have booted with your option to reset password or login without password.
In general, in your story you lied somewhere

Answer 2

Do not start server with --skip-grant-tables option