端口操作 centos&ub

iptables -I INPUT -p tcp -m state –state NEW -m tcp –dport 3306 -j ACCEPT iptables -I INPUT -p tcp –dport 80 -j ACCEPT

iptables -D INPUT -p tcp -m state –state NEW -m tcp –dport 3306 -j ACCEPT //删除

sudo ufw allow 8002 //ub

netstat -apn | grep 9507 //查看

用户操作

//简单粗暴

groupadd www useradd –shell /sbin/nologin -g www www //安全方式运行 groupadd -r mysql useradd -g mysql -r -s /sbin/nologin -M -d /mydata/data mysql

升级内核centos6.2

导入证书

rpm –import https://hkg.mirror.rackspace.com/centos/RPM-GPG-KEY-CentOS-6

yum install -y https://hkg.mirror.rackspace.com/elrepo/kernel/el6/x86_64/RPMS/kernel-ml-4.11.2-1.el6.elrepo.x86_64.rpm //添加源

yum –enablerepo=elrepo-kernel install -y kernel-ml //安装当前最新内核，以后升级内核直接运行这句就可

或是用

rpm -ivh https://hkg.mirror.rackspace.com/elrepo/kernel/el6/x86_64/RPMS/kernel-ml-4.11.2-1.el6.elrepo.x86_64.rpm //–force //方式安装force跳过错误

rpm -qa | grep kernel //查看内核

升级完内核，自动按最新内核启动，修改以下文件

vi /boot/grub/grub.conf

vi /etc/grub.conf

修改成 GRUB_DEFAULT=0

warning: rpmts_HdrFromFdno: Header V3 DSA signature: NOKEY, key ID***** 解决

rpm –import /etc/pki/rpm-gpg/RPM*

mysql操作

更改密码

update mysql.user set authentication_string=PASSWORD(“password”) where user=”root”;

FLUSH PRIVILEGES;

增加远程方式

GRANT ALL PRIVILEGES ON . TO ‘root’@’%’IDENTIFIED BY ‘password’ WITH GRANT OPTION;

备份还原

mysqldump -uroot -p db1 db2 db3>/home/data.sql

mysql -uroot -p db库</home/data.sql

转载请注明：TUTERM.COM » Linux学习笔记