# Error 1193: Unknown system variable 'port' on testing agent's MySQL connection

**URL:** <https://forums.percona.com/t/error-1193-unknown-system-variable-port-on-testing-agents-mysql-connection/4008>\
**Category:** Percona Cloud Tools\
**Created:** [January 24, 2015, 3:01am UTC](https://forums.percona.com/t/error-1193-unknown-system-variable-port-on-testing-agents-mysql-connection/4008 "2015-01-24T03:01:08Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![hgoles](https://avatars.discourse-cdn.com/v4/letter/h/9e8a1a/32.png) [@hgoles](https://forums.percona.com/u/hgoles)\
**Post date:** [January 24, 2015, 3:01am UTC](https://forums.percona.com/t/error-1193-unknown-system-variable-port-on-testing-agents-mysql-connection/4008/1 "2015-01-24T03:01:08Z")

</div>

I got this error every time I want to add MySQL server to my dashboard,  
Error 1193: Unknown system variable ‘port’  
I’ve found nothing useful to fix it in this forum or other websites,  
So any help regarding troubleshooting this issue is highly appreciated.

Kind Regards

---

<div class="post-metadata">

**Author:** ![mirfan](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/mirfan/32/16890_2.png) [@mirfan](https://forums.percona.com/u/mirfan)\
**Post date:** [April 3, 2015, 8:29am UTC](https://forums.percona.com/t/error-1193-unknown-system-variable-port-on-testing-agents-mysql-connection/4008/2 "2015-04-03T08:29:27Z")

</div>

What version of MySQL you are using ? Can you please provide percona-agent log to debug it further.

mysql\> SHOW GLOBAL VARIABLES LIKE ‘port’;  
mysql\> SHOW GLOBAL VARIABLES LIKE ‘%version%’;

Also, please provide MySQL my.cnf file.

---

<div class="post-metadata">

**Author:** ![amal](https://avatars.discourse-cdn.com/v4/letter/a/c68b51/32.png) [@amal](https://forums.percona.com/u/amal)\
**Post date:** [April 17, 2015, 4:03am UTC](https://forums.percona.com/t/error-1193-unknown-system-variable-port-on-testing-agents-mysql-connection/4008/3 "2015-04-17T04:03:24Z")

</div>

Hi,

I’ve installed percona-agent per the instructions, yet nothing is showing up in the query analytics or monitor. I do see the following in the Percona Cloud Tools logs:

* * *

amal

---

<div class="post-metadata">

**Author:** ![fairyin](https://avatars.discourse-cdn.com/v4/letter/f/b3f665/32.png) [@fairyin](https://forums.percona.com/u/fairyin)\
**Post date:** [April 18, 2015, 1:21am UTC](https://forums.percona.com/t/error-1193-unknown-system-variable-port-on-testing-agents-mysql-connection/4008/4 "2015-04-18T01:21:14Z")

</div>

i got the same problem,just keeping showing Error 1193.can u guide me how to fix it,amal?

---

<div class="post-metadata">

**Author:** ![mirfan](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/mirfan/32/16890_2.png) [@mirfan](https://forums.percona.com/u/mirfan)\
**Post date:** [April 30, 2015, 8:04am UTC](https://forums.percona.com/t/error-1193-unknown-system-variable-port-on-testing-agents-mysql-connection/4008/5 "2015-04-30T08:04:18Z")

</div>

This usually occurs with MySQL version 5.0. Percona agent doesn’t supports MySQL 5.0