I have my mysql socket at /var/mysql/mysql.sock. I have the mysql config files properly set to this location, so I can connect to mysql from the command line or other apps without having to specify the location of the socket. In the older versions of CocoaMysql I could also connect without having to specify the location of the socket, in .7b3 the connection fails unless I specify the location of the socket file, it seems to be looking for it in /tmp/mysql.sock
Seems like a bug.
thanks for the good work!
iH2
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I think the mysql config file does not work for applications that use the MySQL C API, it works just for the command line tool. The new versions of MySQL seem to use /tmp/mysql.sock as default. CocoaMySQL 0.7b3 uses the new MySQL C API so it also uses the new default location for the socket (as it also uses UTF8 as new default encoding for the connection).
I think you have to specify the socket in the login dialog (just save it in the favorites). Or you can connect to 127.0.0.1 instead of localhost then it uses the port instead of the socket (you can leave the port field blank unless you use another port than 3306).
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I have my mysql socket at /var/mysql/mysql.sock. I have the mysql config files properly set to this location, so I can connect to mysql from the command line or other apps without having to specify the location of the socket. In the older versions of CocoaMysql I could also connect without having to specify the location of the socket, in .7b3 the connection fails unless I specify the location of the socket file, it seems to be looking for it in /tmp/mysql.sock
Seems like a bug.
thanks for the good work!
iH2
I think the mysql config file does not work for applications that use the MySQL C API, it works just for the command line tool. The new versions of MySQL seem to use /tmp/mysql.sock as default. CocoaMySQL 0.7b3 uses the new MySQL C API so it also uses the new default location for the socket (as it also uses UTF8 as new default encoding for the connection).
I think you have to specify the socket in the login dialog (just save it in the favorites). Or you can connect to 127.0.0.1 instead of localhost then it uses the port instead of the socket (you can leave the port field blank unless you use another port than 3306).