ÍøÂçѧԺ w3popÉçÇø ÍøÂç×ÊÔ´ ITÐÂÎÅ

w3pop.com :: ÍøÂçѧԺ :: Linux :: ubuntuϸü¸ÄmysqlĬÈϱàÂë(×Ö·û¼¯)

»áÔ±µÇ½

ÕʺÅ

ÃÜÂë

»Ø´ð

¼ÇסÃÜÂë

Íü¼ÇÃÜÂë? ×¢²á

Linux
½âÎöLINUXµÄpassw..
UBUNTU APACHE mo..
ubuntuϸü¸Ämysq..
Linuxϵͳ³£¼û½ô¼..
linux ¾­µäÎÊÌ⣨..
linux ¾­µäÎÊÌ⣨..
linux ¾­µäÎÊÌâ(Ò..
Ubuntu LinuxÖ®¼Ó..
linux Ö÷Ŀ¼¡¢¸ù..
linux Óë win ·ÖÇ..
ÈýÖÖÒýµ¼LinuxµÄ¼..
Èý¸ö¼òµ¥ÊµÓõÄLi..
UbuntuÏÂʹapache..
linuxµÄtopÃüÁî²Î..
ubuntu apache2 Ì..
UNIX ºÍ Linux ÓÐ..
LinuxÓ¦¸ÃÏò΢ÈíÑ..
Linux ÍøÂ簲ȫÎÄ..
Ubuntu 7.04 ÐÂÊÖ..
linux ¶¨ÆÚµ÷¶È½ø..

ubuntuϸü¸ÄmysqlĬÈϱàÂë(×Ö·û¼¯)


×÷Õß:w3pop.com ·­Òë/ÕûÀí:w3pop.com ·¢²¼:2007-08-10 ä¯ÀÀ:3168 :: ::

°²×°mysql

sudo apt-get install mysql-server #Ö±½Ó×Ô¶¯»ñµÃ¿ÉÓð汾
Ò²¿ÉÒÔÕâÑùд
sudo apt-get install mysql-server-5.0 #°²×°mysql·þÎñÆ÷5.0°æ±¾

°²×°ºó

/etc/init.d/mysql start (stop) ΪÆô¶¯ºÍÍ£Ö¹·þÎñÆ÷
/etc/mysql/ Ö÷ÒªÅäÖÃÎļþËùÔÚλÖà my.cnf
/var/lib/mysql/ ·ÅÖõÄÊÇÊý¾Ý¿â±íÎļþ¼Ð£¬ÕâÀïµÄmysqlÏ൱ÓÚwindowsÏÂmysqlµÄdateÎļþ¼Ð

Æô¶¯mysqlºó£¬ÒÔrootµÇ¼mysql
isher@isher-ubuntu:~$ mysql -u root
>show variables like 'character%'; #Ö´ÐбàÂëÏÔʾ
+--------------------------+----------------------------+
| Variable_name | Value |
+--------------------------+----------------------------+
| character_set_client | latin1 |
| character_set_connection | latin1 |
| character_set_database | latin1 |
| character_set_filesystem | binary |
| character_set_results | latin1 |
| character_set_server | latin1 |
| character_set_system | utf8 |
| character_sets_dir | /usr/share/mysql/charsets/ |
+--------------------------+----------------------------+

ÔÚijЩʱºò£¬ÎÒÃÇÐøÒªÐÞ¸ÄmysqlĬÈÏÊý¾Ý¿âµÄ±àÂ룬ÒÔ±£Ö¤Ä³Ð©Ç¨ÒƵijÌÐò¿ÉÒÔÕý³£ÏÔʾ£¬±à¼­my.cnfÎļþ½øÐбàÂëÐÞ¸Ä,windows¿ÉÒÔÖ±½ÓÓãÍysql Server Instance Config Wizard ½øÐÐÉèÖÃ

ÔÚlinuxÏÂÐÞ¸Ä3¸ömy.cnfµÄ1¸ö/etc/mysql/my.cnfÎļþ

ÕÒµ½¿Í»§¶ËÅäÖÃ[client] ÔÚÏÂÃæÌí¼Ó
default-character-set=utf8 ĬÈÏ×Ö·û¼¯Îªutf8
ÔÚÕÒµ½[mysqld] Ìí¼Ó
default-character-set=utf8 ĬÈÏ×Ö·û¼¯Îªutf8
init_connect='SET NAMES utf8' £¨É趨Á¬½ÓmysqlÊý¾Ý¿âʱʹÓÃutf8±àÂ룬ÒÔÈÃmysqlÊý¾Ý¿âΪutf8ÔËÐУ©

Ð޸ĺúó£¬ÖØÐÂÆô¶¯mysql ¼´¿É£¬²éѯһÏÂshow variables like 'character%';
+--------------------------+----------------------------+
| Variable_name | Value |
+--------------------------+----------------------------+
| character_set_client | utf8 |
| character_set_connection | utf8 |
| character_set_database | utf8 |
| character_set_filesystem | binary |
| character_set_results | utf8 |
| character_set_server | utf8 |
| character_set_system | utf8 |
| character_sets_dir | /usr/share/mysql/charsets/ |
+--------------------------+----------------------------+

´Ë·½·¨ÓÃÓÚ±ê×¼mysql°æ±¾Í¬ÑùÓÐЧ£¬¶ÔÓÚ/etc/my.cnfÎļþ£¬ÐèÒª´Ómysql/support-filesµÄÎļþ¼Ðcp my-large.cnfÒ»·Ýµ½/etc/my.cnf

ÆÀÂÛ (1) 1 All