How to fix Cpanel Remote Mysql issue having the error message: WARNING [2] mysql_connect(): OK packet 6 bytes shorter than expected, Line: 34 in file C:\\inetpub\\local_intranet\\website_updater.php<\/p>\n
We need to perform two steps to check this which can be done as follows:<\/p>\n
Firstly, check the mysql remote connection after making sure that you are using the following parameters;<\/p>\n
MySQL server : Server IP<\/p>\n
Port : 3306<\/p>\n
User : fill in mysql user for eg: username_test<\/p>\n
Password : password of the mysql user.<\/p>\n
<\/p>\n
Secondly, we need to test if mysql remote connection is working by doing the following steps:<\/p>\n
[root@linux] #mysql -h server_ip -u my_sql_username -p<\/p>\n
Enter password:<\/p>\n
Welcome to the MySQL monitor. Commands end with ; or \\g.<\/p>\n
Your MySQL connection id is 15054<\/p>\n
Server version: 5.0.9-community MySQL Community Edition (GPL)<\/p>\n
Type ‘help;’ or ‘\\h’ for help. Type ‘\\c’ to clear the current input statement.<\/p>\n
mysql> show databases;<\/p>\n
+——————–+<\/p>\n
| Database |<\/p>\n
+——————–+<\/p>\n
| information_schema |<\/p>\n
| linux_catalogs |<\/p>\n
+——————–+<\/p>\n
2 rows in set (0.01 sec)<\/p>\n
If an Error message apprears as shown below , then this can be resolved which is explained<\/p>\n
after this:<\/p>\n
WARNING [2] mysql_connect(): OK packet 6 bytes shorter than expected, Line: 34 in file C:\\inetpub\\local_intranet\\website_updater.php<\/p>\n
Steps to fix this issue:<\/p>\n
a. vi \/etc\/my.cnf<\/p>\n
b. change old-passwords = 1\u00a0 to #old-passwords = 1<\/p>\n
c. restart mysql<\/p>\n
d.\u00a0 change password (change the password of mysql user\u00a0 to the same password}<\/p>\n
e.\u00a0 uncomment #old-passwords = 1<\/p>\n
f.\u00a0 restart mysql<\/p>\n
This will fix the above mysql remote connection issue.<\/p>\n
If you require help, contact SupportPRO Server Admin<\/a><\/p>\n
![\"Server](\"https:\/\/no-cache.hubspot.com\/cta\/default\/2725694\/9d590242-d641-4383-94b4-8cfd62f0af6b.png\")
<\/a><\/span>