利用rpm安裝mysql

yum install ncurses-libs.i686 libstdc++.i686 libgcc.i686

http://rpm.pbone.net/index.php3/stat/3/srodzaj/1/search/libaio.so.1%28LIBAIO_0.1%29

需要libaio庫

 

先查看系統中是否已經安裝過MySQL:
rpm -qa|grep mysql  

MySQL-server-VERSION.rpm
mysql服務檔案包(若串連遠程伺服器，可不用安裝此包)
MySQL-client-VERSION.rpm
mysql用戶端
一般只需要安裝這2個檔案包即可。

 查看安裝包資訊：

shell> rpm -qpl MySQL-server-VERSION.glibc23.i386.rpm

 安裝一下2個檔案包： 

shell> rpm -i MySQL-server-VERSION.glibc23.i386.rpmshell> rpm -i MySQL-client-VERSION.glibc23.i386.rpm

To install only the client programs, install just the client RPM:

shell> rpm -i MySQL-client-VERSION.glibc23.i386.rpm

安裝完成後需要重新啟動電腦，之後輸入mysql即可啟動mysql

若提示"Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) "錯誤，則需要重新啟動一下電腦

安裝完成以後可以使用mysqladmin命令修改初始密碼：



 mysqladmin -u root password 'new-passwd'
 /usr/bin/mysqladmin -u root password 'new-password'
 /usr/bin/mysqladmin -u root -h bogon password 'new-password'

目錄結構：

/usr/bin	Client programs and scripts
/usr/sbin	The mysqld server
/var/lib/mysql	Log files, databases
/usr/share/info	Manual in Info format
/usr/share/man	Unix manual pages
/usr/include/mysql	Include (header) files
/usr/lib/mysql	Libraries
/usr/share/mysql	Miscellaneous support files, including error messages, character set files, sample configuration files, SQL for database installation
/usr/share/sql-bench	Benchmarks