patternMinor
mysqladmin - u root -p ping is not executing
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
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:
In your
Change it to a
You can also do:
local-infile=1
loose-local-infile=1In 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 pingCode Snippets
local-infile=1
loose-local-infile=1$ mysqladmin --no-defaults -u root -p pingContext
StackExchange Database Administrators Q#73078, answer score: 5
Revisions (0)
No revisions yet.