Problems Summary

  • Error 2003 while connecting the remote server
  1. Give the user privileges to login from %(or your IP), instead of just localhost
  2. Comment out bind-address( or bind your IP) and skip-networking in  /etc/mysql/mariadb.conf.d/50server.cnf
  • Python2 and python3 can exist at the same time
  1. Use python or python3 to execute the file
  2. apt-get install python3-pip to install pip for python3, and pip3 install to use it
  • Use crontab to set timed task
  1. crontab -e to edit the configure file
  2. can use .sh script if command is too long
  • Use tzselect to change timezone( MySQL’s timestamp is still UTC)