MYSQL administration

What do you guys do for mysql administration? Just use the commandline tools or is there any other tool you would recommend? I would normally use phpmyadmin, but not sure if it's a good idea to host it on my slice which is not big to begin with and not sure if it's secure.

Thanks

3 Replies

http://www.heidisql.com/

http://www.webyog.com/en/

So I install this app on my desktop and I can administer the mysql on my server?

From what I understand I need to speicfy a bind adddress ip, and mysql only takes one IP

What if I need to administer from both the remote server locally and my desktop

I use PHPMyAdmin, and thanks to Vance's suggestions here http://www.linode.com/forums/viewtopic.php?p=20074 I've been able to secure it.

Reply

Please enter an answer
Tips:

You can mention users to notify them: @username

You can use Markdown to format your question. For more examples see the Markdown Cheatsheet.

> I’m a blockquote.

I’m a blockquote.

[I'm a link] (https://www.google.com)

I'm a link

**I am bold** I am bold

*I am italicized* I am italicized

Community Code of Conduct