Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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 ³£ÓÃÃüÁî

MySQL ÃüÁîÐÐ
µÚÒ»ÕС¢mysql·þÎñµÄÆô¶¯ºÍÍ£Ö¹
net stop mysql
net start mysql
µÚ¶þÕС¢µÇ½mysql
Óï·¨ÈçÏ£º mysql -uÓû§Ãû -pÓû§ÃÜÂë
¼üÈëÃüÁîmysql -uroot -p£¬ »Ø³µºóÌáʾÄãÊäÈëÃÜÂ룬ÊäÈë12345£¬È»ºó»Ø³µ¼´¿É½øÈëµ½mysqlÖÐÁË£¬mysqlµÄÌáʾ·ûÊÇ£º
mysql>
×¢Ò⣬Èç¹ûÊÇÁ¬½Óµ½ÁíÍâµÄ»úÆ÷ÉÏ£¬ÔòÐèÒª¼ÓÈëÒ»¸ö² ......

MySQL Master/Slave Server ¼ÜÉè



»·¾³£ºÁ½Ì¨·þÎñÆ÷IP:192.168.30.57\192.168.30.58
1¡¢ÏÂÔØmysql-5.0.86-linux-i686-glibc23.tar.gz µ½http://dev.mysql.com/downloads/mysql/5.0.html#linuxÏÂÔØ
2¡¢½âѹ tar -zxvf
mysql-5.0.86-linux-i686-glibc23.tar.gz
3¡¢´´½¨Á´½Ó ln -s
mysql-5.0.86-linux-i686-g ......

MySQLÊý¾Ý¿â²Ù×÷ÖÐÎÄÂÒÂë

½â¾öÂÒÂë×îºÃµÄ·½·¨ÊÇÔÚÏîÄ¿Éè¼ÆÖ®³õ£¬Í³Ò»ËùÓеÄ×Ö·û¼¯£¬ÀýÈçÒ³Ãæ¡¢request¶ÔÏóÒÔ¼°Êý¾Ý¿âµÈµÈ¡£
Ò»¡¢ ¼¸ÖÖ³£¼ûµÄÂÒÂëÏÖÏó£º
1¡¢Ò³ÃæÂÒÂë
    µ¥´¿µÄÒ³ÃæÂÒÂëÊǺܺýâ¾öµÄ£¬Ö»ÒªÐÞ¸ÄÍ·²¿ÊʺϵÄ×Ö·û¼¯¼´¿É£¬Èç¹ûÒ³ÃæÖÐÎÄÏÔʾÂÒÂ룬Äã¿ÉÒÔ°Ñ×Ö·û¼¯ÐÞ¸ÄΪ£ºgb2312»ògbk¡£
2¡¢Ò³ÃæÖ®¼ä´«µÝµÄ²ÎÊýÊÇÂÒÂë ......

mysql×Ö·û¼¯²é¿´ÒÔ¼°ÐÞ¸Ä

ת×Ô:http://blog.chinaunix.net/u2/85344/showart_2042280.html
LiunxÏÂÐÞ¸ÄMySQL×Ö·û¼¯£º
1.²éÕÒMySQLµÄcnfÎļþµÄλÖÃ
find / -iname '*.cnf' -print

/usr/share/mysql/my-innodb-heavy-4G.cnf
/usr/share/mysql/my-large.cnf
/usr/share/mysql/my-small.cnf
/usr/share/mysql/my-medium.cnf
/usr/share/mysql ......

MySQLµÄ°²×°£¨Ãâ°²×°°æ±¾£©

Ò»¡¢ÏÂÔØMySQL
¹Ù·½ÍøÕ¾£ºwww.mysql.org
¶þ¡¢°²×°
1.½«´ËѹËõ°ü½âѹËõµ½Öƶ¨Îļþ¼ÐÏ£¬ÒÔ"C:/mysql"ΪÀý
2.½«my-midium.ini¸´ÖÆÒ»·Ý£¬²¢ÖØÃüÃûΪmy.ini
3.½«C:/mysql/bin/libmysql.dll¸´ÖƵ½ÏµÍ³Ä¿Â¼Ï£¬ÀýÈç¸´ÖÆµ½"C:/windows"ÏÂ
4.ÔÚÃüÁîÐÐģʽÏ£¬ÔËÐÐC:/mysql/bin/mysqld£¬¼´¿É¿ªÆôMySQL·þÎñ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ