<< More Tips   |   Added On: 28/05/18   |    Category:    |    Number of Views: 217

Create a new user in MariaDB and GRANT ALL privileges (Part 2)

Part 1: Install MariaDB in Ubuntu
Part 2: Create a new user

If you have been following our MariaDB tutorials in Part 1 we installed MariaDB and logged in as root.

In Part 2 we create a new user and assign that new user all privileges, enabling the user to create, insert, update, delete and query databases

In the terminal enter the following command.
The command creates a new user name mycomputertips@localhost with the password 12345

CREATE USER mycomputertips@localhost IDENTIFIED BY '12345';


Now we want to give the user mycomputer@localhost all the privileges
In the terminal enter the following command
GRANT ALL PRIVILEGES ON * . * TO mycomputertips@localhost;


Now we need to exit MariaDB. Enter exit in the terminal
exit


Then login as the new user remembering to enter your password
mysql -u mycomputertips -p


If everything went as planned you should have logged in as mycomputertips and be at the MariaDB prompt.

Linux Services

Buy Linux CDs, DVDs, USB Flash Drives from OSDisc.com

Buy Linux CDs, DVDs, USB Flash Drives from OSDisc.com

Run Windows software on Linux

Run Windows software on Linux with Crossover Office