ÈçºÎ¸ü¸ÄMySQLÊý¾Ý¿â´æ´¢Î»ÖÃ
$sudo nano /etc/apparmor.d/usr.sbin.mysqld
ÔÚgeditÖÐÕÒµ½/var/lib/mysql/ÕâÁ½ÐУ¬×¢Ê͵ôÕâÁ½ÐУ¬ÔÚÕâÁ½ÐÐǰ·Ö±ðÌí¼ÓÒ»¸ö·ûºÅ“#”¼´¿É×¢ÊÍ£¬ÔÚÕâÁ½ÐÐ֮ǰ»ò
Ö®ºó¼ÓÉÏÏÂÃæÄÚÈÝ£º
/home/mysql/ r,
/home/mysql/** rwk,
±£´æºóÍ˳ö£¬Ö´ÐÐÃüÁ
$sudo /etc/init.d/apparmor reload
·µ»ØReloading AppArmor profiles : done.¼´¿ÉÒÔÖØÆôMySQL·þÎñ£º
$sudo /etc/init.d/mysql start
ÖÁ´ËMySQLÊý¾Ý¿â´æ´¢Î»Öþ͸ü¸ÄÍê±ÏÁË¡£
FAQ£º
Q£ºµ±ÎÒÔËÐÐ$sudo /etc/init.d/apparmor reloadÈ´·µ»ØÐÅÏ¢
Skipping profile /etc/apparmor.d/usr.sbin.mysqld~
: Warning.
²¢ÇÒÒ²ÎÞ·¨Æô¶¯MySQL·þÎñ£¬Ôõô°ìÄØ£¿
A£º³ö ÏÖÕâ¸öÎÊÌâ¿ÉÄÜÊÇÒòΪÄãʹÓÃÁË$sudo gedit»ò$gksu geditÕâÑù×ÓµÄÃüÁîÀ´±à¼usr.sbin.mysqldÕâ¸öÅäÖÃÎļþµÄ£¬ÕâÁ½¸öͼÐνçÃæÎı¾±à¼Æ÷»áÔÚÏàͬλÖÃÉú³ÉÒ»¸ö usr.sbin.mysqld~µÄÎļþ£¬´Ó¶øÓ°ÏìÁËAppArmor¶ÁÈ¡ÅäÖÃÎļþ£¬³öÏÖÕâ¸öÎÊÌâÏÈɾ³ýÕâ¸öusr.sbin.mysqld~Îļþ£º
$sudo rm /etc/apparmor.d/usr.sbin.mysqld~
È»ºóʹÓÃ$sudo nanoÕâ¸öÖÕ¶ËÎı¾±à¼Æ÷À´±à¼ÅäÖÃÎļþ¼´¿É¡£
Ïà¹ØÎĵµ£º
Èç¹ûÖ»ÊÇÒ»¸öÊý¾Ý¿âµÄ»°£¬ÎÒÃÇÒ»°ãϰ¹ßÕâÑùд£ºmysql_select_db("guestbook")£»
mysql_query('select * from users');
µ«ÊÇÈç¹ûÊÇÁ¬½Ó¶à¸ömysql£¬ÓпÉÄܳöÏÖͬÃûµÄÊý¾Ý¿â£¬»òÕßÊý¾Ý¿âÖгöÏÖͬÃûµÄ±í£¬ËùÒԾͱØÐëÓÃÍêÕûµÄÐÎʽÁË£¬ÈçÏ´úÂ룺
<?php
$link1 = mysql_connect('localhost1','root','root');
mysql ......
²éѯ¼°É¾³ýÖØ¸´¼Ç¼µÄ·½·¨
(Ò»)
1¡¢²éÕÒ±íÖжàÓàµÄÖØ¸´¼Ç¼£¬Öظ´¼Ç¼ÊǸù¾Ýµ¥¸ö×ֶΣ¨peopleId£©À´ÅжÏ
select * from people
where peopleId in (select peopleId from people group by peopleId having count(peopleId) > 1)
2¡¢É¾³ý±íÖжàÓàµÄÖØ¸´¼Ç¼£ ......
Ò»¡¢Á¬½ÓMYSQL
¸ñʽ£º mysql -hÖ÷»úµØÖ· -uÓû§Ãû £pÓû§ÃÜÂë
1¡¢Àý1£ºÁ¬½Óµ½±¾»úÉϵÄMYSQL¡£
Ê×ÏÈÔÚ´ò¿ªDOS´°¿Ú£¬È»ºó½øÈëĿ¼ mysqlbin£¬ÔÙ¼üÈëÃüÁîmysql -uroot -p£¬»Ø³µºóÌáʾÄãÊäÃÜÂ룬Èç¹û¸Õ°²×°ºÃMYSQL£¬³¬¼¶Óû§rootÊÇûÓÐÃÜÂëµÄ£¬¹ÊÖ±½Ó»Ø³µ¼´¿É½øÈëµ½MYSQLÖÐÁË£¬MYSQLµÄÌáʾ·ûÊÇ£ºmysql>
2¡¢Àý2£ºÁ¬½Óµ½Ô ......
µÚÒ»ÕС¢mysql·þÎñµÄÆô¶¯ºÍÍ£Ö¹
net stop mysql
net start mysql
µÚ¶þÕС¢µÇ½mysql
Óï·¨ÈçÏ£º mysql -uÓû§Ãû -pÓû§ÃÜÂë
¼üÈëÃüÁîmysql -uroot -p£¬ »Ø³µºóÌáʾÄãÊäÈëÃÜÂ룬ÊäÈë12345£¬È»ºó»Ø³µ¼´¿É½øÈëµ½mysqlÖÐÁË£¬mysqlµÄÌáʾ·ûÊÇ£º
mysql>
×¢Ò⣬Èç¹ûÊÇÁ¬½Óµ½ÁíÍâµÄ»úÆ÷ÉÏ£¬ÔòÐèÒª¼ÓÈëÒ»¸ö²ÎÊý-h»úÆ÷IP
µ ......