Hot answers tagged mysqladmin
Command line arguments are subject to interpretation by the system's command shell, changing the behavior of the command or changing the value of the arguments before they are passed into the called program. When an argument (such as the value for --password) contains an character that the shell may interpret, they need to be either quoted (usually ...
Are you getting an access denied error or something else? mysqladmin should be printing a second line with more details, too. Have you looked over the installation notes for 5.5.25 (the current GA) at http://dev.mysql.com/doc/refman/5.5/en/macosx-installation-notes.html ? Sometimes the client don't look for the mysql socket file in the same place as it was ...
Better yet, make that section [client] to cover for any mysql client call. as this will only work for mysqladmin
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
Put the following parameters in your my.cnf and then restart the service:- skip-name-resolve log-warnings=1 The above activity will solve your issue. Try to check this link also:- http://serverfault.com/questions/341290/mysql-warning-ip-address-could-not-be-resolved
Here is a query I use to get all the used space of MySQL for all storage engines: SELECT IFNULL(ENGINE,'Total') "Storage Engine", LPAD(CONCAT(FORMAT(DAT/POWER(1024,pw1),2),' ', SUBSTR(units,pw1*2+1,2)),17,' ') "Data Size", LPAD(CONCAT(FORMAT(NDX/POWER(1024,pw2),2),' ', SUBSTR(units,pw2*2+1,2)),17,' ') "Index Size", ...
Add a [mysqladmin] section in your /etc/my.cnf or $USER/.my.cnf and set the socket. This will override the compiled-in socket and the socket defined in the [mysqld] section. You should be able to figure it out from what's shown below: VM52-CentOS58[root@ivdb41 ~]# mysqladmin ping mysqladmin: connect to server at 'localhost' failed error: 'Can't connect ...
DISCLAIMER : Not a MacOS user That is an alternative way. This shutdown method can be done in MacOS, Linux, Windows, any platform MySQL is supported in. I actually prefer your mysqladmin method for a reason... In Linux, I have seen the mysql.sock (the socket file) file just up and disappear without warning. The standard way to shutdown mysql in Linux is ...
The locks appear to be spurious. Verified bug: http://bugs.mysql.com/bug.php?id=64140
Only top voted, non community-wiki answers of a minimum length are eligible