search

How to create a mysql database, user and grant permissions


mysql -u root -p 

mysql> CREATE DATABASE <name>;

mysql> CREATE USER 'user'@'localhost' IDENTIFIED BY 'password'

mysql> GRANT ALL PRIVILAGES ON dbname.* TO 'user'@'localhost'

https://www.digitalocean.com/community/tutorials/how-to-create-a-new-user-and-grant-permissions-in-mysql

Leave a Reply

Your email address will not be published. Required fields are marked *

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

close
Categories

Hi, guest!

settings