环境配置

1. weblogic

2 . ADF Runtime 安装缺少的包

3. mysql 直接使用rpm安装client和server会遇到缺少包的问题 

    相关命令：rpm -ivh  **.rpm

4. yum安装mysql

   相关命令：yum list mysql*  查找当前安装的mysql

                       yum install mysql

                       yum install mysql-server

                       yum install mysql-client

                       yum install mysql-devel

5.首次修改密码  mysqladmin -u root password 'root'

   再次修改密码   mysqladmin -u root -proot password '1234'

   启动服务：service mysqld start

   登陆：mysql -u root -p

   关闭服务：service mysqld stop

6.远程访问mysql

1.登陆mysql，修改权限

GRANT ALL PRIVILEGES ON *.* TO 'myuser'@'%' IDENTIFIED BY 'mypassword' WITH GRANT OPTION;

FLUSH PRIVILEGES;

2.配置防火墙 vi /etc/sysconfig/iptables

:INPUT ACCEPT [0:0]
:FORWARD ACCEPT [0:0]
:OUTPUT ACCEPT [0:0]
-A INPUT -m state --state ESTABLISHED,RELATED -j ACCEPT
-A INPUT -p icmp -j ACCEPT
-A INPUT -i lo -j ACCEPT
-A INPUT -m state --state NEW -m tcp -p tcp --dport 22 -j ACCEPT
-A INPUT -m state --state NEW -m tcp -p tcp --dport 3306 -j ACCEPT
-A INPUT -j REJECT --reject-with icmp-host-prohibited
-A FORWARD -j REJECT --reject-with icmp-host-prohibited
COMMIT

注意：红色部分即为添加的部分，注意放在icmp-host-prohibited之前，否则不会生效

修改完毕  service iptables restart

7 mysql fetching

mysql_upgrade -p -u root

ps:

search port:   netstat -tunlp|grep 3306