11
7

Delete article

Deleted articles cannot be recovered.

Draft of this article would be also deleted.

Are you sure you want to delete this article?

More than 5 years have passed since last update.

xamppでmysqlが動いてくれない… そんなときはPortをチェック

Posted at

何かと便利なxamppでMySQLを使おう!!そう思ってスタートをクリックしても動いてくれない…
よーく見るとこんなエラーが…

Problem detected!
18:55:42 [mysql] Port 3306 in use by "Unable to open process"!
18:55:42 [mysql] MySQL WILL NOT start without the configured ports free!
18:55:42 [mysql] You need to uninstall/disable/reconfigure the blocking application
18:55:42 [mysql] or reconfigure MySQL and the Control Panel to listen on a different port

3306のポートが既に何かに使われていると言われている…
そんな覚えはないのだが、どうにかしなきゃ仕方がない…ということでMySQLが使うポートの番号を変えることで解決を図ります!!!!

やり方

①MySQLのconfigをクリックしmy.iniを表示させる
②20行目付近と25行目付近にあるportを3306から適当なものに変える(3307など)

なんとこの2ステップで見事解決です!!!
ネットを見てみると、この問題に苦しんでいる人は意外と多いようで…
そういった方達のお力になれれば幸いです

11
7
1

Register as a new user and use Qiita more conveniently

  1. You get articles that match your needs
  2. You can efficiently read back useful information
  3. You can use dark theme
What you can do with signing up
11
7

Delete article

Deleted articles cannot be recovered.

Draft of this article would be also deleted.

Are you sure you want to delete this article?