mysql5.1在redhat_在redhat下安装mysql5.1.30.

先从网上下载mysql5.1.x版本的tar.gz的包。下面是安装过程：

chmod 755 mysql-5.1.30.tar.gz tar -zxvf mysql-5.1.30.tar.gz -C /usr/src/

cd /usr/src/mysql-5.1.30

./configure --prefix=/usr/local/mysql --with-charset=gbk --localstatedir=/usr/local/mysql/data

make

make install

groupadd mysql

useradd mysql -g mysql

cd /usr/local/mysql/bin

./mysql_install_db --user=mysql

cd /usr/local/mysql

chown -R root .

chgrp -R mysql .

cp /usr/local/mysql/share/mysql/mysql.server /etc/init.d/mysqld

修改配置文件： change /etc/my.cnf to below:

*****************start************

[mysqld]

datadir=/var/lib/mysql

socket=/var/lib/mysql/mysql.sock

user=mysql

# Default to using old password format for compatibility with mysql 3.x

# clients (those using the mysqlclient10 compatibility package).

old_passwords=1

[mysqld_safe]

log-error=/var/log/mysqld.log

pid-file=/var/run/mysqld/mysqld.pid

socket=/var/lib/mysql/mysql.sock

[mysqladmin]

socket=/var/lib/mysql/mysql.sock

[mysql]

socket=/var/lib/mysql/mysql.sock

*****************end************

cd /etc/init.d/

# chmod 777 mysqld

# chkconfig mysqld

# chkconfig --add mysqld

# chkconfig --level 345 mysqld on

# service mysqld start

配置mysql在远程的本机都能登陆： # cp /usr/local/mysql/bin/* /usr/bin/     # netstat -tnl |grep 3306 # /usr/local/mysql/bin/mysqladmin -uroot password admin mysql -uroot -p #进入mysql      #为了开发方便,可以让root用户具有远程访问的权限                                                        mysql>use mysql; mysql>update user set password=old_password('新密码'); mysql> flush privileges;                                                           mysql> grant all on *.* to root@'%' identified by 'admin';                     #grant 权限 on 数据库名.表名 to 用户@登录主机(%代表所有主机) identified by "用户密码";                                                                          mysql> flush privileges;       ERROR 1042 (00000): Can't get hostname for your address解决方案 [root@sv245 mysql]# cp /opt/lampp/etc/my.cnf /etc/my.cnf [root@sv245 mysql]# vi /etc/my.cnf 在配置文件中增加： [mysqld]下增加下面一句话： skip-name-resolve [root@sv245 mysql]# service mysql restart ok，连接成功： 注释： #1：去掉mysql启动参数中的skip-name-resolve ，然后jdbc连接串用ip地址和主机名均可。 #2：如果保留启动参数skip-name-resolve 的话，在jdbc连接串中只能使用IP地址的方式连接数据库。