All Entries Tagged With: "phpmyadmin"
MySQL:Got a packet bigger than ‘max_allowed_packet’ bytes
Issue :
While trying to restore a database through phpmyadmin, following error occurs:
#1153 – Got a packet bigger than ‘max_allowed_packet’ bytes
Solution :
This error occurs if the packet size is more than the default value OR the value defined in the my.cnf file.
my.cnf might be blank on a cPanel server by default. You can [...]
Logging in to PHPMyAdmin directly
Issue :
How to login to PHPMyAdmin directly (without logging in to the cPanel interface) ?
Solution :
This can be achieved by the following steps :
First, download and untar the latest version in to your public_html folder.
wget http://downloads.sourceforge.net/project/phpmyadmin/phpMyAdmin/2.11.9.5/phpMyAdmin-2.11.9.5-english.tar.gz
tar -zxvf phpMyAdmin-2.11.9.5-english.tar.gz
cd phpMyAdmin-2.11.9.5-english
mv phpMyAdmin-2.11.9.5-english phpMyAdmin
Then, create a file named config.inc.php and put the following entries in it [...]
Error #1153 – Got a packet bigger than ‘max_allowed_packet’ bytes
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 :
================
max_allowed_packet = 16M
================
This should resolve the issue.
PhpMyadmin errror “#2002
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 from mysql.sock to /tmp. If not, create a symlink between /var/lib/mysql/mysql.sock and /tmp/mysql.sock.
~~~~~~~~~
ln -s [...]
