MySQL server has gone away (4.1.15)
Posted: Wed Nov 23, 2005 11:29 am
Hi All,
I use: Mysql 4.1.15, PHP 4.4.1, FC3 from ART.
I did an upgrade from ART from Mysql 3.23 to 4.1.15 on fresh box with Plesk 7.5.4. Im getting problems with "MySQL server has gone away" and ~ "MySQL lost connection during query" while connecting and doing queries from regular users, added from Plesk control panel. For example:
[root@hostname ~]# mysql -u REGULAR_USER -p PASSWORD DATABASE_OF_THIS_REGULAR_USER -e 'show tables'
ERROR 2006 (HY000) at line 1: MySQL server has gone away
and with all other queries...!
When i tried to do it with admin user (admin user from Plesk is also root of mysql of course), all works really fine!
My admin password was not changed since box and plesk installation even after upgrade from ART. I thought that is a problem of famous old_passwords but it is not.
I dont know what to do
Please advice me ...
Peter
I use: Mysql 4.1.15, PHP 4.4.1, FC3 from ART.
I did an upgrade from ART from Mysql 3.23 to 4.1.15 on fresh box with Plesk 7.5.4. Im getting problems with "MySQL server has gone away" and ~ "MySQL lost connection during query" while connecting and doing queries from regular users, added from Plesk control panel. For example:
[root@hostname ~]# mysql -u REGULAR_USER -p PASSWORD DATABASE_OF_THIS_REGULAR_USER -e 'show tables'
ERROR 2006 (HY000) at line 1: MySQL server has gone away
and with all other queries...!
When i tried to do it with admin user (admin user from Plesk is also root of mysql of course), all works really fine!
My admin password was not changed since box and plesk installation even after upgrade from ART. I thought that is a problem of famous old_passwords but it is not.
I dont know what to do
Please advice me ...Peter