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

MySQL安装与配置

最新推荐文章于 2022-04-06 19:31:07 发布

原创最新推荐文章于 2022-04-06 19:31:07 发布 · 202 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#MySQL #Java #防火墙 #Tomcat #Blog

本文介绍如何从源码编译安装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