转载自bigman
+ 酒店1.0服务端环境设置的笔记软件环境配置: LinuxAS4 mysql5.0.22 (//192.168.18.251/数据库/MySQL/MySQL-server-5.0.22) jdk1.5.0_09 (//192.168.18.251/常用软件/开发工具/jdk-1_5_0_09-linux-i586.bin) 远程登入客户端: //192.168.18.251/常用软件/SSH工具/SSHSecureShellClient-3.2.9.exe 文件传输工具: //192.168.18.251/常用软件/SSH工具/winscp382setup.exe mysql安装步骤 查看已安装的mysql版本: rpm -qa |grep mysql 卸载老版本mysql: rpm -e --nodeps mysql-4.1.20-2.RHEL4.1.i386 或者 { rpm -qa |grep MySQL rpm -e MySQL-bench-5.1.7-0 rpm -e MySQL-shared-5.1.7-0 rpm -e MySQL-client-5.1.7-0 rpm -e MySQL-devel-5.1.7-0 rpm -e MySQL-python-1.2.1_p2-1.el4.1.i386 rpm -e freeradius-mysql-1.0.1-3.RHEL4.3.i386 rpm -e MySQL-server-5.1.7-0 } 安装新版本mysql: # cd MySQL-server-5.0.22 # rpm -ivh MySQL* 启动mysql服务: service mysql start 停止mysql服务: service mysql stop 修改数据库配置: # cp /usr/share/mysql/my-huge.cnf /etc/my.cnf # vi /etc/my.cnf (在该文件中加入: default-table-type=innodb default-character-set=utf8 ) # vi /etc/rc.d/init.d/mysql {在该文件中找到这行并修改: #### $bindir/mysqld_safe --datadir=$datadir --pid-file=$server_pid_file >/dev/null 2>&1 & $bindir/mysqld_safe --datadir=$datadir --skip-name-resolve --pid-file=$server_pid_file >/dev/null 2>&1 & wait_for_pid created } 重新启动mysql服务: service mysql restart 创建数据库和用户 # mysql mysql> create database hpmp10; mysql> grant all on hpmp10.* to "hpmpuser"@"%" identified by "hpmppass"; mysql> grant all on *.* to "root"@"%" identified by "hpmpadmin"; 取消hpmpuser在hpmp10数据库中的所有权限: mysql> revoke all on hpmp10.* from hpmpuser; # mysql> revoke all on hpmpdev.* from "hpmpuser"@"%"; # mysql> grant select, insert, update, delete, execute on hpmpdev.* to "hpmpuser"@"%" identified by "hpmppass"; # mysql> grant select on mysql.proc to 'hpmpuser'@'%' identified by 'hpmppass'; // jdbc执行存储过程要加这行,否则,错误信息(1) # mysql> flush privileges; 给root用户添加密码: # mysqladmin -u root password hpmpadmin 没有关闭防火墙时,远程连接出现如下错误 [root@localhost ~]# mysql -h192.168.18.102 -uroot -phpmpadmin ERROR 2003 (HY000): Can't connect to MySQL server on '192.168.18.102' (113) # service iptables stop jdk安装步骤 # chmod u+x jdk-1_5_0_09-linux-i586.bin # ./jdk-1_5_0_09-linux-i586.bin # mkdir /usr/java # cp -fr jdk1.5.0_09 /usr/java # vi /etc/profile (在该文件中加入: export JAVA_HOME=/usr/java/jdk1.5.0_09 export CLASSPATH=$CLASSPATHJAVA_HOME/libJAVA_HOME/jre/lib export PATH=$JAVA_HOME/binJAVA_HOME/jre/binPATHHOME/bin ) # reboot -n # java -version