Things on this page are fragmentary and immature notes/thoughts of the author. Please read with your own judgement!

1. The wheel group is the sudo group. So to grant a user the sudo previlege, just add it to the wheel group.

   gpasswd -a user_name wheel
   

EPEL

sudo yum -y install …

Things on this page are fragmentary and immature notes/thoughts of the author. Please read with your own judgement!

1. Unlike Teradata SQL, a select statement in Oracle must have the from keyword. The dual table can be used if you do not really want to select from a table.

   select …

Things on this page are fragmentary and immature notes/thoughts of the author. Please read with your own judgement!

Available commands for snap:

abort Abort a pending change ack Adds an assertion to the system alias Enables the given aliases aliases Lists aliases in the system buy Buys a snap …

Things on this page are fragmentary and immature notes/thoughts of the author. Please read with your own judgement!

https://plot.ly/python/offline/

1. plotly works out-of-box in RStudio, however, not in rmakrdown. This is due to account setup issues. Use plotly in offline mode solves the problem.

** Things on this page arefragmentary and immature notes/thoughts of the author. It is not meant to readersbut rather for convenient reference of the author and future improvement. **

1. You might have difficulties to visit some web pages when you are using VPN. This is probably because the location set by …

Things on this page are fragmentary and immature notes/thoughts of the author. Please read with your own judgement!

sudo service mysql restart

mysqladmin -u root -p variables | grep port

mysqladmin --help list the locations of my.cnf.

mysqladmin --help

Python Packages

1. peewee

2. PyMySQL

3. MySQLdb

References

• MySQL Cheat Sheet
• MySQL …