How To Create a New User in MySQL 8
November 27th, 2020
Warning: This post is 3 years old. Some of this information may be out of date.
The way new users are created on MySQL changed with version 8.
In previous versions you could create a new user with the
# MySQL 5.7 GRANT ALL ON my_database.* TO 'user'@'127.0.0.1' IDENTIFIED BY 'its-a_secret'
Here's how to create a new user in MySQL 8:
# MySQL 8 CREATE USER 'user'@'127.0.0.1' IDENTIFIED BY 'its-a_secret'; GRANT ALL ON my_database.* TO 'user'@'127.0.0.1';
Previous →Solved: Installing composer V1 with Ansible