首选查看是否安装了linux自带的mysql,如果有可以卸载后再安装。
#rpm -qa|grep -i mysql
卸载mysql
#rpm -ev mysqlclient10-3.23.58-4.RHEL4.1
rpm -ev mysql-4.1.12-3.RHEL4.1
如果出现如下错误:
#rpm -e mysql-4.1.12-3.RHEL4.1
error: Failed dependencies:
libmysqlclient.so.14 is needed by (installed) cyrus-sasl-sql-2.1.19-5.EL4.i386
libmysqlclient.so.14 is needed by (installed) dovecot-0.99.11-2.EL4.1.i386
那么,你需要按倒序来先删除dovecot-0.99.11-2.EL4.1.i386,然后是cyrus-sasl-sql-2.1.19-5.EL4.i386,最后,你可以完全删除mysql-devel,其他的类似。
#rpm -e cyrus-sasl-sql-2.1.19-5.EL4.i386
#rpm -e libmysqlclient.so.14
#rpm -ev mysql-4.1.12-3.RHEL4.1
下面开始安装mysql
#tar -zvxf mysql-5.0.40.tar.gz
#id mysql //查看是否建立mysql用户名和用户组,如果没有,请先建立。
#groupadd mysql
#useradd -g mysql mysql
#cd mysql-5.0.40
#./configure -prefix=/usr/local/mysql -with-charset=gbk -with-extra-charsets=all //默认字符集是GBK,带扩展字符集。
#make
#make install
#cp support-files/my-medium.cnf /etc/my.cnf
#./scripts/mysql_install_db --user=mysql
//初试化表并且规定用mysql用户来访问。初始化表以后就开始给mysql和root用户设定访问权限
#chown -R root /usr/local/mysql
#chown -R mysql /usr/local/mysql/var
#chown -R mysql /usr/local/mysql/var/.
#chown -R mysql /usr/local/mysql/var/
#chown -R mysql /usr/local/mysql/var/mysql
#chown -R mysql /usr/local/mysql/var/mysql/
#chown -R mysql /usr/local/mysql/var/mysql/.
#chgrp -R mysql /usr/local/mysql
# cp support-files/mysql.server /etc/rc.d/init.d/mysqld
# chmod 700 /etc/init.d/mysqld
# chkconfig --add mysqld
# chkconfig --level 345 mysqld on
# service mysqld start
# netstat -atln 查看mysql端口3306是否打开,如果打开说明安装成功
设置mysql 中root密码:/usr/local/mysql/bin/mysqladmin -u root password 'new-password'
#rpm -qa|grep -i mysql
卸载mysql
#rpm -ev mysqlclient10-3.23.58-4.RHEL4.1
rpm -ev mysql-4.1.12-3.RHEL4.1
如果出现如下错误:
#rpm -e mysql-4.1.12-3.RHEL4.1
error: Failed dependencies:
libmysqlclient.so.14 is needed by (installed) cyrus-sasl-sql-2.1.19-5.EL4.i386
libmysqlclient.so.14 is needed by (installed) dovecot-0.99.11-2.EL4.1.i386
那么,你需要按倒序来先删除dovecot-0.99.11-2.EL4.1.i386,然后是cyrus-sasl-sql-2.1.19-5.EL4.i386,最后,你可以完全删除mysql-devel,其他的类似。
#rpm -e cyrus-sasl-sql-2.1.19-5.EL4.i386
#rpm -e libmysqlclient.so.14
#rpm -ev mysql-4.1.12-3.RHEL4.1
下面开始安装mysql
#tar -zvxf mysql-5.0.40.tar.gz
#id mysql //查看是否建立mysql用户名和用户组,如果没有,请先建立。
#groupadd mysql
#useradd -g mysql mysql
#cd mysql-5.0.40
#./configure -prefix=/usr/local/mysql -with-charset=gbk -with-extra-charsets=all //默认字符集是GBK,带扩展字符集。
#make
#make install
#cp support-files/my-medium.cnf /etc/my.cnf
#./scripts/mysql_install_db --user=mysql
//初试化表并且规定用mysql用户来访问。初始化表以后就开始给mysql和root用户设定访问权限
#chown -R root /usr/local/mysql
#chown -R mysql /usr/local/mysql/var
#chown -R mysql /usr/local/mysql/var/.
#chown -R mysql /usr/local/mysql/var/
#chown -R mysql /usr/local/mysql/var/mysql
#chown -R mysql /usr/local/mysql/var/mysql/
#chown -R mysql /usr/local/mysql/var/mysql/.
#chgrp -R mysql /usr/local/mysql
# cp support-files/mysql.server /etc/rc.d/init.d/mysqld
# chmod 700 /etc/init.d/mysqld
# chkconfig --add mysqld
# chkconfig --level 345 mysqld on
# service mysqld start
# netstat -atln 查看mysql端口3306是否打开,如果打开说明安装成功
设置mysql 中root密码:/usr/local/mysql/bin/mysqladmin -u root password 'new-password'