I'm running command
grant all privileges on *.* to 'username'@localhost identified by 'strong password';
, but I get the error:
>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 'identified by 'strong password'' at line 1.
I can add a user separately and then assign it the privileges on the database, but I'd like to add the user and assign privileges in a single command. MySQL version:
| version | 8.0.23-0ubuntu0.20.04.1 |
| version_comment | (Ubuntu) |
| version_compile_machine | x86_64 |
| version_compile_os | Linux |
| version_compile_zlib | 1.2.11 |
Asked by Sajid Maqsood
(39 rep)
Jun 13, 2021, 07:31 PM
Last activity: Jun 13, 2021, 10:00 PM
Last activity: Jun 13, 2021, 10:00 PM