MySql¼òÒױʼÇ
MySql¼òÒױʼÇ
1£º°²×°http://download.mysql.cn/src/2006/0710/5543.html£»
2£º´ò¿ªmysqlµÄCMD
3£º´´½¨Ò»¸öÊý¾Ý¿â¼°±í£º
mysql> CREATE DATABASE bbs;
mysql> CREATE TABLE pet (name VARCHAR(20), owner VARCHAR(20),
-> species VARCHAR(20), sex CHAR(1), birth DATE, death DATE);
4£º²é¿´£º
show databases;
show tabales;
describe pet;
5:µ¼³ö³É*.sqlÎļþ
ÔÚϵͳcmdÏÂʹÓÃÃüÁmysqljump -u root –p test > c:\test.sql
»ù±¾¹¦ÄܾʹËOK£¡
Ïà¹ØÎĵµ£º
²éѯ¼°É¾³ýÖظ´¼Ç¼µÄ·½·¨
(Ò»)
1¡¢²éÕÒ±íÖжàÓàµÄÖظ´¼Ç¼£¬Öظ´¼Ç¼ÊǸù¾Ýµ¥¸ö×ֶΣ¨peopleId£©À´ÅжÏ
select * from people
where peopleId in (select peopleId from people group by peopleId having count(peopleId) > 1)
2¡¢É¾³ý±íÖжàÓàµÄÖظ´¼Ç¼£ ......
Ê×ÏÈÉèÖÃmysqlµÄ±àÂëΪutf8
ÔÚlinuxÏÂÐ޸ģ³¸ömy.cnfµÄ£±¸ö/etc/mysql
/my.cnfÎļþ
ÕÒµ½¿Í»§¶ËÅäÖÃ[client] ÔÚÏÂÃæÌí¼Ó
default-character-set=utf8 ĬÈÏ×Ö·û¼¯Îªutf8
ÔÚÕÒµ½[mysqld] Ìí¼Ó
default-character-set=utf8 ĬÈÏ×Ö·û¼¯Îªutf8
init_connect='SET NAMES utf8' £¨É趨Á¬½Ómysql
Êý¾Ý¿âʱʹÓÃutf8±àÂ룬ÒÔÈà ......
Ò»ÖÖ±íÇý¶¯,³ýÁËinnodb»¹ÓÐÆäËüµÄ,ÀýÈçisam,myisamµÈ.
innodbµÄÌØÉ«ÔÚÓÚÖ§³Ö²¢·¢Óë±í¼äÒýÓÃ
MySQLÖ§³Ö¶àÖÖ´æ´¢ÒýÇ棬Óû§¿ÉÒÔ·½±ãµÄÑ¡Óò»Í¬µÄ´æ´¢ÒýÇæÀ´Ö§³Ö×Ô¼ºµÄÓ¦Óã¬Ã¿ÖÖ²»Í¬µÄ´æ´¢ÒýÇ涼ÓÐÆä×Ô¼ºµÄÌØÐÔ
InnodbÊÇÆäÖеÄÒ»ÖÖ´æ´¢ÒýÇ棬ËüµÄÌØÐÔÊÇÖ§³ÖÊÂÎñ£¬²¢ÇÒ²ÉÓöà°æ±¾²¢·¢¿ØÖƵķ½Ê½À´Ìá¸ß²¢·¢¶È
Ö÷Òª ......
1¡¢ÏµÍ³¹ÜÀí
¡¡¡¡mysql -hÖ÷»úµØÖ· -uÓû§Ãû -p
¡¡¡¡Á¬½ÓMYSQL(ÔÚmysql/bin)
¡¡¡¡exit
¡¡¡¡Í˳öMYSQLÃüÁî
¡¡¡¡mysqladmin -uÓû§Ãû -p¾ÉÃÜÂë passwordÐÂÃÜÂë
¡¡¡¡ÐÞ¸ÄÃÜÂë(ÔÚmysql/bin)
¡¡¡¡grantselect[insert][,update][,delete]onÊý¾Ý¿â.*toÓû§Ãû@localhost("%"£¬ ±íʾÈκÎÖ÷»ú)identifiedby "ÃÜÂë"
¡¡¡¡ ......
$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 AppArmo ......