mysql 安装 更改目录属性 - 网卡配置

http://bailkai.blog.163.com/blog/static/82011736200983095924807/

--怎么编译，怎么安装
http://www.08.la/news2010/newshtml/JiShuWenZhang/Mysql/20407.html


./configure -prefix=/data1/mysql -enable-thread-safe-client -with-extra-charsets=utf8 -with-plugins=all

chown -R root /data1/mysql
chgrp -R mysql /data1/mysql
chown -R mysql /data1/mysql/var


http://dev.mysql.com/get/Downloads/MySQL-5.1/MySQL-server-5.1.51-1.glibc23.i386.rpm/from/http://mysql.mirror.tw/


http://dev.mysql.com/get/Downloads/MySQL-5.1/MySQL-client-5.1.51-1.glibc23.i386.rpm/from/http://mysql.mirror.tw/


rpm -ivh MySQL-server-5.1.51-1.glibc23.i386.rpm MySQL-client-5.1.51-1.glibc23.i386.rpm


./mysqladmin -u root password 'xiaoxiao'

# rpm -ivh MySQL-server-5.1.51-1.glibc23.i386.rpm MySQL-client-5.1.51-1.glibc23.i386.rpm warning: MySQL-server-5.1.51-1.glibc23.i386.rpm: V3 DSA signature: NOKEY, key ID 5072e1f5
Preparing... ########################################### [100%]
1:MySQL-client ########################################### [ 50%]
2:MySQL-server ########################################### [100%]

PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
To do so, start the server, then issue the following commands:

/usr/bin/mysqladmin -u root password 'new-password'
/usr/bin/mysqladmin -u root -h localhost.localdomain password 'new-password'

Alternatively you can run:
/usr/bin/mysql_secure_installation

which will also give you the option of removing the test
databases and anonymous user created by default. This is
strongly recommended for production servers.

See the manual for more instructions.

Please report any problems with the /usr/bin/mysqlbug script!


create database name character set utf8

grant create on omfp.* to root@'127.0.0.1';

grant all on *.* to root@'%' identified by 'xiaoxiao';

-A RH-Firewall-1-INPUT -m state --state NEW -m tcp -p tcp --dport 3306 -j ACCEP
====================================
网卡配置
-- 配置属性文件
/etc/profile

JAVA_HOME=/usr/java/jdk1.6.0_21
CLASSPATH=.:$CLASSPATH:$JAVA_HOME/lib:$JAVA_HOME/jre/lib:$JAVA_HOME/bin/bootstrap.jar:$JAVA_HOME/lib/dt.jar:$JAVA_HOME/lib/tools.jar:$JAVA_HOME/lib/mysql-connector-java-3.2.0.jar
PATH=.:$PATH:$JAVA_HOME/bin:$JAVA_HOME/jre/bin
CATALINA_BASE=/usr/tomcat6
CATALINA_HOME=/usr/tomcat6
CATALINA_TMPDIR=/usr/tomcat6/temp
JRE_HOME=/usr
TOMCAT_HOME=/usr/tomcat6


--网卡配置命令

--eth0
DEVICE=eth0
BOOTPROTO=static
HWADDR=00:11:25:3E:AA:00
ONBOOT=yes
TYPE=Ethernet


cd /etc/sysconfig/network-scripts/ifcfg-eth1
vi ifcfg-eth1
--eth1
DEVICE=eth1
BOOTPROTO=static
HWADDR=00:11:25:3E:AA:01
ONBOOT=yes
TYPE=Ethernet
IPADDR=58.61.153.55
NETMASK=255.255.255.192
GATEWAY=58.61.153.1

--禁用防火墙
service iptables stop
service network restart


--DHCP配置

--找到/etc/resolv.conf文件vi

#search localdomain CNCT server
nameserver 202.96.134.133