mysql´íÎóÌáʾ¼°×ÊÁÏ×ܽá
mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)'
Check that mysqld is running and that the socket: '/var/lib/mysql/mysql.sock' exists!
[root@localhost]# mysql -u root -p
Enter password:
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
[root@localhost]#
[root@localhost]# service mysqld start
³õʼ»¯ MySQL Êý¾Ý¿â£º Installing MySQL system tables...
1.ÀýÈçÄãµÄ rootÓû§ÏÖÔÚûÓÐÃÜÂ룬ÄãÏ£ÍûµÄÃÜÂëÐÞ¸ÄΪabc£¬ÄÇôÃüÁîÊÇ£º
mysqladmin -u root password abc
2.Èç¹ûÄãµÄrootÏÖÔÚÓÐÃÜÂëÁË£¬ÄÇôÐÞ¸ÄÃÜÂëΪabcµÄÃüÁîÊÇ£º
mysqladmin -u root -p password youyou
×¢Ò⣬ÃüÁî»Ø³µºó»áÎÊÄã¾ÉÃÜÂ룬ÊäÈë¾ÉÃÜÂëÖ®ºóÃüÁîÍê³É£¬ÃÜÂëÐ޸ijɹ¦¡£
3.ÔËÐÐmysqladminÃüÁî²»ÊÇË«»÷Õâ¸öÎļþ£¬ÄÇÑùÔËÐÐÎÞ·¨¸ø²ÎÊý£¬¿ÉÒÔÔÚ¿ªÊ¼ÔËÐÐÀïÃæÊäÈëÃüÁ»òÕßÔÚ¿ªÊ¼¡¢ËùÓгÌÐò¡¢¸½¼þ¡¢ÃüÁîÌáʾ·ûÀïÃæÊäÈëÃüÁעÒâÓ¦¸ÃÊäÈëmysqladminµÄȫ·¾¶Ãû£¬ÀýÈ磺
d:\mysql\bin\mysqladmin.exe -u root -p password youyou
Ïà¹ØÎĵµ£º
תµ½¸½Â¼1£¨mysql ÃüÁî´óÈ« - ÃüÁîÏê½â
£©
תµ½¸½Â¼2£¨mysqlÂÒÂëÎÊÌâ½â¾ö·½·¨
£©
ÔÚÎÒµÄFedoraÖУ¬ÔÚϵͳ°²×°Ê±ÎÒ¾ÍÑ¡Ôñ°²×°ÁËMysqlÁË£¬ËùÒԾͲ»ÓÃÔÙÈ¥ÏÂÔØÔ´´úÂ룬ȻºóÈ¥ÂýÂý±àÒë¡£¹þ¹þ£¬ÍµÁËÒ»¸öÀÁ¡£
ϵͳ°²×°ºÃÁË£¬Mysqlʱ±Ø²»¿ÉÉٵģ¬ËùÒÔÒ»¶¨Òª¼ìÑéÒ»ÏÂMysql¿ÉÒÔÓò»¡£
Ê×ÏÈÇл»µ½rootÕË»§£¬È»ºóÊäÈëÃüÁs ......
×¼±¸:
lighttpd-1.4.15.tar.gz
php-4.4.2.tar.gz
mysql-5.0.20a.tar.gz
¿ªÊ¼:
1 ±àÒë°²×°lighttpd
# tar zxvf lighttpd-1.4.15.tar.gz
# cd lighttpd-1.4.15
# ls
# ./configure --prefix=/usr/local/lighttpd //´Ë²¿ÎÞ·¨±àÒëʱÌáʾ°²×°prce-devel
#&nbs ......
²é¿´Ä³¸ö±íµÄ½¨±íÓï¾ä £ºshow create table data_statdata;
drop index ts on data_statdata;
Ë÷ÒýÊǼÓËÙ²éѯµÄÖ÷ÒªÊֶΣ¬Ìرð¶ÔÓÚÉæ¼°¶à¸ö±íµÄ²éѯ¸üÊÇÈç´Ë¡£±¾½ÚÖУ¬½«½éÉÜË÷ÒýµÄ×÷Óá¢Ìص㣬ÒÔ¼°´´½¨ºÍɾ³ýË÷ÒýµÄÓï·¨¡£
13.4.1 ʹÓÃË÷ÒýÓÅ»¯²éѯ
Ë÷ÒýÊÇ¿ìËÙ¶¨Î»Êý¾ÝµÄ¼¼Êõ£¬Ê×ÏÈͨ¹ýÒ»¸öʾÀýÀ´Á˽âÆ京Òå¼°×÷Óã ......
ÉèÖÃ×ֶεÄĬÈÏÖµ£º
´´½¨±íµÄʱºò£ºcreate table
tablename(columnname columntype default
defaultvalue);
Ð޸ıíµÄʱºò£ºalter table
tablename alter column
columnname set
default
deflaultvalue; ......