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