15 Practical Linux cURL Command Examples

typically:

curl -O [url]

MySQL: allow remote connection

allow connection from arbitrary hostname:

mysql>GRANT ALL PRIVILEGES ON . TO ‘[username]‘@’%’ IDENTIFIED BY ‘[password]’ WITH GRANT OPTION;
mysql>FLUSH RIVILEGES

allow connection from specific hostname:

mysql>GRANT ALL PRIVILEGES ON . TO ‘[username]‘@’[hostname]’ IDENTIFIED BY ‘[password]’ WITH GRANT OPTION;
mysql>FLUSH RIVILEGES

How to locate MySQL configuration file?

The file might be in 5 (or more?) locations
/etc/my.cnf
/etc/mysql/my.cnf
$MYSQL_HOME/my.cnf
[datadir]/my.cnf
~/.my.cnf

How to locate Nginx configuration file?

The primary configuration file is /etc/nginx/nginx.conf.
Other possible locations include /opt/nginx/conf/.

How to locate Apache configuration file?

Usually /etc/httpd/conf/httpd.conf.

Create an info.php to reveal Apache environment (risky).

< ?php
phpinfo();
?>

Install Apache2, PHP5 And MySQL Support On CentOS 6.5 (LAMP)

the Apache service is located at /etc/init.d/httpd.

How To Install Linux, nginx, MySQL, PHP (LEMP) stack on CentOS 6

• Test nginx.conf

  /usr/sbin/nginx -t

• Duplicate a MySQL database with its tables

  mysqldump [existing database] -u root -p’[password]’ –add-drop-table | mysql [new database] -u root -p’[password]’

• Check the direction of MySQL data files

  show variables like ‘%dir%’;

• Uninstall and reinstall node & npm

  sudo apt-get update
  sudo apt-get install nodejs
  sudo apt-get install npm

• MySQL:show columns of a certain datatable:

  show full columns from [tablename];

• Nginx:remove root directory

  root /usr/share/nginx/html;
  …
  location / {
  …
  fastcgi_param SCRIPT_FILENAME /usr/share/nginx/html$fastcgi_script_name;
  …
  }

  /etc/init.d/nginx restart

• Nginx:add rewrite rules for redirecting,map port 8080 into 80.

  server {
  listen 8080;
  server_name localhost_redirect;
  rewrite ^/(.+)/.* /$1 last;
  location / {
  proxy_pass http://127.0.0.1:80;
  proxy_set_header Host $host:80;
  proxy_set_header X-Real-IP $remote_addr;
  proxy_set_header X-Forwarded-For $proxy_add_x_forwarded_for;
  }
  }

启用了阿里云的服务器，终于给ACM俱乐部做了个像样的交互界面。

---

网站搭建的主要流程，接受了外界资料的援助