You are here: Home / Uncategorized / Create a mysql database, add a user and grant privileges

Create a mysql database, add a user and grant privileges

March 9, 2014 by ·

Login to mysql:

mysql -u root -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 44
Server version: 5.5.35-0+wheezy1 (Debian)

Create a database:

mysql> create database if not exists pydio;
Query OK, 1 row affected (0.02 sec)

Add a user:

mysql> use pydio;
Database changed

mysql> create user 'pydiousr'@'localhost' identified by 'passtext';
Query OK, 0 rows affected (0.04 sec)

mysql> grant all on pydio.* to 'pydiousr'@'localhost';
Query OK, 0 rows affected (0.02 sec)

mysql> FLUSH PRIVILEGES;
Query OK, 0 rows affected (0.00 sec)
Filed Under: Uncategorized

You are reading this post on Joel G Mathew’s tech blog. Joel's personal blog is the Eyrie, hosted here.