Nighthawk: Created page with "drupal version: 8. Create a new database for your site. (Change the username and databasename.) $ mysql -u username -p -e "CREATE DATABASE '''' CHARACTER SET ut..."

2019-04-04T12:45:29Z

Created page with "drupal version: 8. Create a new database for your site. (Change the username and databasename.) $ mysql -u username -p -e "CREATE DATABASE ''<databasename>'' CHARACTER SET ut..."

New page

drupal version: 8.
Create a new database for your site. (Change the username and databasename.)
$ mysql -u username -p -e "CREATE DATABASE ''<databasename>'' CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci";

Log in and set the access database rights:

$ mysql -u username -p

At the MySQL/MariaDB prompt, create the user and set the permissions using the following command (this will create the user and grant privileges):

$ CREATE USER username@localhost IDENTIFIED BY 'password';

$ GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, INDEX, ALTER, CREATE TEMPORARY TABLES ON databasename.* TO 'username'@'localhost' IDENTIFIED BY 'password';

[[category:drupal]]
[[category:mysql]]

creating drupal database for install - Revision history

Nighthawk: Created page with "drupal version: 8. Create a new database for your site. (Change the username and databasename.) $ mysql -u username -p -e "CREATE DATABASE '''' CHARACTER SET ut..."