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)