remote connection mysql linux

Support for the latest build of L2J Server, get help here with installations, upgrades, problems.
Do not post bugs reports here, use viewforum.php?f=77 instead.
There is no support for other server builds than the official provided by l2jserver.com
Forum rules
READ NOW: L2j Forums Rules of Conduct
Post Reply
darkzonenet
Posts: 42
Joined: Mon Oct 26, 2009 9:22 pm

remote connection mysql linux

Post by darkzonenet »

hi. I have a problem with mysql in linux. I can not connect to the database using remote. I read many guides but they did not work. Do you know what should i change to enable remote connections? Regards
User avatar
Sirpaypi
Posts: 108
Joined: Mon May 18, 2009 11:51 pm
Location: Moяocco.

Re: remote connection mysql linux

Post by Sirpaypi »

darkzonenet wrote:hi. I have a problem with mysql in linux. I can not connect to the database using remote. I read many guides but they did not work. Do you know what should i change to enable remote connections? Regards
Where's the bug ?
Please infos !!
Saying that Java is nice because it works on all OSes is like saying that anal sex is nice because it works on all genders.
darkzonenet
Posts: 42
Joined: Mon Oct 26, 2009 9:22 pm

Re: remote connection mysql linux

Post by darkzonenet »

i can not connect. i am adding ip and pass in navicat and it doesn't connect to the dedicated's database. in windows server you can choose to eanble remote connections in mysql. in linux there is not an option like this as it is a package
User avatar
Sirpaypi
Posts: 108
Joined: Mon May 18, 2009 11:51 pm
Location: Moяocco.

Re: remote connection mysql linux

Post by Sirpaypi »

darkzonenet wrote:i can not connect. i am adding ip and pass in navicat and it doesn't connect to the dedicated's database. in windows server you can choose to eanble remote connections in mysql. in linux there is not an option like this as it is a package
Of coursse there's a lot of options and its the first time i see like this problem, and be sure if you have a right configuration of your config files it will be ok...
Saying that Java is nice because it works on all OSes is like saying that anal sex is nice because it works on all genders.
darkzonenet
Posts: 42
Joined: Mon Oct 26, 2009 9:22 pm

Re: remote connection mysql linux

Post by darkzonenet »

if you istall the mysql in linux you will not be able to log in with a remote to the database. It is from default. Thats why i am asking for a solution
User avatar
qwerty13
Posts: 640
Joined: Mon Feb 02, 2009 9:57 am
Location: Europe
Contact:

Re: remote connection mysql linux

Post by qwerty13 »

http://techpad.co.uk/content.php?sid=89

And check your my.cnf:

Code: Select all

#bind-address           = 127.0.0.1
For remote connections it must be with "#"
Post Reply