1. Common protection wall commands

  1. Start: systemctl start firewalld
  2. Check the status: Systemctl status Firewalld
  3. Stop: systemctl disable firewalld
  4. Disable: systemctl stop Firewalld

2. Common mysql commands

  1. Connect to database:
    • Mysql -h host address -u user name -p user password
    • Log in to the local host: mysql-uroot -p Password of the user
  2. Show databases;
  3. Create database databasename;
  4. Select a database: use databasename;
  5. Run the SQL command source /root/xxx.sql(the absolute path of the SQL file).
  6. To display a table: show tables
  7. Flush: Flush PRIVILEGES;

3. Common Linux commands

  • Download the zip: wget + download link
  • Decompress the package tar -zxvf +
  • Move file: MV + current folder or file path + location to move
  • Copy files: cp + current folder or file path + location to move
  • To view the host IP address, run hostname -i