Mysql Archives - Page 3 of 4 - InstaCarma Outsourced Web Hosting Support

Error #1153 – Got a packet bigger than 'max_allowed_packet' bytes

by Aromal Rajagopal | Jul 2, 2009 | Quick fixes, Technical | 0 comments

Issue : While trying to import a database via PhpMyAdmin , following error occurred : #1153 – Got a packet bigger than ‘max_allowed_packet’ bytes Fix: Get into the file /etc/my.cnf Change the following to the required value : ================...

Changing MySQL user password via shell

by Aromal Rajagopal | Jun 24, 2009 | Quick fixes, Technical | 0 comments

Issue : To list the mysql users and change the password for a particular user via shell. Solution : You need to be logged in as ‘root’ in order to do this. To list the users: # mysql -u root -p mysql> SELECT User from mysql.user; To change the password : #...

ERROR 2002 (HY000): Can’t connect to local MySQL server

by Aromal Rajagopal | Jun 3, 2009 | Quick fixes, Technical | 0 comments

Issue : After upgrading from MySQL4.1 to MySQL5 on a cPanel server, MySQL is failing to start with the error: ERROR 2002 (HY000): Can’t connect to local MyS QL server through socket ‘/var/lib/mysql/mysql.sock’ (2) Fix : To fix this, run the following command: mv...

Tutorial on clearing Disk Space on a Server

by Aromal Rajagopal | May 24, 2009 | Articles and tutorials, Popular Posts, Quick fixes, Technical | 0 comments

Running out of disk space is a very common issue. Be it a web-hosting service provider or the end-user. I wanted to share a few tips that the technical support staff at InstaCarma use to resolve disk-space issues on a cPanel server. As we all know, there are...

PhpMyadmin errror "#2002

by Aromal Rajagopal | May 9, 2009 | Quick fixes, Technical | 0 comments

Issue : The phpMyadmin errror “#2002 – The server is not responding (or the local MySQL server’s socket is not correctly configured)” Fix : 1.First check whether mysql is working in the server or not. 2. Check whether there is a symbolic link...