mysql glibc包很大_mysql-5.1.50-linux-i686-glibc23.tar.gz包的安装方法 | 学步园

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