Tuesday, March 18, 2008

How can I manage a MySQL database from windows?

MySQL Administrator (http://dev.mysql.com/downloads/administrator/) is freely available as are many other solutions including phpMyAdmin. You can also SSH into the server and control it directly. phpMyAdmin is probably the easiest to use because it runs directly on the server and does not require the creation of a new user. However phpMyAdmin has been the victim of many hackers. MySQL Administrator has a nice intuitive GUI but for security reasons I would suggest manually adding a user with only the privileges you need to manage the server.

No comments: