MySQL has gone away

[Boris Glawe]

Hello,

I have a problem with mysql.

My machine is a Fedora 9 (fully updated) on an AMD Athlon XP 2800+, 3GB 
RAM. SELinux is disabled.


All user except root cannot even "use" a database. All trials to access 
a database result in a "MySQL server has gone away" error.

Below is the workflow, starting with an uninitialized mysql 
installation, and showing the creation of a new database called JPATest, 
the creation of a new user called 'jpauer' the settings of it's 
privileges an it's password. The user 'jpauer' cannot login with the 
specified password. Any trial to acces the new Database by the user 
'jpauser' resutl in the mentioned error. The user 'root' on the other 
hand can perfectly acces all databases.


Do you have any idea?

Thanks in advance

Boris



##################






Attachement: Workflow to repoduce the error:


[root at mymachine redhat]# /etc/init.d/mysqld start
MySQL-Datenbank initialisieren:  Installing MySQL system tables...
OK
Filling help tables...
OK

To start mysqld at boot time you have to copy
support-files/mysql.server to the right place for your system

PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
To do so, start the server, then issue the following commands:
/usr/bin/mysqladmin -u root password 'new-password'
/usr/bin/mysqladmin -u root -h mymachine password 'new-password'

Alternatively you can run:
/usr/bin/mysql_secure_installation

which will also give you the option of removing the test
databases and anonymous user created by default.  This is
strongly recommended for production servers.

See the manual for more instructions.

You can start the MySQL daemon with:
cd /usr ; /usr/bin/mysqld_safe &

You can test the MySQL daemon with mysql-test-run.pl
cd mysql-test ; perl mysql-test-run.pl

Please report any problems with the /usr/bin/mysqlbug script!

The latest information about MySQL is available on the web at
http://www.mysql.com
Support MySQL by buying support/licenses at http://shop.mysql.com
                                                           [  OK  ]
MySQL starten:                                             [  OK  ]
[root at mymachine mysql]# mysqladmin -u root password 'xxxxx';
[root at mymachine mysql]# mysql -u root -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 4
Server version: 5.0.51a Source distribution

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql>  create database JPATest;
Query OK, 1 row affected (0.00 sec)

mysql> use JPATest;
Database changed
mysql> grant all on JPATest.* to 'jpauser' identified by 'passwort';
Query OK, 0 rows affected (0.00 sec)

mysql> quit;
Bye
[root at mymachine mysql]# mysql -u jpauser -p
Enter password:
ERROR 1045 (28000): Access denied for user 'jpauser'@'localhost' (using 
password: YES)
[root at mymachine mysql]# mysql -u jpauser
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 6
Server version: 5.0.51a

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> use JPATest;
No connection. Trying to reconnect...
Connection id:    7
Current database: *** NONE ***

ERROR 2006 (HY000): MySQL server has gone away
mysql>