Portal Home > Knowledgebase > Articles Database > (Easy) How to check max_allowed_packet in shh or using a file?
(Easy) How to check max_allowed_packet in shh or using a file?
| Posted by basketmen, 09-15-2010, 07:01 AM |
| I had try using phpinfo.php to see the php info but cant see it
i had try using this command in ssh too but only showing something like >
please help guyss
|
| Posted by drspliff, 09-15-2010, 07:20 AM |
|
|
| Posted by basketmen, 09-15-2010, 07:31 AM |
| i am sorry, is this php file like this
or ssh command?
|
| Posted by drspliff, 09-15-2010, 08:00 AM |
| facepalm*
It's a MySQL query, to be run from the MySQL console or through some PHP which queries MySQL.
|
| Posted by 24nt7linux, 09-15-2010, 08:07 AM |
| Hi,
Do you have root access to your server? If you have, login to the server and go to mysql prompt. if it is a cpanel server, just typing 'mysql' on the console will let you in. Then run the query "show variables like '%max_allowed_packet%';" there. You will be getting the result.
typing "mysqladmin show variables" on your console will give you details about all the mysql variables. Try it out..
|
| Posted by basketmen, 09-15-2010, 08:16 AM |
| hmm i am still not clear
after login in cpanel i only see this
mysql database MySQL® Databases
mysql database MySQL® Database Wizard
mysql database phpMyAdmin
remote mysql Remote MySQL
btw yes i have access to the root, do you mean whm? what is the area name exactly?
|
| Posted by matt2kjones, 09-15-2010, 08:34 AM |
| I'm sorry but are you being serious?
What people are posting above are console based apps. You need to login via ssh and run these commands.
download putty, type in your server ip, and login
try the above commands, however, on my server this works:
you will get something like this back:
Last edited by matt2kjones; 09-15-2010 at 08:40 AM.
|
| Posted by basketmen, 09-15-2010, 08:48 AM |
| so my max_allowed_packet is 16Mb
got it thanks matt2kjones this is working, its surely can be easy like this , thanks for other anw
this will help many of people out there in the future
|
Add to Favourites 
Print this Article
Also Read
