Capstone: Container development

[jiaqing-tee]

Training link: https://youtu.be/hmkF77F9TLw Code link: https://github.com/kantancoding/microservices-python

[jiaqing-tee]

MySQL Issues 😢 | R.I.P. 2024💀 |

• MySQL service might not be started when tested with sudo systemctl status mysql. Could be some issue with brew: https://formulae.brew.sh/formula/mysql
• Uninstall mysql from brew: https://www.basedash.com/blog/how-to-install-and-uninstall-mysql-with-brew
• Reinstalled mysql with apt-get: https://dev.mysql.com/doc/mysql-apt-repo-quick-guide/en/
• Unable to find mysql command from brew directory
  • Get bash to forget the old location of mysql command with hash -d mysql:https://unix.stackexchange.com/questions/335801/bash-remembers-wrong-path-to-an-executable-that-was-moved-deleted
• Unable to access local mysql from minikube but should be possible: https://minikube.sigs.k8s.io/docs/handbook/host-access/
  • Hosted a python http server in local, able to connect it in minikube by running: nc -vz host.minikube.internal 8000 aka it should work
  • Bind mysql server address to 0.0.0.0: https://www.digitalocean.com/community/tutorials/how-to-allow-remote-access-to-mysql
• Database user unable to access database from minikube ip
  • Drop existing user: drop user auth_user@localhost;
  • Add user to access from any ip: CREATE USER 'auth_user'@'%' IDENTIFIED BY 'Auth123';
• User no access to database table
  • Grant access to all tables: GRANT ALL PRIVILEGES ON *.* TO 'auth_user'@'%';

[jiaqing-tee]

pip mysqlclient for auth service

To run this first:

sudo apt-get install python3-dev default-libmysqlclient-dev build-essential pkg-config