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

Ubuntu9.10_server_Ï°²×°Mysql 5.5.0 M2

×÷Õߣº°½Ê¿Î°
Mysql ÓõÄÊÇLinux (non RPM packages)
Ò»¡¢½«mysql-5.5.0-m2-linux-i686-glibc23.tar.gzÏÂÔص½/home/ikmb ²¢ÔÚµ±Ç°Ä¿Â¼½âѹ£»
……..
mysql-5.5.0-m2-linux-i686-glibc23/data/mysql/
mysql-5.5.0-m2-linux-i686-glibc23/data/test/
…………
¶þ¡¢´´½¨MySQL×飬½¨Á¢MySQLÓû§²¢¼ÓÈëµ½mysql×éÖÐ
ikmb@ikmb-desktop:~/mysql-5.5.0-m2-linux-i686-glibc23/bin$ sudo groupadd mysql
ikmb@ikmb-desktop:~/mysql-5.5.0-m2-linux-i686-glibc23/bin$ sudo useradd -g mysql mysql
Èý¡¢½øÈëĿ¼/usr/local£¬½âѹËõÃâ°²×°°æ£¬²¢ÔÚ´ËĿ¼Öн¨Á¢ÃûΪmysqlµÄÈíÁ´½Ó
ikmb@ikmb-desktop:~/mysql-5.5.0-m2-linux-i686-glibc23/bin$ cd /usr/local 
ikmb@ikmb-desktop:/usr/local$ sudo ln -s /home/ikmb/mysql-5.5.0-m2-linux-i686-glibc23 mysql
ËÄ¡¢É趨Ŀ¼·ÃÎÊȨÏÞ£¬ÓÃmysql_install_db´´½¨MySQLÊÚȨ±í³õʼ»¯£¬²¢ÉèÖÃmysql,rootÕʺŷÃÎÊȨÏÞ
ikmb@ikmb-desktop:/usr/local$ sudo chown 777 -R mysql
ikmb@ikmb-desktop:/usr/local$ sudo chown -R mysql .
ikmb@ikmb-desktop:/usr/local$ sudo chgrp -R mysql .
ikmb@ikmb-desktop:/usr/local$ cd mysql
Îå¡¢Ìí¼ÓMySQLÅäÖÃÎļþ
ikmb@ikmb-desktop:~/mysql-5.5.0-m2-linux-i686-glibc23/support-files$ sudo cp /home/ikmb/mysql-5.5.0-m2-linux-i686-glibc23/support-files/my-large.cnf /etc/my.cnf
Áù¡¢ÐÞ¸Ä/etc/my.cnf
ÔÚ[mysqld] ÏÂÌí¼Ó
basedir = /usr/local/mysql
datadir = /usr/local/mysql/data
×¢£º´Ë²½ÔÚmysql_install_db֮ǰ
Æß¡¢ÓÃmysql_install_db´´½¨MySQLÊÚȨ±í³õʼ»¯£¬×¢ÒâbasedirÑ¡Ïî
ikmb@ikmb-desktop:~/mysql-5.5.0-m2-linux-i686-glibc23/scripts$ sudo ./mysql_install_db --user=mysql  --basedir=/home/ikmb/mysql-5.5.0-m2-linux-i686-glibc23
Installing MySQL system tables...
OK
Filling help tables...
OK
………..
/home/ikmb/mysql-5.5.0-m2-linux-i686-glibc23/bin/mysqladmin -u root password 'new-password'
/home/ikmb/mysql-5.5.0-m2-linux-i686-glibc23/bin/mysqladmin -u root -h ikmb-desktop password 'new-password'
Alternatively you can run:
/home/ikmb/mysql-5.5.0-m2-linux-i686-glibc23/bin/mysql_secure_installation
which will


Ïà¹ØÎĵµ£º

mysql errno: 150 ´íÎó Íâ¼ü

ERROR 1005 (HY000): Can't create table '  ****.frm' (errno: 150)
ÎÒÊÇ´ÓÒÔϼ¸¸ö·½Ãæ½â¾öÁË´ËÎÊÌ⣺
1¡¢È·±£²ÎÕյıíºÍ×Ö¶ÎÊÇ´æÔڵģ»
2¡¢×é³ÉÍâ¼üµÄ×Ö¶ÎÒªÇó±»Ë÷Òý(Ö÷ÒªÊÇÍâ¼üÄǸö×Ö¶ÎÒªÇóÔÚÆäËû±íÖÐÊÇÖ÷¼ü)£»
3¡¢Íâ¼ü¹ØÁªµÄÁ½±í»ò¶à±íÒªÇó¶¼ÊÇINNODBÀàÐÍµÄ±í£»
4¡¢×Ö¶ÎÀàÐÍ£¨ËµÃ÷£©ÒªÒ»Ñù`itemId` varchar( ......

[ÍƼö]MySQLÊý¾Ý¿âͼÐλ¯¹ÜÀí¹¤¾ßµÄʹÓÃ

×î½üÓõ½ÁËÒ»¿îÊý¾Ý¿âͼÐλ¯¹ÜÀí¹¤¾ßNavicat for MySQL £¬Ê¹ÓÃÖ®ºóÓÐÒ»Öָоõ£ºÔ­À´±à³Ì¿ÉÒԺܸßЧ£¡
ÒÔǰʹÓÃMySQLʱ£¬Ã¿´Î¶¼Ö»ÄÜÔÚÀàËÆDOSµÄ½çÃ濪·¢£¬Ê¹Óùٷ½ÌṩµÄ¹¤¾ßºÜÈÝÒ׾ͱ»¿¨µ½ÁË£¬¾õµÃ»¹ÊÇ×ÖÌõ½çÃæ±È½Ï¸ßЧ£¬µ«ÊdzõѧMySQL,ºÜ¶à¹¦Äܶ¼»¹Ã»ÓÐÍêÈ«Çå³þ£¬Ê¹Óð²È«ÐÔÉϵĿ¼ÂÇÒ²²»¹»³ÉÊì¡£ÕâʱºòÎÒ¿ ......

[C++]MySQLÊý¾Ý¿â²Ù×÷ʵÀý

»·¾³ÉèÖãº
°²×°ÍêMySQLÖ®ºó£¬½«°²×°Ä¿Â¼ÖеÄincludeĿ¼ÏµÄlibmysql.libÎļþ¿½µ½VS2008°²×°Ä¿Â¼ÖеÄVC\lib\Ï£¬È»ºóÔÚ ÏîÄ¿-Ñ¡Ïî-c/c++-³£¹æ Öеĸ½¼Ó°üº¬Ä¿Â¼ÒÔ¼° Á´½ÓÆ÷-³£¹æ Öеĸ½¼Ó¿âĿ¼ÖмÓÈë“c:\MySQL\include\”£¬²¢ÇÒÔÚ Á´½ÓÆ÷-ÊäÈë Öеĸ½¼ÓÒÀÀµÏîÄÚÌí¼Ó“lib ......

ÔÚUbuntuÖÐͨ¹ýÔ´Âë°²×°±àÒë°²×°Èí¼þ(MySQLƪ)

        ʹÓÃUbuntu
Server×÷Ϊ±¾µØ²âÊÔ»·¾³ÒѾ­ÓÐÒ»¶Îʱ¼äÁË£¬Ò»Ö±¶¼ÊÇʹÓÃapt-get·½Ê½À´°²×°¸÷ÖÖÓ¦ÓÃÈí¼þ£¬Í¨¹ýÔ´Âë±àÒë°²×°Ó¦ÓÃÈí¼þÊÇLinuxºÍUnix»·
¾³ÏÂ×î³£Óõķ½Ê½¡£Í¨¹ýÔ´Âë±àÒë°²×°µÄ×î´óºÃ´¦¾ÍÊÇÄãÖªµÀ×Ô¼º×öÁËʲô£¬ÕâÖÖ·½Ê½°²×°Èí¼þ×ÔÓÉÁé»î£¬Ò²ÊÊÓÃÓÚ¸÷ÖÖƽ̨¡¢Î¬»¤·½±ã£ ......

MySQL 3.23 ÖÐÎIJο¼ÊÖ²á

mysql_affected_rows() ·µ»Ø±»×îеÄUPDATE, DELETE»òINSERT²éѯӰÏìµÄÐÐÊý¡£ 
mysql_close() ¹Ø±ÕÒ»¸ö·þÎñÆ÷Á¬½Ó¡£ 
mysql_connect() Á¬½ÓÒ»¸öMySQL·þÎñÆ÷¡£¸Ãº¯Êý²»ÍƼö£»Ê¹ÓÃmysql_real_connect()´úÌæ¡£ 
mysql_change_user() ¸Ä±äÔÚÒ»¸ö´ò¿ªµÄÁ¬½ÓÉϵÄÓû§ºÍÊý¾Ý¿â¡£ 
mysql_create_db() ´´½¨Ò ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ