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

mysql Æð¶¯´íÎó½â¾ö°ì·¨

mysql Æð¶¯´íÎó½â¾ö°ì·¨- -
                                      
Access denied for user ''@'localhost' to database 'mysql'
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock'
µÚÒ»´Î°²×°ÔËÐÐÒÔÏÂÒ»¾ä£¬²úÉúÊý¾Ý¿âÎļþ
/usr/local/bin/mysql_install_db
chown -R mysql /var/db/mysql
Æô¶¯mysql
/usr/local/bin/mysqld_safe &
mysql Æð¶¯´íÎó½â¾ö°ì·¨- -
                                      
Access denied for user ''@'localhost' to database 'mysql'
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock'
µÚÒ»´Î°²×°ÔËÐÐÒÔÏÂÒ»¾ä£¬²úÉúÊý¾Ý¿âÎļþ
/usr/local/bin/mysql_install_db
chown -R mysql /var/db/mysql
Æô¶¯mysql
/usr/local/bin/mysqld_safe &
=====================================
apacheÆô¶¯
# /usr/local/sbin/apachectl start
¿ÉÒÔÔÚÈκÎʱºòʹÓÃÏÂÃæµÄÃüÁîÀ´Í£Ö¹·þÎñ£º
# /usr/local/sbin/apachectl stop
µ±ÓÉÓÚijÖÖÔ­ÒòÐÞ¸ÄÁËÅäÖÃÎļþÖ®ºó£¬ ÐèÒªÖØÆô·þÎñÆ÷£º
# /usr/local/sbin/apachectl restart
========================================
ÇëÎÊÄã×°µÄÊÇʲô°æ±¾£¿Èç¹ûÊÇ5.4µÄ»°£¬sshĬÈÏÊDz»´ò¿ªµÄ¡£ÐèÒªÔÚ/etc/rc.confÀïÃæÌí¼Ósshd_enable="YES"²ÅÐеġ£ÓÃSecureCRT 4.1µÇ½ʱÉèÖÃPrimaryµÄʱºòÉèΪkeyboard¾ÍÐÐÁË¡£5.4µÄÑéÖ¤·½Ê½²»ÄÜÓÃpassword[/img]
È·ÈÏ/etc/ssh/sshd_configÀïÃæÏÂÁÐÈýÐÐǰÎÞ#
Port 22
Protocol 2
PasswordAuthentication yes
=======================================
ǰ¼¸ÌìÓиöÌû×ÓÓÐ˵ÈçºÎ²»ÖØÆô¶¯¶øÊ¹ÍøÂç²ÎÊýÐÞ¸ÄÉúЧµÄ·½·¨¡£
/etc/netstart restart
================================================
×î¼òµ¥µÄÓÃϵͳ×Ô´øµÄftpd
vi /etc/inetd.conf
°Ñ ftpdǰµÄ#È¥µô´æÅÌÍ˳ö¡£(ipv6ÄãÓ¦¸ÃÓò»Éϵڶþ¸öftpdµÄ#Äã¾Í²»ÓÃÈ¥ÁË)
Èç¹û


Ïà¹ØÎĵµ£º

mysql »ù±¾ÃüÁî

1¡¢µÇ½MySQL:
mysql -u root -p
2¡¢²é¿´Óû§ÐÅÏ¢
select user,host,password from mysql.user;
select user,host from mysql.user;
3¡¢ÉèÖÃÃÜÂë
set password for root@localhost=password('
ÔÚÕâÀïÌîÈërootÃÜÂë
');
4¡¢ÐÞ¸ÄÃÜÂë
·½·¨1£ºmysqladmin -u root -p password newpassword
·½·¨2£º ££mysql -u root ......

MySQLÊý¾Ý¿âµÄ»ù±¾²Ù×÷ÃüÁî

Ò»¡¢mysql·þÎñ²Ù×÷
1¡¢net start mysql //Æô¶¯mysql·þÎñ
2¡¢net stop mysql //Í£Ö¹mysql·þÎñ¡¡
3¡¢mysql -hÖ÷»úµØÖ· -uÓû§Ãû £­pÓû§ÃÜÂë //½øÈëmysqlÊý¾Ý¿â
4¡¢quit //Í˳ömysql²Ù×÷
5¡¢mysqladmin -uÓû§Ãû -p¾ÉÃÜÂë password ÐÂÃÜÂë //¸ü¸ÄÃÜÂë
6¡¢grant select on Êý¾Ý¿â.* to Óû§Ãû@µÇ¼Ö÷»ú identifie ......

MySQLƽ̨Êý¾Ý¿â±¸·Ý·½°¸Ïêϸ˵Ã÷

À´Ô´£ºccidnet.com ×÷ÕߣºSabine¡¡ ʱ¼ä£º2006-10-09
ÔÚÊý¾Ý¿â±í¶ªÊ§»òË𻵵ÄÇé¿öÏ£¬±¸·ÝÄãµÄÊý¾Ý¿âÊǺÜÖØÒªµÄ¡£Èç¹û·¢Éúϵͳ±ÀÀ££¬Äã¿Ï¶¨ÏëÄܹ»½«ÄãµÄ±í¾¡¿ÉÄܶªÊ§×îÉÙµÄÊý¾Ý»Ö¸´µ½±ÀÀ£·¢ÉúʱµÄ״̬¡£ÓÐʱ£¬ÕýÊÇMySQL¹ÜÀíÔ±Ôì³ÉÆÆ»µ¡£¹ÜÀíÔ±ÒѾ­ÖªµÀ±íÒÑÆÆ»µ£¬ÓÃÖîÈçvi»òEmacsµÈ±à¼­Æ÷ÊÔͼֱ½Ó±à¼­ËüÃÇ£¬Õâ¶Ô±í¾ø¶Ô²»ÊǼ ......

ÔÚC#.net³ÌÐòÖÐʹÓÃMYSQLÊý¾Ý¿â

ÏÂÃæÊÇcommond:
MySQLCommand cmd;
cmd = new MySQLDriverCS.MySQLCommand("DROP TABLE IF EXISTS test.mysqldrivercs_test",conn);
cmd.ExecuteNonQuery();
cmd.Dispose();
ÏÂÃæÊÇinsert:
string Value = "Value";
int SettingID = 1;
new MySQLInsertCommand(conn,
new object[,] {{"SettingID",SettingID},{"S ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ