![mysql](https://skayal.com/wp-content/uploads/2020/02/kisspng-mysql-database-web-development-computer-icons-mysql-5b2cc2f3399385.0469886115296601472359.png)
09
Jul
WordPress SQL Commands- create database, username with privileges
Comments
Log in to MySQL from terminal
mysql -u root -p
Run MySQL commands
CREATE database_name;
CREATE USER 'some_user'@'localhost' IDENTIFIED WITH mysql_native_password BY ‘your_password’;
GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, INDEX, ALTER, CREATE TEMPORARY TABLES, LOCK TABLES, EXECUTE, CREATE VIEW, SHOW VIEW, CREATE ROUTINE, ALTER ROUTINE, TRIGGER, REFERENCES ON database_name.* TO 'some_user'@'localhost';
Edit above privileges as needed