Cpanel Remote Mysql- steps and fixes for issues

Check the mysql remote connection after making sure that you are using the following parameters;



MySQL server : Server IP

Port : 3306

User : Full mysql user like username_test

Password : password of the mysql user.



Inorder to test mysql remote connection is working



[root@server] #mysql -h ServerIP -u mysqlusername -p

Enter password:

Welcome to the MySQL monitor. Commands end with ; or \g.

Your MySQL connection id is 12012

Server version: 5.0.91-community MySQL Community Edition (GPL)



Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.



mysql> show databases;

+--------------------+

| Database |

+--------------------+

| information_schema |

| test_catalog |

+--------------------+

2 rows in set (0.01 sec)



Issue and Error- How to fix



WARNING [2] mysql_connect(): OK packet 6 bytes shorter than expected, Line: 34 in file C:\inetpub\local_intranet\website_updater.php



-----------------------------------------------------------------------------------------------

Steps to fix

------------

Step 1. vi /etc/my.cnf

Step 2. change old-passwords = 1  to #old-passwords = 1

Step 3. restart mysql

Step 4.  change passes - is just mean change the password of myswl user {Change it to the same passwod}

Step5.  uncomment #old-passwords = 1

Step6.  restart mysql



This will fix the error



Tags:-mysql,remote mysql,common cpanel error,cpanel,cpanel remote connection