4 ms·
Both you and Kijin above have strongly suggested not using PhpMyAdmin. Are there better alternatives for managing my mysql databases?
by brador 15y ago
Both you and Kijin above have strongly suggested not using PhpMyAdmin.
Are there better alternatives for managing my mysql databases?
- FuzzyDunlop 15y agoThe command line? You don't want to make any of your administration tools on your production server, or any server for that matter, visible to the world. Your options thus are: 1. Don't use them in the first place 2. Restrict who can access them (eg. IP whitelist) and how (eg. VPN, on the local network) It's not really about what you use, but what steps you take to make sure no one else can use it against you.
- ludwigvan 15y agoI use the command line too, but MySQL Workbench using SSH tunnelling might be a good solution: http://dev.mysql.com/doc/workbench/en/wb-manage-db-connections-ssh.html http://dev.mysql.com/doc/workbench/en/wb-manage-db-connectio...
- deleted 15y ago[deleted]
- mzarate06 15y agoNavicat is a good option, far better than PHPMyAdmin imo. One thing to be aware of though - when dumping a database, it doesn't use extended inserts when creating a backup file. This can have a ridiculous impact on restore time. For example, a 500MB database I'm working with takes about 10 minutes to restore locally via extended inserts. It takes over an hour w/out them.