Hi, i have created a mysql database. I have included some stored procedures. I have also created privileges and grants for the user on all tables, columns, rows, procedures etc.
The table where i store the privileges for the stored procedures is procs_priv. I have granted all privileges to the user on the localhost. However, when i connect to the mysql database on the localhost dreamweaver finds all of the tables and their columns in the database section but under the section 'stored procedures' it says none, even though we have a stored procedure in the database, have set up the procedure privileges in the procs_priv table for the user and the stored procedure I am lost, has anyone experienced anything like this before? or be able to provide any suggesstions or advice. or does anyone use mysql as their database and could explain to me the steps you need to take to allow a user to access the stored procedures and to allow them to show in dreamweaver just so i can make sure what i have done is correct thanks ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:257326 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
