3.1 Configuring MySQL

Before Doodah can store information in the database it needs to be granted permissions by MySQL. This has to be done by the administrator of the MySQL server on the computer where the MP3s are going to be stored. If this administrator is you, do the following:

1. Start the MySQL monitor with the root account and MySQL permissions database. eg:

   > mysql -u root -p mysql Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 134 to server version: 3.22.27 Type 'help' for help. mysql>

2. Create a user with no permissions.

   mysql> insert into user (Host, User, Password) -> values ('%', 'doodah', password('diddums')); Query OK, 1 row affected (0.07 sec)

3. Grant all permissions to one database by the new user.

   mysql> insert into db values ('localhost', 'doodah', 'doodah', -> 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y'); Query OK, 1 row affected (0.03 sec)

4. Flush the privileges.

   mysql> flush privileges; Query OK, 0 rows affected (0.09 sec)

Now that you have granted permissions to the MP3 database, you can use doodaha to create it.