5

I am getting the below error in mysql while trying to ping. i am using mysql version 5.5.37-0ubuntu0.12.04.1. when ever i use mysqladmin i am getting the below error.

Please suggest how to clear this issue

karthick.g.s@sumtwo:~$ mysqladmin -u root -p ping
Warning: mysqladmin: unknown variable 'loose-local-infile=1'
mysqladmin: unknown variable 'local-infile=1'

1 Answer 1

5

You probably have:

local-infile=1
loose-local-infile=1

In your [client] section on /etc/my.cnf , /etc/mysql/my.cnf or /home/karthick.g.s/.my.cnf or somewhere else.

Change it to a [mysql] section so it doesn't affect mysqladmin.

You can also do:

$ mysqladmin --no-defaults -u root -p ping
1
  • 1
    Again Thanks jynus issue has been fixed using above solution.
    – Karthick
    Aug 4, 2014 at 9:04

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.