Linux Command Collection

HTTPS Download Skip Check

wget--no-check-certificate

See if the installation

Rpm-qa|grep MySQL

To view the installable list

Yum List Installed|grep MySQL

Mysql:

Http://dev.mysql.com/get/Downloads/MySQL-5.6/mysql-5.6.23.tar.gz

MySQL Compilation

Cmake-dcmake_install_prefix=/opt/mysql \

-dmysql_unix_addr=/tmp/mysql.sock \

-ddefault_charset=utf8 \

-DDEFAULT_COLLATION=UTF8_GENERAL_CI \

-dwith_extra_charsets=all \

-dwith_myisam_storage_engine=1 \

-dwith_innobase_storage_engine=1 \

-dwith_memory_storage_engine=1 \

-dwith_readline=1 \

-denabled_local_infile=1 \

-dmysql_datadir=/var/mysql/data \

-dmysql_user=mysql

Allow remote access

GRANT all privileges on * * to ' root ' @ '% ' identified by ' root ' with GRANT OPTION;
FLUSH privileges;

Export SQL

mysqldump-uroot [email protected] Csop >/opt/csop.sql

Import SQL

Mysql-uroot-proot Csop </data/csop.sql

Open memcached

./memcached-u root-d

View folder occupancy

Lsof/opt

View process

Ps-ef | grep nginx

Kill process

Kill-9 Process ID

Download files from remote server to local

scp-p [Email protected]:/media/media/csop/webapps.zip/usr/local/csop/

Compression

Zip-r Webapps.zip webapps/

TAR-RF Webapps.tar WebApps

Extract

Unzip Webapps.zip

Add Execute Permissions

chmod a+x

Linux Command Collection