MySQL 8: Create user and grant all privileges on database

by Dillon -

Learn how to create a new user in MySQL 8 and grant all privileges on a database.

MySQL 8 introduced performance and security updates. Released in April 2018, MySQL 8 was the first major release since MySQL 5.7 in 2015. With MySQL 5.7 end of support looming in October 2023, it’s a good idea to start upgrade your databases where possible.

Create a new user in MySQL 8

First, create the new user in MySQL 8 using the CREATE USER command like so:

CREATE USER 'username'@'localhost' IDENTIFIED BY 'STR0NG!PAssW0rD';
Create user in MySQL 8

Grant all privileges in MySQL 8

Next, grant privileges to the user in MySQL 8 using the GRANT command like so:

GRANT ALL ON database-name.* TO 'username'@'localhost';
Dillon Smart

šŸ‘‹ Hey, I'm Dillon!

Iā€™m a Full-Stack developer in the UK, building websites and applications for around 12 years, landing my first full-time job as a developer in 2015.

Feel free to reach out on Twitter!

Comment

This site uses Akismet to reduce spam. Learn how your comment data is processed.