mysqlÔÚubuntuϵÄʹÓÃ
°²×°ºÃ mysqlºóÔÚÖÕ¶ËÊäÈëÃüÁîmysql -s root -p
ÏÔʾ£º
Access denied for user 'star'@'localhost' (using password: YES)
ÊÇ·þÎñ»¹Ã»¿ªÆô£¬ÊäÈ룺sudo /etc/init.d/mysql start
È»ºóÊäÈë mysql -uroot -p µÇ¼³É¹¦
ÖÐÎÄÎÊÌâ
Ubuntu 7.04 ÏÂÓÃÔ´°²×°ÁËMySQL¡£Ä¬ÈÏÇé¿öÏ£¬ÓÃmysql shellµÇ¼´´½¨Êý¾Ý¿â´´½¨±í²åÈëÖÐÎÄÊý¾Ýºó£¬ÓÃselect²é³öÀ´ÊÇÖÐÎÄ£¬µ«ÓÃJDBCÁ¬½Ó¾Í³öÏÖÂÒÂë¡£ÍøÉÏËÑË÷µ½½â¾ö·½·¨£¬ÈçÏ£¨Ïȱ¸·ÝÊý¾Ý£©£º
ÔÚ/etc/my.cnfÎļþÖмÓÉÏÒÔÏÂÁ½ÐÐÄÚÈÝ£º
[client]
default-character-set=utf8
[mysqld]
default-character-set=utf8
×¢Ò⣬Õâ¸öÎļþ²»Ò»¶¨´æÔÚ£¬Ð轫 /°²×°ÔÎļþ/support-files/my-medium.cnf ¸´ÖƵ½/etc/Ï£¬ÖØÃüÃû
ÐèÖØÆômysql
Í£Óãºsudo /usr/local/mysql/bin/mysqladmin shutdown
ÆôÓÃsudo /usr/local/mysql/bin/mysqld_safe -user=mysql &
²é¿´mysql±àÂë
ÆôÓúósudo /usr/local/mysql/bin/mysql
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/ |
+--------------------------+----------------------------+
×¢Ò⣬ÕâÑù¸Ä±äºóÔÏÈËù½¨Êý¾Ý¿âËÆºõ²»ÄÜÓ㨲»È·¶¨£©£¬¾¡Á¿±¸·Ý
н¨Êý¾Ý¿â£¬¾Í²»»áÓÐÂÒÂëÁË¡£
Ïà¹ØÎĵµ£º
TINYINT 1 ×Ö½Ú
SMALLINT 2 ¸ö×Ö½Ú
MEDIUMINT 3 ¸ö×Ö½Ú
INT 4 ¸ö×Ö½Ú
INTEGER 4 ¸ö×Ö½Ú
BIGINT 8 ¸ö×Ö½Ú
FLOAT(X) 4 Èç¹û X < = 24 »ò 8 Èç¹û 25 < = X < = 53
FLOAT 4 ¸ö×Ö½Ú
DOUBLE 8 ¸ö×Ö½Ú
DOUBLE PRECISION 8 ¸ö×Ö½Ú
REAL 8 ¸ö×Ö½Ú
DECIMAL(M,D) M×Ö½Ú(D+2 , Èç¹ûM < D)
NUMERIC(M,D) M×Ö½Ú(D ......
×ªÔØ:¹ØÓÚMYSQLÓï¾ä´æÔÚ×¢Èë©¶´µÄд·¨
±¾ÎÄ×÷Õߣºangel
ÎÄÕÂÐÔÖÊ£ºÔ´´
·¢²¼ÈÕÆÚ£º2004-09-16
±¾ÎÄÒѾ·¢±íÔÚ¡¶ºÚ¿Í·ÀÏß¡·7Ô¿¯£¬×ªÔØÇë×¢Ã÷¡£ÓÉÓÚдÁ˺ܾã¬Ëæ×ż¼ÊõµÄ½ø²½£¬±¾ÈËÒ²·¢ÏÖ¸ÃÎÄÀïÓв»ÉÙ´íÎóºÍÂÞàµĵط½¡£Çë¸÷λ¸ßÊÖ¿´Á˲»ÒªÐ¦¡£±¾ÎÄдÓÚ¡¶Advanced SQL Injection with MySQL¡·Ö®Ç°Ò»¸ ......
SQL Injection with MySQL
±¾ÎÄ×÷Õߣºangel
ÎÄÕÂÐÔÖÊ£ºÔ´´
·¢²¼ÈÕÆÚ£º2004-09-16
±¾ÎÄÒѾ·¢±íÔÚ¡¶ºÚ¿Í·ÀÏß¡·7Ô¿¯£¬×ªÔØÇë×¢Ã÷¡£ÓÉÓÚдÁ˺ܾã¬Ëæ×ż¼ÊõµÄ½ø²½£¬±¾ÈËÒ²·¢ÏÖ¸ÃÎÄÀïÓв»ÉÙ´íÎóºÍÂÞàµĵط½¡£Çë¸÷λ¸ßÊÖ¿´Á˲»ÒªÐ¦¡£±¾ÎÄдÓÚ¡¶Advanced SQL Injection with MySQL¡·Ö®Ç°Ò»¸öÔ¡£
ÉùÃ÷
¡¡¡¡±¾ÎĽöÓÃÓÚ½ ......
Á¬½ÓMySQLÊý¾Ý¿âʱ³£»á³öÏÖÈçϵĴíÎóÌáʾ£º
#1251 - Client does not support authentication protocol requested by server; consider upgrading MySQL client
³öÏÖÕâÖÖÎÊÌâÊÇÔÚMySQL4.1ÒÔÉϰ汾£¬ÔÒòMySQL·þÎñÆ÷°æ±¾Ê¹ÓÃÁËеÄÃÜÂëÑéÖ¤»úÖÆ£¬Æä½â¾ö·½·¨ÈçÏ£º
mysql>;set password for 'Óû§Ãû' @ 'Ö÷»úÃû' = old ......