mysql-5.1.50-linux-i686-glibc23.tar.gz包的安装方法

  mysql-5.1.50-linux-i686-glibc23.tar.gz包的安装方法

http://ftp.iij.ad.jp/pub/db/mysql/Downloads/MySQL-5.1/mysql-5.1.30-linux-i686-glibc23.tar.gz

# tar -zvxf mysql-max-5.1.30-linux-i686-glibc23.tar.gz
# mv mysql-max-5.1.30-linux-i686-glibc23 /usr/local/mysql
# cp /usr/local/mysql/support-files/my-medium.cnf /etc/my.cnf
# groupadd mysql
# useradd -g mysql mysql
# chown -R root /usr/local/mysql
# chgrp -R mysql /usr/local/mysql
# chown -R mysql /usr/local/mysql/data
# cd /usr/local/mysql

修改/etc/my.cnf ，打开[client] 中的password，设置密码

# scripts/mysql_install_db --user=mysql

如果有错误发生，执行
# sed -i 's/log-bin=mysql-bin/#log-bin=mysql-bin/g' /etc/my.cnf
# sed -i 's/binlog_format=mixed/#binlog_format=mixed/g' /etc/my.cnf
# sed -i 's/skip-locking/skip-locking/nmax_connections = 1000/nwait_timeout = 5/g' /etc/my.cnf

重新初始化

# scripts/mysql_install_db --user=mysql

# cp support-files/mysql.server /etc/rc.d/init.d/mysqld
# chmod 755 /etc/rc.d/init.d/mysqld
# chkconfig --add mysqld
# chkconfig mysqld on
# service mysqld start
# bin/mysqladmin -u root password 123654

此时，执行

# bin/mysqlshow

可以正常看到表

当用windows客户端端连接时，会出现1103的错误，此时可以通过修改user表解决
# bin/mysql -e "select user,host from user " mysql

可以看到user host表中的内容，然后
# bin/mysql -e "update user set host = '%' where user = 'root' and host = 'localhost' " mysql

这样客户端就可以连接了

# netstat -nat

如果3306端口被打开，就安装完毕。