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

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";


Ïà¹ØÎĵµ£º

ÐÞ¸Äͨ´ïOA MysqlÊý¾Ý¿âÃÜÂë


ÓеÄÓû§£¬³öÓÚʹÓÃmysqlÊý¾Ý¿â¿ª·¢ÆäËû³ÌÐòµÄÐèÒª£¬¿ÉÄÜÏ£ÍûÐÞ¸ÄMysqlÊý¾Ý¿âµÄrootÓû§ÃÜÂ룬
ÏÖ×öÒÔϼòҪ˵Ã÷¡£
ÓÉÓÚOAʹÓõÄMysqlÊý¾Ý¿â±»É趨ΪֻÄÜ´Ó±¾»ú·ÃÎÊ£¬ËùÒÔÆÕͨÓû§²»½¨ÒéÐÞ¸ÄÊý¾Ý¿âÃÜÂ룬
ÐÞ¸ÄÊý¾Ý¿âÃÜÂë²¢²»ÊÇΪÁ˸ÄÉÆÏµÍ³°²È«ÐÔµÄÄ¿µÄ¡£
windows-¡µ¿ªÊ¼—¡µÔËÐУ¬ÊäÈëcmd½øÈëÃüÁîÐÐģʽ£¬²¢Ê¹Ó ......

explaination of mysql/bin/ file

1      innochecksum
     
 
5       msql2mysql
6       myisamchk
7       myisam_ftdump
8       myisamlog
9 &nbs ......

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Êý¾Ý±¸·ÝÒÔ¼°ÒìµØ´æ´¢

ÕûÀítuscany.org.cnµÄ·þÎñÆ÷£¬·¢ÏÖ3ÄêǰдµÄ½Å±¾»¹ÔÚÅÜ×Å :)
½Å±¾ÈçÏ£º
#==========================================================
#!/bin/bash
current_date=`date +%Y-%m-%d:%H:%M:%S`
/usr/local/mysql/bin/mysqldump -prootpass  dbname1 > ./DB_DIR/dbname1_"$current_date"_dump_file.sql 
......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ