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
Ïà¹ØÎĵµ£º
ÓÅ»¯MySQLÊý¾Ý¿â²éѯ
ÔÚÓÅ»¯²éѯÖУ¬Êý¾Ý¿âÓ¦ÓÃ(ÈçMySQL)¼´Òâζ×ŶԹ¤¾ßµÄ²Ù×÷ÓëʹÓá£Ê¹ÓÃË÷Òý¡¢Ê¹ÓÃEXPLAIN·ÖÎö²éѯÒÔ¼°µ÷ÕûMySQLµÄÄÚ²¿ÅäÖÿɴﵽÓÅ»¯²éѯµÄÄ¿µÄ
¡¡¡¡ÈκÎһλÊý¾Ý¿â³ÌÐòÔ±¶¼»áÓÐÕâÑùµÄÌå»á£º¸ßͨÐÅÁ¿µÄÊý¾Ý¿âÇý¶¯³ÌÐòÖУ¬Ò»ÌõÔã¸âµÄSQL²éѯÓï¾ä¿É¶ÔÕû¸öÓ¦ÓóÌÐòµÄÔËÐвúÉúÑÏÖØµÄ ......
ǰ׺Ë÷Òý
(1)Èç¹ûÒÔ¶à¸ö×Ö¶Î×÷ΪË÷Òý£¨a,b£¬c)×÷Ϊһ¸ökey,ÔÚ²éѯʱ·Ö¸ù¾ÝÆ¥ÅäÇé¿öÊÇ·ñʹÓÃË÷Òý£¬ËùÒÔ£¬a/ a,b/ a,b,cÕâÑùµÄ²éѯ¶¼ÄÜʹÓõ½£¬µ«ÊÇb,a/a,c/c,aµÈ²»·û֪ǰ׺ƥÅä¾Í²»ÄÜʹÓã¬ËùÒÔÔÚдsqlʱÐèҪעÒâ
(2)¶ÔÓںܳ¤µÄ×Ö·û´®ÐèÒªÉú³Ékeyʱ£¬¿ÉÒÔÕÒ³ö×ʹÓõÄ×Ö·û´®µÄ×î³£¼ûǰ׺(Ç°N¸ö×ÖÌõ×÷Ϊkey,¶ø²»Êǽ ......
ÉèÖÃ×ֶεÄĬÈÏÖµ£º
´´½¨±íµÄʱºò£ºcreate table
tablename(columnname columntype default
defaultvalue);
Ð޸ıíµÄʱºò£ºalter table
tablename alter column
columnname set
default
deflaultvalue; ......
Ö÷£º
show master status;
+-----------------+------------+-------------------+-----------------------+
| File |
Position | Binlog_Do_DB | Binlog_Ignore_DB |
+------------ ......