I can't get any MySQL user other than root to work; even anonymous fails. I can log in anonymously or using other user I create, but any command entered under that user causes error 2006:
mysql> show databases; ERROR 2006 (HY000): MySQL server has gone away No connection. Trying to reconnect... Connection id: 25 Current database: *** NONE ***
ERROR 2013 (HY000): Lost connection to MySQL server during query
I have another MySQL client open in another terminal window logged in as root, and after the MySQL error happens for the non-root user, my root user's connection is still valid and I am able to execute any command. So it doesn't appear that my server crashes.
How can I get non-root users to work?
On a potentially related note: when connecting to MySQL
I'm running:
- OS X 10.5.8 Leopard on MacBook Pro (Late 2008)
- Server version: 5.0.67 MySQL Community Server (GPL)
- Client mysql Ver 14.12 Distrib 5.0.67, for apple-darwin9.0.0b5 (i686) using readline 5.1