Buy Percona ServicesBuy Now!

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

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

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

    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

  • #2
    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.

    Comment


    • #3
      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
      Last edited by amal; 04-17-2015, 04:37 AM.

      Comment


      • #4
        i got the same problem,just keeping showing Error 1193.can u guide me how to fix it,amal?
        Last edited by scott.nemes; 04-30-2015, 10:30 AM.

        Comment


        • #5
          This usually occurs with MySQL version 5.0. Percona agent doesn't supports MySQL 5.0

          Comment

          Working...
          X