mysql°²×°Ê¹ÓÃÊÖ¼Ç

ɾ³ýrpm°ü
    rpm -e mysql-embedded-5.1.39-4.fc12.i686 --nodeps
°²×°rpm°ü
    rpm -vih MySQL-server-community-5.1.37-0.rhel5.i386.rpm
²éѯÒÑ°²×°µÄrpm°ü
    rpm -qa | grep MySQL
Æô¶¯mysql
    mysql£¨Ã»ÓÐÃÜÂëµÄÇé¿ö£©
    mysql -u root -p£¨ÓÐÃÜÂëµÄÇé¿ö£¬È»ºómysql»áÌáʾÊäÈëÃÜÂ룩
ɾ³ýMySQLµÄrootÃÜÂëµÄ·½·¨£¬ÔÚ mysql> ÏÂÊäÈëÒÔÏÂ2ÐÐ:
    GRANT USAGE ON *.* TO root@localhost IDENTIFIED BY ''; 
    FLUSH PRIVILEGES;
µ¼³öSQL½Å±¾
    mysqldump -uÓû§Ãû -p Êý¾Ý¿âÃû > Êý¾Ý¿âÃû.sql
    mysqldump -u root DB_FOR_ALARM > data.sql
Ö´ÐÐSQL½Å±¾£¬ÔÚ mysql> ÏÂÊäÈë
    source ./SP_DB.sql
    DROP DATABASE IF EXISTS DB_FOR_ALARM;
    CREATE DATABASE DB_FOR_ALARM;