1领斥、首先下載MySQL的安裝文件,我這里安裝的是MySQL5.1.7版本的?
2沃暗、查看linux系統(tǒng)中是否安裝了mysql ? ?執(zhí)行:rpm -qa|grep -i mysql ?如有會顯示已安裝的Mysql版本,我的顯示mysql-libs-5.1.61-4.el6.i68
6
3月洛、這時如果有的話就強制刪除:rpm -e --nodeps mysql-libs-5.1.61-4.el6.i686(因為有包依賴,所以要強制刪除)
在你沒有強制刪除時安裝mysql
我的報錯提示如下:
MySQL-server-5.1.7-0.i386.rpm
Preparing...???????????????########################################### [100%]
file /usr/share/mysql/charsets/READMEfrom install of MySQL-server-5.1.7-0.i386.rpm?conflicts with file frompackagemysql-libs-5.1.61-4.el6.i686
?file /usr/share/mysql/charsets/Index.xmlfrom install of MySQL-server-5.1.7-0.i386.rpm?conflicts with file frompackagemysql-libs-5.1.61-4.el6.i686
file /usr/share/mysql/charsets/armscii8.xmlfrom install of MySQL-server-5.1.7-0.i386.rpm?conflicts with file frompackagemysql-libs-5.1.61-4.el6.i686
file /usr/share/mysql/charsets/ascii.xmlfrom install of MySQL-server-5.1.7-0.i386.rpm?conflicts with file frompackagemysql-libs-5.1.61-4.el6.i686
?file /usr/share/mysql/charsets/cp1250.xmlfrom install of MySQL-server-5.1.7-0.i386.rpm?conflicts with file frompackagemysql-libs-5.1.61-4.el6.i686 孽锥。嚼黔。。惜辑。唬涧。。
4韵丑、到mysql安裝包路徑下執(zhí)行:rpm -ivh MySQL-server-5.1.7-0.i386.rpm我這里安裝成功了爵卒,但是mysql服務(wù)無法啟動,總是啟動失敗撵彻,后來百度了一下钓株,是因為selinux的原因,只要將selinux關(guān)閉就OK了陌僵。關(guān)閉selinux:vi /etc/selinux/config?將SELINUX=enforcing改成SELINUX=disabled然后重啟
5轴合、關(guān)閉selinux之后還是無法啟動mysql服務(wù),因為安裝的mysql所有者是root碗短,在安裝mysql的時候會創(chuàng)建一個用戶mysql受葛,只要將/var/lib/mysql的所有者改為mysql就OK了,執(zhí)行命令:chown -R mysql:mysql /var/lib/mysql
6偎谁、現(xiàn)在執(zhí)行:service mysql start
7总滩、安裝MySQL客戶端 執(zhí)行命令rpm -ivhMySQL-client-5.1.7-0.i386.rpm進(jìn)行安裝。
8巡雨、安裝成功
成功安裝MySQL后將sql文件導(dǎo)入到數(shù)據(jù)庫闰渔,步驟如下:
進(jìn)入MYSQL Command Line Client
1、先創(chuàng)建數(shù)據(jù)庫:create database test注:test是創(chuàng)建數(shù)據(jù)庫的名稱2铐望、再切換到當(dāng)前數(shù)據(jù)庫:use test
3冈涧、再輸入:\. /root/test.sql或?souce /root/test.sql
按照以上步驟就可以將備份的sql腳本導(dǎo)入到linux中的數(shù)據(jù)庫中去茂附。
# mysql -uroot -p
Enter password:
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
使用網(wǎng)上介紹的方法修改root用戶的密碼:
# mysqladmin -uroot -p password 'newpassword'
Enter password:
mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'root'@'localhost' (using password: YES)'
現(xiàn)在終于被我找到了解決方法,如下(請先測試方法三督弓,謝謝S):
方法一:
# /etc/init.d/mysql stop
# mysqld_safe --user=mysql --skip-grant-tables --skip-networking &
# mysql -u root mysql
mysql> UPDATE user SET Password=PASSWORD('newpassword') where USER='root';
mysql> FLUSH PRIVILEGES;
mysql> quit
# /etc/init.d/mysql restart
# mysql -uroot -p
Enter password: <輸入新設(shè)的密碼newpassword>
mysql>