Connection problem to a MySQL database
Posted on 2007-10-13
I am not a MySQL programmer and try to do any work through the Query Browser and Administrator.
In my site's control Panel Plesk I created a database called ACCFMCA with the user name FWB and say a password of pwd.
I then made a simple table of 3 fields called items.
I can connect to the database with MySQL Query Browser and In MySQL Administrator it shows FWB connected. When I go to User Administration I get the error - "Could notfetch user names. The following error occurred. SELECT command denied to user FWB@184.108.40.206 for table 'user' (1142). Under Server Connections it shows user FWB as active.
This appears to be a permission problem, but I can't see where to get at permissions when there is no user.
This problem ends up not allowing me to connect to the database from Dreamweaver.
How do I fix this?