Totally lost...

flyadvertising

Hello,

I am coming from the Windows world and my background is in asp, asp.net and mainly Access databases. I am trying to stretch my brain a bit and include php/MySQL in my arsenal. I have been trying for a few days to make some headway with this but have just managed to get my head way into the wall... over and over again.

Here's what I have tried so far:
- Have downloaded MySQL Admin and have been able to connect to localhost and see local dbs. Haven't been able to connect to a remote site site.

Haven't been able to make a connection to a MySQL database in DreamWeaver CS3, which is goal #1 now.

Can anyone help please?

kakki

hiya,

connect-problem:
you need to create a user, thats able to login from any computer...
see "GRANT" section in manual

GRANT ALL ON anyDB.* TO root@'%' IDENTIFIED BY 'enterPasswordHere';

i cannot help you with dreamweaqver though ...
maybe you need to add a connector-dll ( or jar ) to access mysql-databases

flyadvertising

I don't know what you mean. Sorry, I am REALLY new to this.

kakki

you need to specify, from what machine the user could connect...

root@'localhost' is different from e.g.
root@'192.168.1.1', even if thats the ip from your machine

in order to connect from any ip, you need to connect to the database locally
( because root@'localhost' ist the standard admin-user, thats shipped with mysql )
c:> mysql --user=root --host=localhost

after that, you need to create a database ( e.g. 'mytest' )

CREATE DATABASE mytest;

after that, you need to create a user, that can connect to that system
( eg. 'me' )

GRANT ALL ON mytest.* TO me@'%' IDENTIFIED BY 'mypassword';

if you create the user me@'%', that means, that you can connect to the db from any machine

after that, you can connect and use mysql normally

kakki

http://dev.mysql.com/doc/refman/4.1/en/grant.html