mysql°²×°ÎÊÌâ
±¾ÈËÔÚÓÃÔ´Âë°ü°²×°mysqlʱ£¬¿ÉÒÔ³õʼ»¯Êý¾Ý£¬µ«Æô¶¯Ê±ÓÐ´í¡£
±àÒë²ÎÊý£º
./configure --prefix=/usr/local/server/mysql
³õʼ»¯Êý¾Ý£º
/usr/local/server/mysql/bin/mysql_install_db --basedir=/usr/local/server/mysql/ --datadir=/usr/local/server/data --user=server/usr/local/server/mysql/bin/mysql_install_db --basedir=/usr/local/server/mysql/ --datadir=/usr/local/server/data --user=server
Æô¶¯
/usr/local/server/mysql/bin/mysqld_safe &
´íÎóÐÅÏ¢£º
100130 04:54:57 mysqld_safe Logging to '/usr/local/server/mysql/var/204-74-221-199.hosting8.info.err'.
touch: cannot touch `/usr/local/server/mysql/var/204-74-221-199.hosting8.info.err': No such file or directory
chown: cannot access `/usr/local/server/mysql/var/204-74-221-199.hosting8.info.err': No such file or directory
100130 04:54:57 mysqld_safe Starting mysqld daemon with databases from /usr/local/server/mysql/var
/usr/local/server/mysql/bin/mysqld_safe: line 100: /usr/local/server/mysql/var/204-74-221-199.hosting8.info.err: No such file or directory
/usr/local/server/mysql/bin/mysqld_safe: line 137: /usr/local/server/mysql/var/204-74-221-199.hosting8.info.err: No such file or directory
100130 04:54:57 mysqld_safe mysqld from pid file /usr/local/server/mysql/var/204-74-221-199.hosting8.info.pid ended
/usr/local/server/mysql/bin/mysqld_safe: line 100: /usr/local/server/mysql/var/204-74-22
Ïà¹ØÎÊ´ð£º
±àÒëÆ÷£ºC-Free4
mysql µ¥¶À°²×°µÄ£¬ÏÖÔÚΪapache+php+mysql¿ÉÒÔʹÓá£
×î½üÔÚÁ·Ï°c£¬c++£»ÏëÓÃc£¬c++Á¬½ÓÏÂÎÒµÄmysql£¬ºÃ¶àµØ·½¶à˵mysql.hÕÒ²»µ½¡£¶øÇÒÎÒmysqlûÓÐËùνµÄincludeÎļþ¼Ð°¡¡£
Íü¸ßÊÖÖ¸µãÒ»¶ ......
CREATE DATABASE ADDRESSLIST;
USE ADDRESSLIST;
DROP TABLE IF EXISTS FRIEND;
CREATE TABLE FRIEND
(FRIEND_ID INTEGER NOT NULL AUTO_INCREMENT PRIMARY KEY ,
FRIEND_NAME VARCHAR(20) NOT N ......
ÔÌûÇë¿´
http://topic.csdn.net/u/20100115/09/98c6ac75-d6fe-4b6c-90dc-336a738a0c0f.html?14601
×ܽáϾÍÊÇ
apache php mysql ÎÒÈ«²¿¶¼ÓõÄÊÇgb2312£¬ÓÐʲô°ì·¨¿ÉÒÔ²»ÓÃÿ´Îmysql_query('SET character_set_r ......
ÓÐÒ»¸öjsÎļþ£¬ÊÇʵÏÖÎÄ×Ö¹ö¶¯µÄ£¬ÆäÖеıäÁ¿ÐèÒªµ½mysqlÊý¾Ý¿âÖжÁÈ¡£¬ÄÇôÔõÑùʵÏÖÊý¾Ý¿âÁ¬½Ó¶ø¶ÁÈ¡Êý¾Ý£¿
ÎÒÊDzËÄñ£¬×îºÃÓÐÍêÕûµÄ´úÂëºÍ½âÊÍ£¬Ð»Ð»¸÷λ´óϺ°¡°¡°¡°¡°¡°¡£¡£¡£¡
http://blog.csdn.net/jemlee2002 ......