Gossamer Forum
Home : Products : Gossamer Links : Discussions :

Mysql connections

Quote Reply
Mysql connections
Hello,
My new Mysql database is setup via unix sockets, question is will I be able to connect remotely via tcp/ip automatically? With windows mysql the database first used pipes then tcp/ip to make the connection. Can mysql on linux have it both ways?
Thanks,
Scooter

Quote Reply
Re: [scooter] Mysql connections In reply to
Hi,

Yes, as long as you setup mysql permission systems it can work both ways. i.e.:

GRANT ALL ON database.* TO user@"remoteip" IDENTIFIED BY 'password'

and you will now be able to connect to mysql (assuming no firewalls) from a remote server. It's great if you use MyODBC, as then you can open your mysql database in Access. =)

Cheers,

Alex
--
Gossamer Threads Inc.