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端口被打开,就安装完毕。