Jeffrey L. Roberts

MySQL 8 – Grant User

mysql> CREATE USER 'user'@'host' IDENTIFIED WITH mysql_native_password BY 'password';
mysql> GRANT ALL PRIVILEGES ON *.* TO 'user'@'host' WITH GRANT OPTION;

Leave a Reply

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