I'm following a 'Building your first dynamic website' tutorial
for which all Dreamweaver files are supplied, and when I get to creating a 'Recordset' and selecting the required table
the table data (which has been supplied/created) doesn't appear.
(Recordset section: http://18.104.22.168/devnet/dreamweaver/articles/first_dynamic_site_pt2_03.html)
When I click the test button I get a 'MySQL Error 1142 – SELECT command denied to user 'user'@'localhost' for table 'tablename'.
However when I click the 'define' button, the connections for the site dialogue box appears and when I edit the table and test it through the MySQL Connection dialogue I get a 'Connection successful' message.
I assume it's to do with permissions, of sorts?
Any guidance greatly appreciated,
Many thanks in advance...
The error is caused by the user name for the database not having the permissions set correctly.
Log into your mysql database admin program using the master user, user name and password and set the privileges for the user you are using in the dreamweaver connection.
Yip, that did the trick, the interface was slightly different in the tutorial and I think that's what may have thrown me.
(I've encountered a couple more issues but perhaps that should be a fresh thread.)
Many thanks, m.