ÍùMYSQLÀïдÖÐÎľͱäÎʺţ¿
ÎÊÌâ½â¾öÁË£¬ÔÒòÊÇÔÚmy.cnfÖÐȱÉÙÁËÈçÏ´úÂ룺
[client]
default-character-set=utf8
[mysqld]
default-character-set=utf8
Èç¹û²»¼ÓÒÔÉÏ´úÂ룬ÄÇô¼´±ãMYSQL±àÒ밲װʱָ¶¨µÄ±àÂëÊÇUTF8£¬ÄÇôÔÚ½¨¿âʱÆäĬÈϱàÂëÈÔÊÇLATIN1£¬¶øÓÉÓÚ×Ö·û¼¯µÄ¼Ì³ÐÐÔ£¬¿âÖеıíÒ²ÊÇLATIN1µÄÁË¡£
ÕâÀïÁм¸ÌõÃüÁ´ó¼Ò¿ÉÒÔ×Ô¼ºÊÔÏ£º
1.ÁгöMYSQLÖ§³ÖµÄËùÓÐ×Ö·û¼¯£º
SHOW CHARACTER SET;
2.µ±Ç°MYSQL·þÎñÆ÷×Ö·û¼¯ÉèÖÃ
SHOW VARIABLES LIKE 'character_set_%';
3.µ±Ç°MYSQL·þÎñÆ÷×Ö·û¼¯Ð£ÑéÉèÖÃ
SHOW VARIABLES LIKE 'collation_%';
4.ÏÔʾijÊý¾Ý¿â×Ö·û¼¯ÉèÖÃ
show create database Êý¾Ý¿âÃû;
5.ÏÔʾijÊý¾Ý±í×Ö·û¼¯ÉèÖÃ
show create table ±íÃû;
6.ÐÞ¸ÄÊý¾Ý¿â×Ö·û¼¯
alter database Êý¾Ý¿âÃû default character set 'utf8';
7.ÐÞ¸ÄÊý¾Ý±í×Ö·û¼¯
alter table ±íÃû default character set 'utf8';
8.½¨¿âʱָ¶¨×Ö·û¼¯
create database Êý¾Ý¿âÃû character set gbk collate gbk_chinese_ci;
9.½¨±íʱָ¶¨×Ö·û¼¯
CREATE TABLE `mysqlcode` (
`id` TINYINT( 255 ) UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY ,
`content` VARCHAR( 255 ) NOT NULL
) TYPE = MYISAM CHARACTER SET gbk COLLATE gbk_chinese_ci;
¸öÈËÈÏΪÒÔÉÏ·½·¨²»Ì«ºÃÓã¬Èç¹û¶¼²»ÐаÉÊý¾Ý¿â×ö±¸·Ý£¬Ö®ºóMySQL Server Instance ConfigÀォʵÀýɾÁËÖØÐ½¨Ò»¸ö£¨Ö÷Òâ×Ö·û±àÂ룩£¬Èç¹û»¹²»ÐÐ֨װMysql£¨Ð¶ÔØmysqlʱҪעÒ⣬·Ç³£¸´ÔÓ£¬¾ßÌå·½·¨ÎÒ·ÖÏíÁË£©
Ïà¹ØÎĵµ£º
1.MySQL¼ò½é
MySQLÊÇÒ»¸ö¹ã·ºÊ¹ÓõĽṹ»¯²éѯÓïÑÔ£¨SQL£©Êý¾Ý¿â·þÎñÆ÷¡£ºÍÆäËûSQL·þÎñÆ÷Ò»Ñù£¬MySQLÌṩÁË·ÃÎʺ͹ÜÀíSQLÊý¾Ý¿âµÄ·½·¨£¬µ«ÊÇ£¬MySQLͬʱҲÌṩÁË´´½¨Êý¾Ý¿â½á¹¹ÒÔ¼°ÔÚÕâЩ½á¹¹ÖÐÌí¼Ó¡¢Ð޸ĺÍɾ³ýÕâЩ½á¹¹µÄ¹¤¾ß¡£
MySQLÊý¾Ý¿âÏà¹ØµÄÈí¼þ°üÖ÷ÒªÓÐÒÔϼ¸ÖÖ£º
......
http://www.3d308.cn/article.asp?id=37
shell> mysql -u root mysql
mysql> Update user SET Password=PASSWORD('new_password')
Where user='root';
mysql> FLUSH PRIVILEGES;
......
1¡¢MySQL³£ÓÃÃüÁî
create database name; ´´½¨Êý¾Ý¿â
use databasename; Ñ¡ÔñÊý¾Ý¿â
drop database name Ö±½Óɾ³ýÊý¾Ý¿â£¬²»ÌáÐÑ
show tables; ÏÔʾ±í
describe tablename; ±íµÄÏêϸÃèÊö
select ÖмÓÉÏdistinctÈ¥³ýÖØ¸´×Ö¶Î
mysqladmin drop databasename ɾ³ýÊý¾Ý¿âǰ£¬ÓÐÌáʾ¡£
ÏÔʾµ±Ç°mysql°æ±¾ºÍµ±Ç°È ......
MySQL°²×°Íê³Éºó²»ÏóSQL ServerĬÈϰ²×°ÔÚÒ»¸öĿ¼£¬ËüµÄÊý¾Ý¿âÎļþ¡¢ÅäÖÃÎļþºÍÃüÁîÎļþ·Ö±ðÔÚ²»Í¬µÄĿ¼£¬Á˽âÕâЩĿ¼·Ç³£ÖØÒª£¬ÓÈÆä¶ÔÓÚLinuxµÄ³õѧÕߣ¬ÒòΪ Linux±¾ÉíµÄĿ¼½á¹¹¾Í±È½Ï¸´ÔÓ£¬Èç¹û¸ã²»Çå³þMySQLµÄ°²×°Ä¿Â¼ÄǾÍÎÞ´Ó̸ÆðÉîÈëѧϰ¡£ÏÂÃæ¾Í½éÉÜÒ»ÏÂÕ⼸¸öĿ¼¡£
£¨1£©Êý¾Ý¿âĿ¼
......