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µÄ#Äã¾Í²»ÓÃÈ¥ÁË)
Èç¹û
Ïà¹ØÎĵµ£º
»·¾³£ºÁ½Ì¨·þÎñÆ÷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 ......
1¡¢ÔÚlinuxÏ£º
²é¿´mysql ÊÇ·ñÔËÐУºps -ef | grep myslq
Èç¹û MySQL ÕýÔÚÔËÐУ¬Ê×ÏÈɱ֮: kill mysqlµÄ½ø³ÌºÅ¡£
¡¡¡¡Æô¶¯ MySQL :/usr/bin/safe_mysqld --skip-grant-tables &
¡¡¡¡¾Í¿ÉÒÔ²»ÐèÒªÃÜÂë¾Í½øÈë MySQL ÁË¡£
¡¡¡¡È»ºó¾ÍÊÇ
¡¡¡¡>use mysql
¡¡¡¡ ......
Ò»:mysqlÀïĿǰֻ֧³Ö4ÖÖË÷Òý·Ö±ðÊÇ:b-tree,full-text,hashÒÔ¼°r-treeË÷Òý b-treeË÷ÒýÓ¦¸ÃÊÇmysqlÀï×î¹ã·ºµÄË÷ÒýµÄÁË,³ýÁËarchive,»ù±¾ËùÓеĴ洢ÒýÇæ¶¼Ö§³ÖËü. 1.b-treeÔÚmyisamÀïµÄÐÎʽºÍinnodbÉÔÓв»Í¬ ÔÚinnodbÀïÃæÓÐÁ½ÖÖÐÎ̬:ÆäÒ»ÊÇprimary keyÐÎ̬Æäleaf nodeÀï´æ·ÅµÄÊÇÊý¾Ý.¶øÇÒ²»½ö´æ·ÅÁËË÷Òý¼üµÄÊý¾Ý,»¹´æ·ÅÁËÆ ......
12.8. Castº¯ÊýºÍ²Ù×÷·û
BINARY
BINARY²Ù×÷·û½«ºóÃæµÄ×Ö·û´®Å׸øÒ»¸ö¶þ½øÖÆ×Ö·û´®¡£ÕâÊÇÒ»ÖÖ¼òµ¥µÄ·½Ê½À´´ÙʹÖð×Ö½Ú¶ø²»ÊÇÖð×Ö·ûµÄ½øÐÐÁбȽϡ£ÕâʹµÃ±È½ÏÇø·Ö´óСд£¬¼´Ê¹¸ÃÁв»±»¶¨ÒåΪ BINARY»ò BLOB¡£BINARYÒ²»á²úÉú½áβ¿Õ°×£¬´Ó¶ø¸ü¼ÓÏÔ ......
20 MySQL¿Í»§¹¤¾ßºÍAPI
20.1 MySQL C API
C API´úÂëÊÇËæMySQL·Ö·¢µÄ£¬Ëü±»°üº¬ÔÚmysqlclient¿âÇÒÔÊÐíC³ÌÐò´æÈ¡Ò»¸öÊý¾Ý¿â¡£
ÔÚ MySQLÔ´´úÂë·Ö·¢Öеĺܶà¿Í»§ÊÇÓÃC±àдµÄ¡£Èç¹ûÄãÕýÔÚѰÕÒÑÝʾÔõÑùʹÓÃC APIµÄÀý×Ó£¬¿´Ò»ÏÂÕâЩ¿Í»§³ÌÐò¡£
´ó¶àÊýÆäËû¿Í»§ API(³ýÁËJavaµÄËùÓÐ)¶¼Ê¹ÓÃmysqlclient¿âÓëMySQL·þÎñÆ÷ͨÐÅ ......