mysql常用 rpm包删除

[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
user=mysql
# Default to using old password format for compatibility with mysql 3.x
# clients (those using the mysqlclient10 compatibility package).
#old_passwords=1
default-character-set=utf8
init_connect='SET NAMES utf8'
#skip-name-resolve
#skip-grant-tables

[client]
#password       = your_password
port            = 3306
socket          = /var/lib/mysql/mysql.sock
default-character-set=utf8

[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid

db.opt文件字符这代表服务端的数据编码格式
/var/lib/mysql/game/db.opt 
default-character-set=utf8
default-collation=utf8_general_ci

mysql字符集的问题，配置文件在mysqld client两个地方都得配置utf8导入数据后才不会成乱码
忘记密码问题，在mysqld下加入下面两段重启mysql即可以无密码登录进入了更新密码后重启即可
skip-name-resolve
skip-grant-tables

UPDATE mysql.user SET Password=PASSWORD ('xxx') WHERE User='root';
数据库设置密码
mysqladmin -uroot -p'123456' password ''
配置文件的
#old_passwords=1
这个mysql有点老，还有这项，去除后会使用md5的加密方式

[mysqld] 
log=codfei.log 
然后重新启动 MYSQL 服务器。 
之后你所有客户端执行的SQL语句就都在日志文件里。

在数据库里设置编码格式
set names utf8;
或者 set character set utf8;
赋权
密码格式
grant all on game.* to  "user"@"10.15.29.7" identified by "xxx";
无密码
grant all on game.* to  "user"@"10.15.29.7";
删除授权
revoke all on game.* from  user@122.225.32.107;
delete from mysql.user where host='122.225.32.107';
设置md5密码
update log_op_user set user='12', pass=md5('123456'), name='56' where id='24';
导出数据库模板（无数据）
mysqldump --quick --add-drop-table --no-data msyql > mysql.sql
导出数据库某张表
mysqldump -p --quick mysql user > mysql.user.sql
命令带密码导出数据
mysqldump -uroot --password=xxx --database mysql --tables user > mysql.user.sql
mysqldump --quick -uroot -pxxx  mysql  user > mysql.user.sql

两IP放在一个网卡上实现双网互通，个人觉得双网互通的话应该两网卡实现比较好
/etc/sysconfig/network-scripts/ifcfg-eth0:0 双IP
DEVICE=eth0:0
ONBOOT=yes
BOOTPROTO=static
IPADDR=60.12.231.57
NETMASK=255.255.255.192
GATEWAY=60.12.231.1

 

删除rpm包脚本能够删除四层以内依赖关系包
#!/bin/bash
rpm -e `rpm -qa|grep $1` 2> T$1 
if [  -s T$1 ]
then
cat T$1|awk -F 'installed)' '{print $2}' >T${1}1
else
rm -rf T$1  
exit
fi  #第一层
rpm -e `cat T${1}1` `rpm -qa|grep $1` 2>T${1}2 #第二层
cat T${1}2|awk -F 'installed)' '{print $2}' >T${1}3
if [  -s T${1}3 ]
then
rpm -e `cat T${1}1 T${1}3` `rpm -qa|grep $1` 2>T${1}4
fi  #第三层
cat T${1}4|awk -F 'installed)' '{print $2}' >T${1}5
if [  -s T${1}5 ]
then
rpm -e `cat T${1}1 T${1}3 T${1}5` `rpm -qa|grep $1`
fi  #第四层
 
rm -rf T${1}*
echo "Complete remove the $str package !"

使用方法
if [ -f fileremove ]
then
echo "you have remove the php mysql httpd !"
elif [ -f remove.sh ]
then
sh remove.sh php
sh remove.sh mysql
sh remove.sh httpd
sh remove.sh sendmail
sh remove.sh iimf
touch fileremove
else 
echo "upload remove.sh file to $str !"
exit
fi

 

 

逻辑卷的查看，最近有一硬盘出了点小故障，状况为dmesg报错

EXT3-fs error (device dm-0) in start_transaction: Journal has aborted

机器变成只读，网上找找原因说是硬盘线松动或硬盘故障，用smartools看下了硬盘是有些问题

df看下了是逻辑卷组，但只有一个sda显示

fdisk -l看了下有两硬盘

 

逻辑卷，硬盘的空间都给了/所以硬盘都不显示而是以逻辑卷组来显示

/dev/mapper/VolGroup00-LogVol00
                       12G  3.7G  7.4G  34% /

 

[root@localhost ~]# lvscan
  ACTIVE            '/dev/VolGroup00/LogVol00' [277.22 GB] inherit
  ACTIVE            '/dev/VolGroup00/LogVol01' [1.94 GB] inherit
[root@localhost ~]# vgscan
  Reading all physical volumes.  This may take a while...
  Found volume group "VolGroup00" using metadata type lvm2
[root@localhost ~]# pvscan
  PV /dev/sdb1   VG VolGroup00   lvm2 [139.72 GB / 0    free]
  PV /dev/sda2   VG VolGroup00   lvm2 [139.62 GB / 192.00 MB free]
  Total: 2 [279.34 GB] / in use: 2 [279.34 GB] / in no VG: 0 [0   ]
[root@localhost ~]# lvdisplay -v
    Finding all logical volumes
  --- Logical volume ---
  LV Name                /dev/VolGroup00/LogVol00
  VG Name                VolGroup00
  LV UUID                GdZAXw-Bmsq-TCo2-1qJa-FBaY-7uCV-BBSRVC
  LV Write Access        read/write
  LV Status              available
  # open                 1
  LV Size                277.22 GB
  Current LE             8871
  Segments               2
  Allocation             inherit
  Read ahead sectors     0
  Block device           253:0
   
  --- Logical volume ---
  LV Name                /dev/VolGroup00/LogVol01
  VG Name                VolGroup00
  LV UUID                6EGqgI-1AaJ-h13N-4lRC-7odT-YjtF-Zkydw4
  LV Write Access        read/write
  LV Status              available
  # open                 1
  LV Size                1.94 GB
  Current LE             62
  Segments               1
  Allocation             inherit
  Read ahead sectors     0
  Block device           253:1
   
[root@localhost ~]# vgdisplay -v
    Finding all volume groups
    Finding volume group "VolGroup00"
  --- Volume group ---
  VG Name               VolGroup00
  System ID             
  Format                lvm2
  Metadata Areas        2
  Metadata Sequence No  3
  VG Access             read/write
  VG Status             resizable
  MAX LV                0
  Cur LV                2
  Open LV               2
  Max PV                0
  Cur PV                2
  Act PV                2
  VG Size               279.34 GB
  PE Size               32.00 MB
  Total PE              8939
  Alloc PE / Size       8933 / 279.16 GB
  Free  PE / Size       6 / 192.00 MB
  VG UUID               hGwGpn-8NN2-IJQ0-26aI-9TjW-pPdG-CZivQN
   
  --- Logical volume ---
  LV Name                /dev/VolGroup00/LogVol00
  VG Name                VolGroup00
  LV UUID                GdZAXw-Bmsq-TCo2-1qJa-FBaY-7uCV-BBSRVC
  LV Write Access        read/write
  LV Status              available
  # open                 1
  LV Size                277.22 GB
  Current LE             8871
  Segments               2
  Allocation             inherit
  Read ahead sectors     0
  Block device           253:0
   
  --- Logical volume ---
  LV Name                /dev/VolGroup00/LogVol01
  VG Name                VolGroup00
  LV UUID                6EGqgI-1AaJ-h13N-4lRC-7odT-YjtF-Zkydw4
  LV Write Access        read/write
  LV Status              available
  # open                 1
  LV Size                1.94 GB
  Current LE             62
  Segments               1
  Allocation             inherit
  Read ahead sectors     0
  Block device           253:1
   
  --- Physical volumes ---
  PV Name               /dev/sdb1     
  PV UUID               lED756-0px4-gpOT-TloT-MniK-WZ9A-UWqocn
  PV Status             allocatable
  Total PE / Free PE    4471 / 0
   
  PV Name               /dev/sda2     
  PV UUID               j0JH3I-22V0-Jh31-VRAN-91o0-L3x8-dRXNsW
  PV Status             allocatable
  Total PE / Free PE    4468 / 6

 

 

 

服务器时区重设