Rookie Coder's MySQL Intro - Uninstalling MySQL and a Fresh Install
My MySQL install that used to work fine... stopped connecting the way it used to after I installed Bitnami!!!
Argh~~ thanks to that, I lost an hour and a half ㅜㅜ
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) |
I kind of expected something like this since Bitnami bundles a bunch of stuff together... I thought just tweaking the port would do it.. but it doesn't seem that simple.. Since the digging was dragging on too long, brew I decided to uninstall the MySQL I had originally installed via brew and just reinstall it.
1. Uninstall
First, here's how to uninstall MySQL that was installed via homebrew . It's a foreign-language link, but..
You can just copy and paste what's in the first chapter into your terminal.
In case you did a regular install,
https://codingisgame.tistory.com/12 following this should work.
2. Fresh install — and how to get it running:
https://opentutorials.org/course/3161/19532 — just follow this and you'll be up and running right away..
For reference,
the installer file link is https://www.mysql.com/products/community/ and
the community version offered there is free to use.
The latest version is a little different from Egoing's video. Nothing worrying, just a bit more streamlined.
You can just stick with the defaults, and at some point it asks you to set a password directly.
What used to be set up in the terminal (cmd) on older versions can now be configured right during installation, which is a lot more convenient.
3. Running it
$ cd /usr/local/mysql/bin/
$ ./mysql -uroot -p
$ enter the password you set during install
4. Result
