add tag
Anonymous 2419
/* Create USER */
CREATE USER
  'student'@'localhost' 
IDENTIFIED WITH 
  mysql_native_password
BY 
  'student5Password!';

/* Create DATABASE */
CREATE DATABASE studentshop;

/* Grant the PRIVILEGES to the created USER */
GRANT ALL ON studentshop.* TO 'student'@'localhost';
Top Answer
Jack Douglas
There are some things we don’t grant permission on for security reasons.

This room is for discussion about this question.

Once logged in you can direct comments to any contributor here.

Enter question or answer id or url (and optionally further answer ids/urls from the same question) from

Separate each id/url with a space. No need to list your own answers; they will be imported automatically.