mysql> show tables;
+-----------------------+
| Tables_in_asteriskcdr |
+-----------------------+
| cdr                   |
+-----------------------+
1 row in set (0.00 sec)

mysql> GRANT ALL PRIVILEGES ON asteriskcdr.* TO 'asterisk'@'%' IDENTIFIED BY 'password';
Query OK, 0 rows affected (0.00 sec)

[global]
hostname=localhost
dbname=asteriskcdr
table=cdr
password=password
user=asterisk
port=3306
sock=/var/lib/mysql/mysql.sock


vitto*CLI> cdr mysql status
Not currently connected to a MySQL server.