Gossamer Forum
Home : Products : Gossamer Links : Discussions :

Mysql connections

Quote Reply
Mysql connections
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?

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

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. =)


Gossamer Threads Inc.