wtatsuruの技術方面のブログ

はてなスタッフ id:wtatsuru です。日常ブログはこちら https://tatsuru.hatenablog.com/

mysql client での localhost

  • 特別扱いされてる。へぇ。

localhost is a synonym for your local host name, and is also the default host to which clients try to connect if you specify no host explicitly.
To avoid this problem on such systems, you can use a --host=127.0.0.1 option to name the server host explicitly. This will make a TCP/IP connection to the local mysqld server. You can also use TCP/IP by specifying a --host option that uses the actual host name of the local host. In this case, the host name must be specified in a user table row on the server host, even though you are running the client program on the same host as the server.

http://dev.mysql.com/doc/refman/5.5/en/access-denied.html
  • mysqld_multi で複数立てたときなんかに困った
はてなで一緒に働きませんか?