Tag Info

Hot answers tagged

3

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


2

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


1

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


1

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


1

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