ysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to MySQL server on 'localhost' (10061)'
Check that mysqld is running on localhost and that the port is 3306.
You can check this by doing 'telnet localhost 3306'
また他方、サービスで「Start」させてみてもエラーになり、その具体的な内容がわかる
このエラーでネットを検索してみた。
Error 1067: The process terminated unexpectedly
I installed Version 4.0.15 of MySQL on my Windows XP operating system. Rather than install it in the standard C:\mysql\ directory, I installed it into C:\Program Files\mysql\.
I too received the dreaded Error 1067 when I attempted to start the mysql service in the Control Panel on path C:/Program Files/mysql/bin/mysqld-nt.exe. The my.ini files created in the WINDOWS directory upon installation contained the following:
Not sure why the last two lines have reappeared, but the new directory settings seem to be handling the change of base installation directory adequately.
上表のようにファイルを書き換えたあとで、
C:\Documents and Settings\Administrator.C32ND>cd "C:\Program Files\MySQL\bin"
C:\Program Files\MySQL\bin>mysqld-nt.exe
を実行してもなぜか MySQL が起動しなかった!?
そこで、上図のサービスで MySQL Properties
の「Start」させるとなんなく起動した。
わからんとこがあるがとりあえず大成功である。