Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

ÈçºÎ¸ü¸Ä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Õâ¸öÖÕ¶ËÎı¾±à¼­Æ÷À´±à¼­ÅäÖÃÎļþ¼´¿É¡£


Ïà¹ØÎĵµ£º

phpÁ¬½ÓmysqlÏê½â

 Èç¹ûÖ»ÊÇÒ»¸öÊý¾Ý¿âµÄ»°£¬ÎÒÃÇÒ»°ãϰ¹ßÕâÑùд£ºmysql_select_db("guestbook")£»
mysql_query('select * from users');
µ«ÊÇÈç¹ûÊÇÁ¬½Ó¶à¸ömysql£¬ÓпÉÄܳöÏÖͬÃûµÄÊý¾Ý¿â£¬»òÕßÊý¾Ý¿âÖгöÏÖͬÃûµÄ±í£¬ËùÒԾͱØÐëÓÃÍêÕûµÄÐÎʽÁË£¬ÈçÏ´úÂ룺
<?php
$link1 = mysql_connect('localhost1','root','root');
mysql ......

MySQL²éѯ¼°É¾³ýÖØ¸´¼Ç¼µÄ·½·¨

 ²éѯ¼°É¾³ýÖØ¸´¼Ç¼µÄ·½·¨
(Ò»)
1¡¢²éÕÒ±íÖжàÓàµÄÖØ¸´¼Ç¼£¬Öظ´¼Ç¼ÊǸù¾Ýµ¥¸ö×ֶΣ¨peopleId£©À´ÅжÏ
select * from people
where peopleId in (select  peopleId  from  people  group  by  peopleId  having  count(peopleId) > 1)
2¡¢É¾³ý±íÖжàÓàµÄÖØ¸´¼Ç¼£ ......

³õѧMySQLÄÄЩÐèÒªÄãÖªµÀ

Ò»¡¢Á¬½ÓMYSQL
¸ñʽ£º mysql -hÖ÷»úµØÖ· -uÓû§Ãû £­pÓû§ÃÜÂë
1¡¢Àý1£ºÁ¬½Óµ½±¾»úÉϵÄMYSQL¡£
Ê×ÏÈÔÚ´ò¿ªDOS´°¿Ú£¬È»ºó½øÈëĿ¼ mysqlbin£¬ÔÙ¼üÈëÃüÁîmysql -uroot -p£¬»Ø³µºóÌáʾÄãÊäÃÜÂ룬Èç¹û¸Õ°²×°ºÃMYSQL£¬³¬¼¶Óû§rootÊÇûÓÐÃÜÂëµÄ£¬¹ÊÖ±½Ó»Ø³µ¼´¿É½øÈëµ½MYSQLÖÐÁË£¬MYSQLµÄÌáʾ·ûÊÇ£ºmysql>
2¡¢Àý2£ºÁ¬½Óµ½Ô ......

Mysql³£ÓÃÃüÁîÐÐ

µÚÒ»ÕС¢mysql·þÎñµÄÆô¶¯ºÍÍ£Ö¹
net stop mysql
net start mysql
µÚ¶þÕС¢µÇ½mysql
Óï·¨ÈçÏ£º mysql -uÓû§Ãû -pÓû§ÃÜÂë
¼üÈëÃüÁîmysql -uroot -p£¬ »Ø³µºóÌáʾÄãÊäÈëÃÜÂ룬ÊäÈë12345£¬È»ºó»Ø³µ¼´¿É½øÈëµ½mysqlÖÐÁË£¬mysqlµÄÌáʾ·ûÊÇ£º
mysql>
×¢Ò⣬Èç¹ûÊÇÁ¬½Óµ½ÁíÍâµÄ»úÆ÷ÉÏ£¬ÔòÐèÒª¼ÓÈëÒ»¸ö²ÎÊý-h»úÆ÷IP
µ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ