HiveBrain v1.2.0
Get Started
← Back to all entries
patternMinor

mysqladmin - u root -p ping is not executing

Submitted by: @import:stackexchange-dba··
0
Viewed 0 times
executingmysqladminpingrootnot

Problem

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'

Solution

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

Code Snippets

local-infile=1
loose-local-infile=1
$ mysqladmin --no-defaults -u root -p ping

Context

StackExchange Database Administrators Q#73078, answer score: 5

Revisions (0)

No revisions yet.