Skip to content
Advertisement

MySQL 8 create new user with password not working

I am using MySQL for several years and the command for the creating the new user till the MySQL 5.x version is as follow:

Recently I installed the MySQL 8. In that, this command is not working.

It is throwing following error while firing above command:

Is there any change of syntax in MySQL 8? What is the correct syntax for creating new user command in MySQL 8?

Note: I tried this syntax in MySQL 5.x versions. It is working correctly in that.

Advertisement

Answer

Try this:

User contributions licensed under: CC BY-SA
9 People found this is helpful
Advertisement