DB:
Unlock MySQL root access
# On MySQL server shell
mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'YOURAWESOMEPWD_FOR_ROOT' WITH GRANT OPTION;
mysql> FLUSH PRIVILEGES;
# Remark: 'root'@'%' indicates client from anywhere with user: root
# On MySQL server end
# For some file under /etc/mysql, comment 'bind-address = 127.0.0.1'
# Then restart MySQL
MySQL commit
- This is a MUST following INSERT, DELETE, and UPDATE statements
MySQL_rwTimeout
Persistent VS Non-persistent
- So it basically depends on the overhead to set up the connection to decide whter to use persistent connection or not
Atomic?