Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

MySQL°²×°Ö¸ÄÏ


MySQL°²×°Ö¸ÄÏ
Òª°²×° MySQL£¬¿ÉÒÔÔÚÖÕ¶ËÌáʾ·ûºóÔËÐÐÏÂÁÐÃüÁ
sudo apt-get install mysql-server
sudo apt-get install mysql-client
sudo apt-get install php5-mysql
// °²×°php5-mysql Êǽ«phpºÍmysqlÁ¬½ÓÆðÀ´
Ò»µ©°²×°Íê³É£¬MySQL ·þÎñÆ÷Ó¦¸Ã×Ô¶¯Æô¶¯¡£Äú¿ÉÒÔÔÚÖÕ¶ËÌáʾ·ûºóÔËÐÐÒÔÏÂÃüÁîÀ´¼ì²é MySQL ·þÎñÆ÷ÊÇ·ñÕýÔÚÔËÐУº
sudo netstat -tap | grep mysql
µ±ÄúÔËÐиÃÃüÁîʱ£¬Äú¿ÉÒÔ¿´µ½ÀàËÆÏÂÃæµÄÐУº
tcp 0 0 localhost.localdomain:mysql *:* LISTEN -
Èç¹û·þÎñÆ÷²»ÄÜÕý³£ÔËÐУ¬Äú¿ÉÒÔͨ¹ýÏÂÁÐÃüÁîÆô¶¯Ëü£º
sudo /etc/init.d/mysql restart
½øÈëmysql
mysql -uroot -p
(ÊäÈëmysqlµÄrootÃÜÂë)
ÅäÖà MySQL µÄ¹ÜÀíÔ±ÃÜÂ룺
sudo mysqladmin -u root password newpassword


Ïà¹ØÎĵµ£º

mysql Âý²éѯ²éѯºÍÒýÆðÔ­Òò·ÖÎö

MySQLÓÐÒ»¸ö¹¦ÄܾÍÊÇ¿ÉÒÔlogÏÂÀ´ÔËÐеıȽÏÂýµÄsqlÓï¾ä£¬Ä¬ÈÏÊÇûÓÐÕâ¸ölogµÄ£¬ÎªÁË¿ªÆôÕâ¸ö¹¦ÄÜ£¬ÒªÐÞ¸Ämy.cnf»òÕßÔÚMySQLÆô¶¯µÄʱºò¼ÓÈëһЩ²ÎÊý¡£
Èç¹ûÔÚmy.cnfÀïÃæÐ޸ģ¬ÐèÔö¼ÓÈçϼ¸ÐÐ
long_query_time = 1
log-slow-queries =
log-queries-not-using-indexes
long_query_time ÊÇÖ¸Ö´Ðг¬¹ý¶à¾ÃµÄsql»á±»logÏÂÀ´£ ......

MySQL´íÎóÐÅÏ¢

ת×Ô: http://www.phpweblog.net/lemon2maple/archive/2007/07/29/1397.html
mysqlµÄ³ö´í´úÂë±í£¬¸ù¾ÝmysqlµÄÍ·Îļþmysql/include/mysqld_error.hÕûÀí¶ø³É¡£´íÎóÖ®´¦£¬Çë´ó¼ÒÖ¸Õý¡£
1005£º´´½¨±íʧ°Ü
1006£º´´½¨Êý¾Ý¿âʧ°Ü
1007£ºÊý¾Ý¿âÒÑ´æÔÚ£¬´´½¨Êý¾Ý¿âʧ°Ü
1008£ºÊý¾Ý¿â²»´æÔÚ£¬É¾³ýÊý¾Ý¿âʧ°Ü
1009£º²»ÄÜɾ³ýÊý¾ ......

MySqlÓû§´´½¨¡¢ÊÚȨÒÔ¼°É¾³ý(תÌù)

he create user command:
mysql
> CREATE
 
USER
 yy IDENTIFIED 
BY
 
'
123
'
;
yy±íʾÄãÒª½¨Á¢µÄÓû§Ãû£¬ºóÃæµÄ123±íʾÃÜÂë
ÉÏÃæ½¨Á¢µÄÓû§¿ÉÒÔÔÚÈκεط½µÇ½¡£
Èç¹ûÒªÏÞÖÆÔڹ̶¨µØÖ·µÇ½£¬±ÈÈçlocalhost µÇ½£º
mysql
> CREATE
 
USER
 yy@localhost
&n ......

mysqlÊý¾Ý¿â±¸·ÝÓ뻹ԭ

mysqlÊý¾Ý¿â±¸·ÝÓ뻹ԭÃüÁ
±¸·Ý£º
ÈçÎÒÃÇÐèÒª°Ñ Êý¾Ý¿âÃûΪ£ºshopping µÄÊý¾Ý¿â±¸·Ý£º Óû§ÃûΪ£ºroot£¬ÃÜÂëΪ£º12345£¬ÄÇôÃüÁîÈçÏ£º
Ö±½Ó½øÈëdos£¬Èç¹ûûÓÐÅäÖÃmysqlµÄ»·¾³±äÁ¿£¬ÄÇôÐèÒª°ÑdosµÄµ±Ç°Ä¿Â¼Çл»µ½mysqlµÄbinĿ¼Ï£¬È»ºóÇÃÈëÒ»ÏÂÃüÁ
        mysqldump -uroo ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ