Thursday, July 28, 2011

Enable remote access to MySQL

In MySQL config file, such as my.cnf
- comment out skip-networking
- add bind-address = YOUR_HOST_IP
- restart mysqld
- log in to mysql from server machine
- do GRANT ALL ON DATABASE.TABLE TO USERNAME@'HOST_IP/NAME' IDENTIFIED BY 'PASSWORD'; (Quote is required.)
- on client machine log in with > mysql -u USERNAME -r PASSWORD -h YOUR_HOST_IP

P.S. If there is no config file you can copy/rename from my-*.cnf in mysql directory

Credit: How Do I Enable Remote Access To MySQL Database Server?

No comments:

Clojure has lesser typing error problems than the others well-known dynamic typing languages

Give these snippets a try. // JS function foo () {   bar(1) } # Ruby def foo   bar(1) end ; Clojure (defn foo []    (bar 1)) As yo...