mysql µÄ×Ö·û±àÂë
=== ÉÔºóÔÙÕûÀí
mysql
4.0µ½mysql
5.0µÄÊý¾Ýµ¼Èë³öÏÖÂÒÂëµÄ½â¾ö·½°¸
×ÖÌå´óС£º´ó
| ÖÐ
| С
2007-02-08 17:09 -
ÔĶÁ£º485 - ÆÀÂÛ
£º0
×î½ü×ömysql
4.0µ½mysql
5.0µÄÊý¾Ýת»¯¹¤×÷£¬·¢ÏÖÂÒÂë
ÎÞÊý£¬¹Û²©¿ÍÎÞÊýÐĵÃÈçÏ£º
£ªmysql
ÖÐÎÄ亂碼µÄÔÒò
mysql
會³ö現ÖÐÎÄ亂碼µÄÔÒò²»ÍâºõÏÂÁÐ幾點£º
-mysql
server±¾Éí設¶¨問題£¬ÀýÈç還Í£ÁôÔÚ latin1
-mysql
table µÄ語ϵ設¶¨問題(°üº¬ character 與 collation)
-¿Í戶¶Ë³Ìʽ(ÀýÈç php) µÄ連線語ϵ設¶¨問題
ÕâÊÇÓÉÓÚ mysql
5.0ĬÈÏÊÇlantinÈðµäÓïϵ£¬Òò´ËÔÚmysql
4.0µ¼³öµÄsqlÎļþÀïÃæÐèÒª¼ÓÈëDEFAULT CHARSET
=utf8 collate
utf8_unicode_ci
ÀýÈ磺
CREATE TABLE IF NOT EXISTS `user_right` (
`user_right_id` int(11) NOT NULL auto_increment,
`user_id` varchar(11) default NULL,
`right_id` varchar(11) default NULL,
PRIMARY KEY (`user_right_id`)
) TYPE=MyISAM DEFAULT CHARSET
=utf8 collate
utf8_unicode_ci
AUTO_INCREMENT=11 ;
È»ºóÔÚphpÁ¬½ÓÊý¾Ý¿â×î³õÖ´ÐÐ"SET NAMES 'utf8'"£»
ÎÊÌâ½â¾ö£¡ÒÔÉÏÕë¶Ôutf8±àÂëµÄÊý¾Ý¿â£¬±Ï¾¹ÊÇÇ÷ÊÆÂÆäËü±àÂëÓдýÉÔ¿ÕµÄʱºòÑо¿
Ïà¹ØÎĵµ£º
solarisÏÂmysql°²×°Íê±ÏºóÖ´ÐÐÈçϲÙ×÷£¬¿ÉÒÔÐÞ¸ÄÊý¾Ý¿â×Ö·û¼¯£¬ÉèÖÃMySQLÔÚSolarisÉϱíÃû²»Çø·Ö´óСд
1.¿½±´ÎļþÈçÏ£º
cp /usr/sfw/share/mysql/my-medium.cnf /etc/my.cnf
°ÑÎļþÖ»¶ÁÊôÐÔÈ¥µô
chmod +w my.cnf
2 ÉèÖÃmysqlµÄ×Ö·û¼¯£ºÔÚ/etc/my.cnfÖеÄmysqld¶ÎºÍclient¶Î¼ÓÈë´úÂ룺
[client]
de ......
ÎÊ£º
±ÈÈçÎÒÏëÖ±½ÓÔÚphp µÄ½Å±¾Àïдһ¸öÀàËÆ£¬install.phpµÄ½Å±¾
Õâ¸ö½Å±¾µÄ×÷ÓþÍÊÇ£¬Á¬½ÓmysqlÊý¾Ý¿â£¬²¢½¨Á¢ÎÒËùÏëÒª½¨Á¢µÄÊý¾Ý¿â£¬Êý¾Ý±í£¬ÒÔ¼°Ïà¹Ø×ֶΡ£
Çë¾ßÌåдһ¸öÀý×Ó£¬Ð»Ð»£¡
______________________________________________________________________________________________
´ð1£º
連½Ó·½· ......
ÄÚÈÝ£º
*************
1
°²×°£Í£Ù£Ó£Ñ£Ìºó¸ü¸ÄÁˣңϣϣԵÄÃÜÂëºóÓÃ
net startmysql
Æô¶¯Ê±ÎÒ¾ÍÓöµ½ÁËÕâÑùµÄÎÊÌ⣮ʹÓÃÒÔÏÂÃüÁîºó
c:\mysql\bin\mysqladmin-u root -p shutdown
ÔÙnet start mysql¾ÍûÓÐÕâ¸ö´íÎóÌáʾÁË!
*************
2
MySQLµÄ1067´íÎó
Q£ºÎÒµÄMysqlÅöµ½ÁË 1067 ´íÎó
´íÎóÐÅϢΪ£º
......
Scale Out£ººáÏòÀ©Õ¹£¬Ôö¼Ó´¦Àí½ÚµãÌá¸ßÕûÌå´¦ÀíÄÜÁ¦
Scale Up£º×ÝÏòÀ©Õ¹£¬Í¨¹ýÌáÉýµ¥¸ö½ÚµãµÄ´¦ÀíÄÜÁ¦´ïµ½ÌáÉýÕûÌå´¦ÀíÄÜÁ¦µÄÄ¿µÄ
Replication
MySQLµÄreplicationÊÇÒì²½µÄ£¬ÊÊÓÃÓÚ¶ÔÊý¾ÝʵʱÐÔÒªÇó²»ÊÇÌØ±ð¹Ø¼üµÄ³¡¾°¡£slave¶ËµÄIOÏ̸߳ºÔð´Ómaster¶ÁÈ¡ÈÕÖ¾£¬SQLÏß ³ÌרߺÔðÔÚslave¶ËÓ¦ÓôÓmaster¶Á¹ýÀ´µÄÈÕÖ¾£¨ÔçÆÚ ......
linux:
Èç¹û MySQL ÕýÔÚÔËÐУ¬Ê×ÏÈɱ֮£º killall -TERM mysqld¡£
Æô¶¯ MySQL £º/usr/bin/safe_mysqld --skip-grant-tables &
¾Í¿ÉÒÔ²»ÐèÒªÃÜÂë¾Í½øÈë MySQL ÁË¡£
È»ºó¾ÍÊÇ
>use mysql
>update user set password=password("new_pass") where user="root";
>flush privileges;
ÖØÐÂɱ MySQL £¬ ......