CocoaMYSQL

Tue 2005/09/20 01:56 JST
 1
 in Mac
458 views
CocoaMYSQL

Mysql Control Center was the tool that I used on Windows to manage my MSQL DB's but it had a Major drawback - as with most things running on Windows - it had no support for UTF-8. CocoaMYSQL is one of those tools which after a while of using makes you wonder how on earth did you manage to survive without it up until now.
CocoaMYSQL has not been updated for about 2 years but don't let that put you off - it is packed with a ton of coolsome features such as the ability to import and export MYSQL dumps, and do pretty much anything you like with tables and DB's.
I use CocoaMYSQL to manage my blogg and pretty much the whole site - its the best thing since sliced cucumber.
Now connecting to your localhost is easy, but what if you want to connect to your remote server? Well first off you need to do the following after you have SSH'ed into your server.
GRANT ALL ON *.* TO username@'%' IDENTIFIED BY 'password' WITH GRANT OPTION; ->FLUSH PRIVILEGES
Replace the username and password. Then add the following to your my.cnf file on your server...
bind-address = 127.0.0.1port = XXXX
XXXX is an unused port of your choosing - this is the port that you will use in your connection settings.

If you are interested in reading about life in Japan, seeing photos taken daily around Tokyo, like Japanese subculture (anime, manga, figures, Dollfies) then you may want to start delving into the Japan or Figure categories for a start or have a gander at all photo articles.

If you don't have much time now, maybe subscribe to the RSS Feed, Twitter Feed or join the other readers in the FaceBook Page.
Alternatively, you may want to read more about the site.
If you are a regular reader then this message will probably annoy you each time - hide it forever.

This item was posted in the Mac category. You can see more of everything else or subscribe via RSS instead.
-Japan Probe - News from Japan (Subscribe)
-Akihabara News – Gadgetry from Japan (Subscribe)

Currently being read