MySQL Connecting Remotely
Information on the internet about remotely to the MySQL database is quite confusing. All over the place you may find information about bind-address configuraiton in the my.ini file. Even I wrote about it recentlyHowever, after setting bind-address option it will no longer be possible to connect to MySQL database from localhost.
The guys from freenode IRC server #mysql channel clarified the situation:
remove bind-address= and skip-networking from my.cnf and grant permission to the external 'user'@'host' and remove any firewall rules blocking port 3306 and make sure no overrides on the mysqld commandline. See http://hashmysql.org/index.php?title=Remote_Clients_Cannot_Connect
bind-address is exclusive, not inclusive, it limits mysql server to what interface to listen on for incoming connections
Other Way to Import Data to MySQL
What to do, if SQL file for some reason has an error in the middle and it is big enough to have problems opening it with text editor. If you can live without that small piece of data, which causes you problems, then here a way to import all valid data from SQL file to the database.
Imagine, you have
Accessing MySQL Remotely
By default, you can access MySQL only from the localhost. In order to access it from the network, you have to modify your my.cfg or my.ini:
- Remove or comment out
skip-networkingoption (by default in latest versions of MySQL this version is not present in configuration file) - add (or modify)
bind-addresswith ip of your machine on which MySQL is running
Haskell and MySQL
In this post I will describe how to connect and use MySQL with Haskell.