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
--怎么编译,怎么安装
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