Blog

MySql - How to Create a New User

MySql - How to Create a New User

Make a new user within the MySQL shell:

CREATE USER 'newuser'@'localhost' IDENTIFIED BY 'password';

replace newuser and password with the new username and password but leave 'localhost' not the servers IP as this is the host for the mysql account.

Next step is to set some permissions

GRANT ALL PRIVILEGES ON database_name.* TO 'newuser'@'localhost';

replace the * with a spercific table if you would like the user to only have access to a subset of the tables, if not leave as an * to grant them access to all tables in this database.

Drupal Core Update with Composer

Drupal 5.5.5 to Drupal 5.5.6

Using Composer to upgrade packages or libraries is fairy straight forward but updating Drupal Core with composer requires a change.

The issue lies here:

    "require": {
        ....
    },
    "replace": {
        "drupal/core": "^8.5"
    },

By Default drupal/core is inside the replace section of the composer.json file

simply move this into the require section. This will ensure that every composer update will grab the latest version.

To run the composer update simply run: