ERROR : MySQL server has gone away while running query

Posted by Rashmi Nama on Server Fault See other posts from Server Fault or by Rashmi Nama
Published on 2014-08-21T07:04:50Z Indexed on 2014/08/21 10:22 UTC
Read the original article Hit count: 235

Filed under:

ubuntu-12.04

I am using ubuntu 12.04 version. I am connecting properly to MariaDB from command prompt,I have a database named Dealer and have some tables in it but when i running any query, it gives an error.My steps as follow:

mysql -uroot -proot
use dealer;
select * from dealer_outlet limit 1;

now error occours

ERROR 2006 (HY000): MySQL server has gone away No connection. Trying to reconnect... Connection id: 3 Current database: dealer

ERROR 2006 (HY000): MySQL server has gone away No connection. Trying to reconnect... ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (111 "Connection refused") ERROR: Can't connect to the server

Related posts about ubuntu-12.04

How to Upgrade Ubuntu 12.04.2 to Ubuntu 12.04.3

as seen on Ask Ubuntu - Search for 'Ask Ubuntu'
I am currently using Ubuntu 12.04.2 32bit. I installed it using LiveCD. Tomorrow, 23rd August 2013,Ubuntu 12.04.3 is released. I want to upgrade from Ubuntu 12.04.2 to Ubuntu 12.04.3 without using any LiveCD. Is it possible? If so please suggest me how can I do. Actually while using Ubuntu 12.04… >>> More
Download the ‘Getting Started with Ubuntu 12.04' Manual for Free

as seen on How to geek - Search for 'How to geek'
If you or someone you know is new to Ubuntu, then the release of this free 143 page manual for the latest LTS edition of Ubuntu is the perfect download. The manual will take you from installing Ubuntu 12.04 all the way through to trouble-shooting the system if you run into problems. On the downloads… >>> More
Ubuntu 12.04.1 Radeon 9550 stuck with 640x480, works in Geexbox

as seen on Ask Ubuntu - Search for 'Ask Ubuntu'
I am a complete new user trying to set up Ubuntu on an old desktop. It has an AGP Radeon 9550 graphics card. I am running Ubuntu from a USB drive with persistence as the PC currently has no hard drive I seem to be stuck in 640*480 mode. The desktop itself is larger, but the monitor display is stuck… >>> More
Ubuntu 12.04.1 desktop monitor Out of Range

as seen on Ask Ubuntu - Search for 'Ask Ubuntu'
I know this question has been asked many-a-times, but I cant seem to get a definate answer to it. I am running Ubuntu 12.04.1 LTS on my HP Pavillion a6 109n PC. Processor is a AMD Athlon 64 x2 Dual core Processor. Everytime I boot up my desktop, it runs BIOS, then it boots up Linux. After about… >>> More
Key-Based SSH Permission denied (publickey) Ubuntu 12-04

as seen on Server Fault - Search for 'Server Fault'
I have configured sshd to accept key-based ssh logins with LogLevel on DEBUG, and uploaded my public key to ~/.ssh.authorized_keys, where permissions are set as: 700 ~/.ssh 600 ~/.ssh/authorized_keys From root, I can su - USERNAME. From the client I get Permission denied (publicly). From the server… >>> More

Developer IT