Solved! Go to Solution.
This assumes you are on a Linux Server
In WHM - go to terminal
run
locate my.ini OR locate my.cnf
If you get command not found
yum -y install mlocate
Then
updatedb
If you are a windows server if you go to the services window and then find MySQL select the properties and you should see the path to executable and that should show you the my.ini file path
Once your issue is resolved,
please be sure to come back and click accept for the solution
Get Better Support on the Community Boards!
Etiquette When Asking for Help from the Community
This cannot be done via cPanel or WHM - You would either need to edit the file in terminal or in terminal run the mysql command (see https://tableplus.io/blog/2018/08/mysql-how-to-modify-the-max-allowed-packet-size.html )
If you are using terminal via WHM then you are in as root and should be good to go.
Once your issue is resolved,
please be sure to come back and click accept for the solution
Get Better Support on the Community Boards!
Etiquette When Asking for Help from the Community
If you have cPanel, the .ini file is usually found in the public_html folder, which you can access using the File Manager. If there's not one there, you simply create your own and populate the data you need. Typically, this will be either a user.ini or a php.ini.
If you're using something similar to cPanel, the easiest thing to do is look up the file management system the control panel uses.
Hope that helps.
Once your issue is resolved,
please be sure to come back and click accept for the solution
Get Better Support on the Community Boards!
Etiquette When Asking for Help from the Community
This assumes you are on a Linux Server
In WHM - go to terminal
run
locate my.ini OR locate my.cnf
If you get command not found
yum -y install mlocate
Then
updatedb
If you are a windows server if you go to the services window and then find MySQL select the properties and you should see the path to executable and that should show you the my.ini file path
Once your issue is resolved,
please be sure to come back and click accept for the solution
Get Better Support on the Community Boards!
Etiquette When Asking for Help from the Community
I entered the first command and it returned with,
can not stat () `/var/lib/mlocate/mlocate.db': No such file or directory
So I assume that means there is not one, so I then put in the second command and it returned with,
Loaded plugins: fastestmirror, universal-hooks
Setting up Install Process
Loading mirror speeds from cached hostfile
* EA4: 103.192.173.8
* cpanel-addons-production-feed: 103.192.173.8
* cpanel-plugins: 103.192.173.8
* base: centos-distro.cavecreek.net
* extras: mirror.fileplanet.com
* updates: centos-distro.cavecreek.net
EA4 | 2.9 kB 00:00 ...
cpanel-addons-production-feed | 2.9 kB 00:00 ...
cpanel-plugins | 2.9 kB 00:00 ...
base | 3.7 kB 00:00
extras | 3.4 kB 00:00
mysql-connectors-community | 2.5 kB 00:00
mysql-tools-community | 2.5 kB 00:00
mysql57-community | 2.5 kB 00:00
updates | 3.4 kB 00:00
Package mlocate-0.22.2-6.el6.x86_64 already installed and latest version
Nothing to do
Why does it say already installed at the end? So then I put in the third command and it returned with nothing. And then I tried entering the locate my.ini command again but it returned with nothing.
So what did I do wrong, and what should I do next?
I entered the first command and it returned with,
can not stat () `/var/lib/mlocate/mlocate.db': No such file or directory
So I assume that means there is not one, so I then put in the second command and it returned with,
Loaded plugins: fastestmirror, universal-hooks
Setting up Install Process
Loading mirror speeds from cached hostfile
* EA4: 103.192.173.8
* cpanel-addons-production-feed: 103.192.173.8
* cpanel-plugins: 103.192.173.8
* base: centos-distro.cavecreek.net
* extras: mirror.fileplanet.com
* updates: centos-distro.cavecreek.net
EA4 | 2.9 kB 00:00 ...
cpanel-addons-production-feed | 2.9 kB 00:00 ...
cpanel-plugins | 2.9 kB 00:00 ...
base | 3.7 kB 00:00
extras | 3.4 kB 00:00
mysql-connectors-community | 2.5 kB 00:00
mysql-tools-community | 2.5 kB 00:00
mysql57-community | 2.5 kB 00:00
updates | 3.4 kB 00:00
Package mlocate-0.22.2-6.el6.x86_64 already installed and latest version
Nothing to do
Why does it say already installed at the end? So then I put in the third command and it returned with nothing. And then I tried entering the locate my.ini command again but it returned with nothing.
So what did I do wrong, and what should I do next?
So you actually are on the right track - do locate my.cnf
my.ini is on the Windows user my.cnf is on the unix server
Once your issue is resolved,
please be sure to come back and click accept for the solution
Get Better Support on the Community Boards!
Etiquette When Asking for Help from the Community
So you know I am on a linux server. I entered the locate my.cnf command and it returned with,
/etc/my.cnf
/etc/my.cnf.d
/root/.my.cnf
/var/cpanel/configs.cache/_root_.my.cnf___default_equal_before_after_space_allow_undef
So is that saying it located the file, and if so how do I get to it to open it?
I would do
nano /etc/my.cnf
I recommend nano over vi as an editor as it's a little more user (non-techie) friendly
Here is a quick reference guide to nano - https://www.howtogeek.com/howto/42980/the-beginners-guide-to-nano-the-linux-command-line-text-editor...
After you make your changes you should restart mysql
You should make a backup of the file before you edit it as if you are not careful with the edits you can cause your MySQL server not to load
Once your issue is resolved,
please be sure to come back and click accept for the solution
Get Better Support on the Community Boards!
Etiquette When Asking for Help from the Community
This cannot be done via cPanel or WHM - You would either need to edit the file in terminal or in terminal run the mysql command (see https://tableplus.io/blog/2018/08/mysql-how-to-modify-the-max-allowed-packet-size.html )
If you are using terminal via WHM then you are in as root and should be good to go.
Once your issue is resolved,
please be sure to come back and click accept for the solution
Get Better Support on the Community Boards!
Etiquette When Asking for Help from the Community