1，先看看系統(tǒng)中是否自帶其它版本的MySQL，命令如下：
#rpm -qa|grep MySQL
或
#rpm -qa|grep mysql
如果帶有此軟件，請(qǐng)先用rpm -e將這些軟件干掉，命令如下：
#rpm -e mysql*****(此處為你的包名，即上面查詢出來的名字)
如果在刪除的過程中提示因?yàn)橐恍┮蕾囮P(guān)系無法刪除，請(qǐng)用如下命令：
#rpm -e --nodeps mysql*****

2，去MySQL的官方網(wǎng)站上下載RPM包，根據(jù)你的服務(wù)器的CPU型號(hào)和Redhat版本選擇不同的RPM包(包括服務(wù)端和客戶端的包)，地址如下：
http://dev.mysql.com/downloads/mysql/5.0.html

3，在Redhat中新增用戶和用戶組，命令如下：
#groupadd mysql
#useradd -g mysql mysql

4，將下載的放到Redhat的某一目錄下，分別執(zhí)行命令安裝服務(wù)端和客戶端的RPM包，命令如下：
#rpm -ivh MySQL-server-community-5.0.67-0.rhel4.i386.rpm
#rpm -ivh MySQL-client-community-5.0.67-0.rhel4.i386.rpm

5，修改root用戶的密碼：
# killall mysqld
# 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

6，修改root用戶遠(yuǎn)程訪問的權(quán)限：
# killall mysqld
# mysqld_safe --user=mysql &
# mysql -u root -p mysql
Enter password: (輸入第5步中修改后的新密碼)
mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'root' WITH GRANT OPTION;
mysql> FLUSH PRIVILEGES;
mysql> quit

 

如果以上步驟不行

{

5，修改root用戶遠(yuǎn)程訪問的權(quán)限：

# killall mysqld

# mysqld_safe --user=mysql &

# mysql -u root -p mysql

Enter password: (輸入第5步中修改后的新密碼)

mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'root' WITH GRANT OPTION;

mysql> FLUSH PRIVILEGES;

mysql> quit

mysql> delete from user where host<>'%';

6，修改root用戶的密碼：(密碼丟失的時(shí)候可以用這種發(fā)式修改密碼)

# killall mysqld

# mysqld_safe --user=mysql --skip-grant-tables --skip-networking &

# mysql -u root mysql

mysql> UPDATE user SET Password=PASSWORD('orient5757') where USER='root';

mysql> FLUSH PRIVILEGES;

mysql> quit

7,重新啟動(dòng)

killall mysqld

service mysql start

}

7:相關(guān)使用

backup
C:\Documents and Settings\Administrator>mysqldump -u root -h localhost -p123456  pink>c:\c.sql

//-p123456不空格就不提示輸入密碼
C:\Documents and Settings\Administrator>mysqldump -u root -h localhost -porient5757  pink>/work/pink.sql

restore
C:\Documents and Settings\Administrator>mysql -u root -p123456 -h localhost pink</work/c.sql

//-p123456不空格就不提示輸入密碼
C:\Documents and Settings\Administrator>mysql -u root -p123456 -h localhost dump<c:\c.sql

修改密碼
UPDATE user SET Password=PASSWORD('newpassword') where USER='root';
FLUSH PRIVILEGES;

授權(quán)
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '123456' WITH GRANT OPTION;
flush privileges;

登陸

mysql -u root -h localhost -porient5757

show databases;
use mysql;
show tables;
desc user;