PDA

View Full Version : 10.6 Server, connect to MySQL on Mac Mini Server with Sequel pro?




xper
Mar 6, 2010, 07:54 AM
Hi!

I am a complete beginner so i have no idea what is wrong here, ive tried to google it but every answer is answered by someone that skipps alot of steps because he/she asumes that everyone knows everything!

I have Sequel Pro on my iMac and wants to connect to the Mac Mini Servers MySQL but when Sequel Pro is trying to connect to the Mac Mini Server i get this message:

"MySQL said: Host 192.168.0.199 is not allowed to connect to this MySQL server"

I assume that Sequel Pro can find the server but there seems to be some privilegies issues that i dont know how to resolve!

Anyone?



angelwatt
Mar 6, 2010, 09:08 AM
One possibility is that the Mini's firewall is not allowing connections on the port MySQL is using. You should probably also look through the MySQL config file to see if it's blocking none local connections, which is a good possibility.