Click to See Complete Forum and Search --> : [Resolved] Dreamweaver 6.1 connects to mysql but does not show tables


machk
07-10-2003, 11:44 AM
:confused:

Hello

I am new to Mysql and php. I have installed on solaris 2.8 [sparc]10/02 ,mysql ver3.23.53, apache ver 1.3 and compiled php ver 4.3.2. Everything appears to be working as it should. I am able to create databases with tables and data. I used the test.php from dreamweaver help to confirm that php is up and running.

I am using dreamweaver MX ver 6.1 with the updater file build 6.1.1842.0

I connect to the webserver via lan using dreamweaver on my laptop. The database connection is made with out any issues. infact I can see all of my databases. I choose a specific db to use and the connection is made. However, although I am connected I can not see any of the tables that I have created. I have been searching threads for help on this, but there seems to be no solution.

Any help and or suggestions would be appreciated.

tks
A

machk
07-10-2003, 12:05 PM
:o

Sorry to waste everyones time. I thought I had created a user for mysql, but it was defaulting to root user. When I used the root user to connect the db all my tables showed up.

A

vladislav
08-01-2003, 10:48 AM
Look SQL manual for GRANT keyword
(http://www.mysql.com/doc/en/GRANT.html)

GRANT ALL ON <YourTable> TO <LoginFromDWScript>