Welcome to the Question2Answer Q&A. There's also a demo if you just want to try it out.
+4 votes
969 views
in Q2A Core by

Can some please share their command line for the following step?

Create a MySQL database, and a MySQL user with full permissions for that database.
If you're interested, the privileges actually needed are: CREATE, ALTER, DELETE, INSERT, SELECT, UPDATE, LOCK TABLES

 

1 Answer

+1 vote
by
by
Thanks :) The exact commands ended up being...
mysql> CREATE DATABASE qadb;
mysql> CREATE USER 'qauser'@'localhost' IDENTIFIED BY 'password';
mysql> GRANT CREATE, ALTER, DELETE, INSERT, SELECT, UPDATE, LOCK TABLES ON `qadb` . * TO 'qauser'@'localhost';
mysql> FLUSH PRIVILEGES;
...