mysql server°²×°

Èý. mysql server°²×°
    ------------------ÒÔÏÂΪÀ©Õ¹£ºÉ¾³ýmysql----------------
    ɾ³ý mysql
    sudo apt-get autoremove --purge mysql-server-5.0
    sudo apt-get remove mysql-server
    sudo apt-get autoremove mysql-server
    sudo apt-get remove mysql-common //Õâ¸öºÜÖØÒª  Ó¦¸ÃΪ×Ô¶¯É¾³ýautoremove
    ÉÏÃæµÄÆäʵÓÐһЩÊǶàÓàµÄ¡£
    ÇåÀí²ÐÁôÊý¾Ý
    dpkg -l |grep ^rc|awk '{print $2}' |sudo xargs dpkg -P
    --------------------À©Õ¹Íê±Ï--------------------------
1. mysql server°²×°
    1.sudo apt-get install mysql-server mysql-client
    2.ÊäÈërootÃÜÂëΪroot
    3.¸ü¸Ämysql×î´óÁ¬½ÓÊý£º
    sudo gedit /etc/mysql/my.cnf Ôö¼Ó»òÐÞ¸Ämax_connections=1024;
2.½øÈëmysql:
    sudo mysql –u root -p  ÊäÈëÃÜÂëroot½øÈë¡£
3.Ìí¼Ó/ɾ³ýȨÏÞ
    Óï·¨ÈçÏ£º
    grant all privileges(or other options) on *.* (or others) to username@"localhost( or % or otherIP)" identified by"username" (or with grant option);Èôwith         grant optionÔòΪ³¬¼¶Óû§¡£
   
    revoke all privileges (or other options) on *.* (or others) from username(or username@"localhost( or % or otherIP)");
    ĬÈÏ°²×ªÒѾ­ÎªrootÌí¼ÓÁ˱¾»úȨÏÞ,»ØÊÕȨÏÞʱÇëÉ÷ÖضÔrootȨÏÞ»ØÊÕ¡£
    ×¢£º»ØÊÕȨÏÞ²¢²»É¾³ýÓû§¡£Èç¹ûÏëɾ³ý£¬ÐèÒªdelete from user where USER like '...'
    ¼ÓȨÏÞµÄÓû§´´½¨£º
    eg:mysql>grant all privileges on epaper.* to wenxin@'localhost' identified by 'xinwen365';   Òâ˼ÊÇ:ÔÊÐíwenxin´Ó±¾µØ·ÃÎÊepaperÊý¾Ý¿â²¢ÇÒ¾ßÓжԸÃÊý¾Ý¿âµÄËùÓвÙ×÷
       mysql>grant all privileges on epaper.* to wenxin@'%' identified by 'xinwen365'; &nbs