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)
Joel G Mathew, known in tech circles by the pseudonym Droidzone, is an opensource and programming enthusiast.
His favorite pastime is grappling with GNU compilers, discovering newer Linux secrets, writing scripts, hacking roms, and programs (nothing illegal), reading, blogging. and testing out the latest gadgets.
When away from the tech world, Dr Joel G. Mathew is a practising ENT Surgeon, busy with surgeries and clinical practise.