[Refdb-users] Access denied - running out of ideas...

[Denis C. <dc...@pi...>]

Hi All,

I have successfully set up refdb on a box at home, but am having great
trouble getting it set up on my office box (Debian ppc - woody).  I keep
getting "could not connect to database server" messages.  I've tried
commenting out "skip networking" in the mysql config file, have allowed
remote admin in the refdb config file.  I've tried a variety of access
permissions in mysql. My current mysql.db table is listed below.

I feel like I'm missing something very simple!  Love the program though
and am looking forward to getting it going.

Thanks,

Denis Crowdy



| Host      | Db       | User    | Select_priv | Insert_priv |
Update_priv | Delete_priv | Create_priv | Drop_priv | Grant_priv |
References_priv | Index_priv | Alter_priv |
+-----------+----------+---------+-------------+-------------+-------------+-------------+-------------+-----------+------------+-----------------+------------+------------+
| %         | test     |         | Y           | Y           | Y
| Y           | Y           | Y         | N          | Y               |
Y          | Y          |
| %         | test\_%  |         | Y           | Y           | Y
| Y           | Y           | Y         | N          | Y               |
Y          | Y          |
| %         | refdb    | dcrowdy | Y           | Y           | Y
| Y           | Y           | Y         | Y          | Y               |
Y          | Y          |
| localhost | refdb    | dcrowdy | Y           | Y           | Y
| Y           | Y           | Y         | Y          | Y               |
Y          | Y          |
| localhost | refdbvar | dcrowdy | Y           | Y           | Y
| Y           | Y           | Y         | Y          | Y               |
Y          | Y          |
| %         | refdbvar | dcrowdy | Y           | Y           | Y
| Y           | Y           | Y         | Y          | Y               |
Y          | Y          |
| localhost | refdbvar | root    | Y           | Y           | Y
| Y           | Y           | Y         | Y          | Y               |
Y          | Y          |
| localhost | refdb    | root    | Y           | Y           | Y
| Y           | Y           | Y         | Y          | Y               |
Y          | Y          |
+-----------+----------+---------+-------------+-------------+-------------+-------------+-------------+-----------+------------+-----------------+------------+------------+

-- 
Department for Contemporary Music Studies
Macquarie University
NSW 2109 Australia, ph: +61 (0)2 9850 6787, fax: 9850 6593