MySQL Ô¶³ÌÁ¬½Ó
ÎÊÌ⣺Զ³ÌÁ¬½Ó·þÎñÆ÷µÄÊý¾Ý¿â
$ mysql -hserverip -uuser -ppassword
ERROR 1045 (28000): Access denied for user 'user'@'localhost'
(using password: YES)
ÔÒò£ºmysql.user±íÖÐûÓÐÉèÖÃÔ¶³ÌÁ¬½Ó
$ mysql -uroot -ppassword #ÓÃrootÓû§ÔÚserverÉϵǼ
mysql> select host, user, password from mysql.user; #²é¿´mysqlÊý¾Ý¿âuser±íÖеÄÐÅÏ¢
»á·¢ÏÖûÓÐÔ¶³Ì»úÆ÷µÄhost, µ±È»Ò²Ã»ÓÐuser
½â¾ö·½·¨£º
mysql> grant select, update, insert, delete on *.* to user@clientip identified by "password";
ÕâÑùÔÚÔ¶³Ì¿Í»§¶Ëclientip¾Í¿ÉÒÔ·ÃÎÊÊý¾Ý¿âÁË
$ mysql -hserverip -uuser -ppassword
¸½¼Ó£º
Èç¹ûÏëÈÃËùÓеÄÔ¶³Ì»úÆ÷¶¼¿ÉÒÔÓÃuserÓû§·ÃÎÊÊý¾Ý¿â¿ÉÒÔÔÚ·þÎñÆ÷Êý¾Ý¿âÖÐ×öÈçÏÂÉèÖÃ
mysql> grant all on *.* to user@"%" identified by "password";
Ïà¹ØÎĵµ£º
¹ýÁËÒ»Õó×Óºó£¬ÎªÁËд·Ö²¼Ê½×÷Òµ£¬ÖØÐÂʹÓÃMysqlʱ£¬·¢ÏÖËäÈ»Æô¶¯³É¹¦ÁË£¬µ«ÊÇÁ¬½ÓµÄʱºòÈ¥³öÏÖÈçÏ´íÎó
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
¸ù¾ÝÌáʾÊÇ/var/run/mysqld/mysqld.sockÎļþ²»´æÔÚ¡£
Ϊʲô»áÕâÑùÄØ£¿
  ......
¸ÅÊö£º
1.ÂÒÂëÎÊÌâ¹é¸ùµ½µ×ÊÇ×Ö·û¼¯µÄÎÊÌâ,ÄǾʹÓ×Ö·û¼¯ÉèÖ÷½Ã濼ÂÇ,²»ÍâºõÏÂÃæ¼¸·½Ã棺
server(Mysql·þÎñÆ÷),client,database(Êý¾Ý¿â),connection(Á¬½Ó),result
MySQLµÄ×Ö·û¼¯´¦ÀíÊÇÕâÑùµÄ£º
£¨1£©·¢ËÍÇëÇó
¿Í»§¶Ë(character_set_client£©=¡·Êý¾ ......
1 innochecksum
5 msql2mysql
6 myisamchk
7 myisam_ftdump
8 myisamlog
9 &nbs ......
<!--
/* Font Definitions */
@font-face
{font-family:ËÎÌå;
panose-1:2 1 6 0 3 1 1 1 1 1;
mso-font-alt:SimSun;
mso-font-charset:134;
mso-generic-font-family:auto;
mso-font-pitch:variable;
mso-font-signature:3 135135232 16 0 262145 0;}
@font-face
{font-family:"\@ËÎÌå" ......
Òª°²裝 MySQL£¬¿ÉÒÔÔÚ終¶ËÌáʾ·ûºó運ÐÐÏÂÁÐÃüÁ
sudo apt-get install mysql-server
sudo apt-get install mysql-client
sudo apt-get install php5-mysql
// °²×°php5-mysql Êǽ«phpºÍmysqlÁ¬½ÓÆðÀ´
Ò»µ©°²裝Íê³É£¬MySQL ·þ務Æ÷應該×Ô動啟動¡£Äú¿ÉÒÔ ......