liunx软件操作及安装

liunx软件操作及安装 mysql mongo redis tomcat yum make

1 mysql

指令 ps -ef|grep mysql 得出结果
    root     17659     1  0  2011 ?        00:00:00 /bin/sh /usr/bin/mysqld_safe --datadir=/var/lib/mysql --socket=/var/lib/mysql/mysql.sock --log-error=/var/log/mysqld.log --pid-file=/var/run/mysqld/mysqld.pid   
    mysql    17719 17659  0  2011 ?        03:14:57 /usr/libexec/mysqld --basedir=/usr --datadir=/var/lib/mysql --user=mysql --pid-file=/var/run/mysqld/mysqld.pid --skip-external-locking --socket=/var/lib/mysql/mysql.sock  

usr/bin/mysql 是指：mysql的运行路径
var/lib/mysql 是指：mysql数据库文件的存放路径
usr/lib/mysql 是指：mysql的安装路径 


导出数据库 /opt/tech/mysql/bin/mysqldump -uroot -p1234 webpro > /opt/tech/20170814.sql

导入数据  mysql -uroot -pSai.web123 YCKPLUS < /opt/sql/uccpplus_v4_0_5.sql

mysql导入时出现"ERROR at line : Unknown command '\''."的解决办法
         mysql -uroot -p12344  --default-character-set=utf8 IMP_V12_1 < E:\isds-1.1.2.sql

导出查询语句 /opt/saiwen/mysql/bin/mysql -uroot -p12344 -e "use YCKPLUS;select id,loginName from T_USER where id=1\G;" >> /opt/test.txt

导出表   /opt/tech/mysql/bin/mysqldump -uroot -p1234 webpro t_user > /opt/tech/t_user.sql

创建数据库
CREATE DATABASE YCKPLUS DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
use YCKPLUS;

登录mysql  /opt/tech/mysql/bin/mysql -uroot -p1234 
           /opt/tech/mysql/bin/mysql -uroot -padmin

创建、使用数据库   create database test;  use test;
导入sql数据     source /root/20151010.sql


复制表数据到新表
CREATE TABLE T_MENU1 LIKE T_MENU;
INSERT INTO T_MENU1 SELECT * FROM T_MENU;

/opt/tech/apache-tomcat-6.0.45/webapps/add20170814.sql

修改max_allowed_packet  vi /etc/my.cnf

58.246.98.94
mysql -u root -p12344



navicat连接mysql失败，授权：
GRANT ALL PRIVILEGES ON `db1`.* TO 'user1'@'192.171.1.18' identified by 'pwd1' WITH GRANT OPTION;
GRANT ALL PRIVILEGES ON `YCKPLUS`.* TO 'saiwen'@'192.171.1.18' identified by 'test12344' WITH GRANT OPTION;

grant all privileges on *.* to root@'%' identified by 'saiwen.web123' with grant option;

-- flush privileges;


查询权限
select * from mysql.user
select Host,User,password_last_changed from mysql.user

取消权限
revoke  all on *.* from 'root'@'192.168.0.197' ;

删除用户权限
Delete from mysql.user where user = "user_name" and host = "host_name" ; 



linux 的mysql配置文件  /etc/my.cnf

查看编码
show variables like 'character%'; 

设置编码
set character_set_server='utf8';  

查看sql_mode
SELECT @@GLOBAL.sql_mode;

识别大小写
lower_case_table_names = 2

启动mysql
  /opt/saiwen/mysql/support-files/mysql.server start

  /opt/saiwen/mysql/bin/mysqld_safe --user=mysql --basedir=/opt/saiwen/mysql --datadir=/opt/saiwen/mysql/data & 

  cd /opt/saiwen/mysql/
  ./bin/mysqld_safe &


  chmod -R 775 mysql


  cd /data/saiwen/mysql/&&./bin/mysqld_safe &
  cd /opt/saiwen/mysql/ && bin/mysqld_safe --user=root &

欢迎大家来到IT世界,在知识的湖畔探索吧!

2 mongo

欢迎大家来到IT世界,在知识的湖畔探索吧![mongo笔记]( https://github.com/scott180/MyNotes/blob/master/mongo.md )

配置文件启动
cd /opt/saiwen/mongodb           
./bin/mongod --config /opt/mongodb/conf/mongo.conf 

自定义路径启动                                         
  /opt/saiwen/mongodb/bin/mongod --dbpath=/opt/saiwen/mongodb/data --logpath=/opt/saiwen/mongodb/logs --logappend  --port=27017 --fork

登陆mongo
cd /opt/saiwen/mongodb/bin
mongo

3 redis

windows下redis安装 
http://www.runoob.com/redis/redis-install.html
进入redis目录
启动  redis-server.exe redis.windows.conf

登录  redis-cli.exe -h 127.0.0.1 -p 6379
      redis-cli -a saiwen12344


Redis 设置密码登录 
修改redis.windows.conf
#requirepass foobared。设置密码的方法就是去掉注释的#，把foobared替换成自己的密码即可，例如将密码设置为123456


服务自启动
redis-server --service-install redis.windows.conf --loglevel verbose 


问题 Invalid argument during startup: unknown conf file parameter : requirepass
redis 设置来密码，出现来这个错误，
把配置文件那一行的空格去掉
# requirepass foobared
改成
requirepass 123456


启动redis
./redis/src/redis-server ./redis/redis.conf &

关闭redis
./redis/src/redis-cli -h host -p port -a password shutdown
host值在./redis/redis.conf文件中搜索bind
port值在./redis/redis.conf文件中搜索port
password值在/redis/redis.conf文件中搜索requirepass

进入redis命令行
./redis/src/redis-cli -h host -p port -a password



[root@localhost src]# cd /opt/saiwen/custom/redis-2.8.17/
[root@localhost redis-2.8.17]# redis-server redis.conf              //启动redis                 
[root@localhost ~]# redis-cli       //进入redis客户端
127.0.0.1:6379> keys *              //取出所有的key 
(empty list or set)
127.0.0.1:6379> quit                //退出客户端   

127.0.0.1:6379> set key1 value1        //set
OK
127.0.0.1:6379> get key1            //get
"value1"
127.0.0.1:6379> del k1                //删除一个key
(integer) 1
127.0.0.1:6379> flushdb                //清空所有数据



Exception in thread "main" redis.clients.jedis.exceptions.JedisDataException: DENIED Redis is running in protected mode because protected mode is enabled。。。。

进入客户端设置模式：
redis-cli
config set protected-mode "no"

4 tomcat命令

欢迎大家来到IT世界,在知识的湖畔探索吧!Linux下Tomcat的启动、关闭、杀死进程   （进入tomcat的bin目录 启动 sh startup.sh）
    打开终端
    进入tomcat目录
    cd /Java/tomcat
    #执行
    bin/startup.sh #启动tomcat
    bin/shutdown.sh #停止tomcat
    tail -f logs/catalina.out #看tomcat的控制台输出；

    #看是否已经有tomcat在运行了
    ps -ef |grep tomcat 
    #如果有，用kill;
    kill -9 pid #pid 为相应的进程号

    例如 ps -ef |grep tomcat 输出如下

    sun 5144 1 0 10:21 pts/1 00:00:06 /java/jdk/bin/java -Djava.util.logging.manager=org.apache.juli.ClassLoaderLogManager -Djava.endorsed.dirs=/java/tomcat/common/endorsed -classpath :/java/tomcat/bin/bootstrap.jar:/java/tomcat/bin/commons-logging-api.jar -Dcatalina.base=/java/tomcat -Dcatalina.home=/java/tomcat -Djava.io.tmpdir=/java/tomcat/temp org.apache.catalina.startup.Bootstrap start

    则 5144 就为进程号 pid = 5144
    kill -9 5144 就可以彻底杀死tomcat

查看tomcat
    ps -ef |grep tomcat 
杀死tomcat 
    kill -9 pid        //pid 为相应的进程号
启动tomcat
    /opt/tech/appStore/apache-tomcat-6.0.35/bin/startup.sh

5 为每个tomcat配置单独的jdk

一、安装jdk，如jdk-6u45-linux-x64.bin
1、添加执行权限 
    chmod u+x jdk-6u45-linux-x64.bin
2、解压 
    ./jdk-6u45-linux-x64.bin

二、配置tomcat的 ../bin/setclasspath.sh    在文件的开头添加以下
export JAVA_HOME=/opt/saiwen/jdk1.6.0_45  
export JRE_HOME=/opt/saiwen/jdk1.6.0_45/jre

三、重启tomcat



部署多个tomcat主要修改三个端口：

1.HTTP端口，默认8080，如下改为8081
<Connector port="8081" protocol="HTTP/1.1" 
               connectionTimeout="60000" 
               redirectPort="8443" disableUploadTimeout="false"  executor="tomcatThreadPool"  URIEncoding="UTF-8"/>


2.远程停服务端口，默认8005，如下改为8006
<Server port="8006" shutdown="SHUTDOWN">......


3.AJP端口，默认8009，如下改,8010
<Connector port="8010" protocol="AJP/1.3" redirectPort="8443" />

6 yum rpm安装卸载软件

yum安装：
       # yum install 包名
yum卸载：
       # yum -y remove 包名

查询所有安装软件     rpm -qa
查看是否安装软件     rpm -qa | grep java      
卸载软件             rpm -e    如果提示有依赖，可以加上 --nodeps 

[root@localhost openldap]# rpm -qa | grep openldap
openldap-2.4.44-15.el7_5.x86_64
openldap-servers-2.4.44-15.el7_5.x86_64
compat-openldap-2.3.43-5.el7.x86_64

[root@localhost openldap]# rpm -e --nodeps openldap-2.4.44-15.el7_5.x86_64
[root@localhost openldap]# rpm -e --nodeps openldap-servers-2.4.44-15.el7_5.x86_64
[root@localhost openldap]# rpm -e --nodeps compat-openldap-2.3.43-5.el7.x86_64

7 make安装卸载软件

用于linux源码安装软件，一般下载源码包得到文件：xxxx.tgz

1、解包软件
tar zxf xxxx.tgz

2、配置
cd xxxx
./configure ....

3、编译
make

4、安装
make install

5、卸载
make uninstall

免责声明：本站所有文章内容,图片，视频等均是来源于用户投稿和互联网及文摘转载整编而成，不代表本站观点，不承担相关法律责任。其著作权各归其原作者或其出版社所有。如发现本站有涉嫌抄袭侵权/违法违规的内容,侵犯到您的权益，请在线联系站长,一经查实,本站将立刻删除。本文来自网络,若有侵权，请联系删除，如若转载，请注明出处：https://itzsg.com/17070.html