MySql client for Linux – Super User

The best answers to the question “MySql client for Linux” in the category Super User. QUESTION: What MySql client are you using for Linux. I currently use PhpMyAdmin and the Mysql Query Browser but I would like something similar to Toad or HeidiSql that I use on windows. One with SQL code completion. ANSWER: Tora … Read more

Auto-restart mysql when it dies – Super User

The best answers to the question “Auto-restart mysql when it dies” in the category Super User. QUESTION: I have a rackspace server that I have been renting to run my personal projects upon. Since I am cheap, it has 256Mb of RAM and honestly can’t handle alot. Every once in a while, when there is … Read more

phpmyadmin symlinks error after ubuntu upgrade – Super User

The best answers to the question “phpmyadmin symlinks error after ubuntu upgrade” in the category Super User. QUESTION: After the upgrade of my ubuntu server to 13.04 my phpmyadmin is no longer reachable. the browser reports 500 (internal server error) and in the error.log it says: PHP Fatal error: require_once(): Failed opening required ‘./libraries/php-gettext/gettext.inc’ (include_path=”.”) … Read more

View existing indexes using phpMyAdmin – Super User

The best answers to the question “View existing indexes using phpMyAdmin” in the category Super User. QUESTION: Using phpMyAdmin, is it possible to view existing indexes on a table? If so,how? One of my tables should have an unique index with two keys, and I want to confirm it exists. ANSWER: At the structure tab, … Read more

MySQL Workbench unable to restore workspace – Super User

The best answers to the question “MySQL Workbench unable to restore workspace” in the category Super User. QUESTION: Whenever I restart MySQL Workbench I get the following error: That error doesn’t make any sense to me. I’m able to open E:\Users\user_name\AppData\Roaming\MySQL in Explorer, so if I’m able to open that then E:\Users\user_name\AppData\Roaming\MySQL\..\ is clearly able … Read more

How to disable secure-file-priv MySQL Ubuntu – Super User

The best answers to the question “How to disable secure-file-priv MySQL Ubuntu” in the category Super User. QUESTION: Guys I have an application that use SELECT OUTFILE to be used as cache for another application, so, it outputs straight to /dev/shm/some/folder. As it runs on a background server, I have no issue disabling all mysql … Read more