Tag Info

Hot answers tagged


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 ...


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


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


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


There are two techniques you can try: TECHNIQUE #1 The comment from Michael - sqlbot already said it. Use double quotes mysqladmin -u root password "Pe%8XiduwOqdZ<ZFE5!" TECHNIQUE #2 root@localhost has no password. Try running this: mysql -uroot -e"SET SQL_LOG_BIN = 0; SET PASSWORD = PASSWORD('mynewpassword');" This should do it as well. CAVEAT ...


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", ...


Please find the answers inlined below. 1. Will it mess up the sync in any way - On a high availability architectural view "YES". As long you have Master up and steady you might not end up problems. 2. Will the changes get overwritten from the master during the next replication event Depends upon your changes. On Master create table test (id int, ...


Answers to your questions are as below: 1) Will it mess up the sync in any way Answer: Yes it will mess up your replication process as slave reads from relay log and updates on Server. For example: If a row has been added to slave and which is not there in Master then "INSERT INTO ..." query will fail which can cause replication process being stopped. 2) ...


The locks appear to be spurious. Verified bug: http://bugs.mysql.com/bug.php?id=64140


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 ...

Only top voted, non community-wiki answers of a minimum length are eligible