How to connect Mysql in Dreamweaver

[colmem]

I have make a test in my computer, i can successful use insert query update mysql table in my localhost, I have created the mysql in MySQL Management in DirectAdmin. But I can not connect host1free mysql in dreamweaver. Is my setting incorrect.
i create the mysql :

server name: i put my database name that creat in mysql management
server location: localhost/box5.host1free.com
username: i put my user name that creat in mysql management (colmem_admin)
password: i put my password that creat in mysql management

Then i cannot chose the table for test connection in dreamweaver, it said connect error in colmem_admin@localhost.

In php programme, i also try connect but still not work too.

mysql_connect("localhost","colmem_admin","mypassword");

[gamezone]

I think you can't connect with Dreamweaver because it's a local mysql server (localhost).

[colmem]

Thanks for reply.

Then I would like to know can I insert data and get data by not using phpadmin?

[Modestas]

You can use PHP scripts to insert data in MySQL database tables, for example, PHP MySQL Insert Into

[colmem]

thank you.
That's work!