½â¾öÈçºÎÐÞ¸Ämysql·þÎñÆ÷¼àÌý¶Ë¿ÚµÄÎÊÌâ
1£©Èç¹ûÄã°²×°µÄÊÇϵͳ×Ô´øµÄrpm°üµÄÇé¿ö£º
ÐÞ¸Ä /etc/my.cnf
[mysqld]
datadir=/var/lib/mysql
port=3300 #Ð޸ijÉÄã×Ô¼ºÏëÒªµÄ¶Ë¿Ú
socket=/var/lib/mysql/mysql.sock
[mysql.server]
user=mysql
basedir=/var/lib
[safe_mysqld]
err-log=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
±£´æÍ˳ö¡£
2£©Èç¹ûÄã°²×°µÄÊÇÆäËûÔ´Âë°ü»òÕßÔÚͬһ·þÎñÆ÷Éϰ²×°¶à¸ömysqld·þÎñµÄÇé¿ö£º
ͬÑùµÄÅäÖã¬ÕÒ³ömy.cnf Îļþ¡£Ìí¼Óport= ¶Ë¿ÚºÅ
ÐèҪעÒâµÄÊÇ
[client]
port = 3300
ÕâÀïÒ²Òª¸Äһϡ£
Ïà¹ØÎĵµ£º
Ê×ÏÈÄãÒªÀí½â,innodbµÄÖ÷¼üË÷Òý¶¼ÊǾ۴ØË÷Òý,ËüµÄ¸¨ÖúË÷ÒýÀïÃæ¶¼°üº¬ÓбíµÄÖ÷¼ü,¶øÇÒÖ÷¼ü¶¼ÔÚ¸¨ÖúË÷ÒýµÄ×îºóÒ»ÁÐ.¶ømyisamµÄË÷Òý,¶¼ÊÇÆÕͨË÷Òý,´æ´¢µÄÊÇÁеÄÖµ,»¹ÓÐÁÐÔÚÔ±íÖеĵØÖ·Öµ---²»´æ´¢Ö÷¼üÖµ.
ºÃÁË,ÏÂÃæÎÒÃÇ¿ªÊ¼:
ÏÈ´´½¨Á½¸ö±í:Ò»¸öÊÇinnodbÒýÇæµÄ,Ò»¸öÊÇmyisamÒýÇæµÄ
CREATE TABLE `innodb` ( `id` in ......
°²裝MySQL-Server
$ sudo apt-get install mysql-server
°²裝Apache HTTP Server
$ sudo apt-get install apache2
°²裝PHP for Apache HTTP Server
$ sudo apt-get install php5
°²裝MySQL for Apache HTTP Server
$ sudo apt-get install libapache2-mod-auth-mysql
$ sudo apt-get ......
MySql¼òÒױʼÇ
1£º°²×°http://download.mysql.cn/src/2006/0710/5543.html£»
2£º´ò¿ªmysqlµÄCMD
3£º´´½¨Ò»¸öÊý¾Ý¿â¼°±í£º
mysql> CREATE DATABASE bbs;
mysql> CREATE TABLE pet (name VARCHAR(20), owner VARCHA ......
write by ¾ÅÌìÑãôá(JTianLing) -- blog.csdn.net/vagrxie ÌÖÂÛÐÂÎÅ×é¼°Îļþ ½ñÌì¿´µ½CSDNÉϵÄÒ»ÔòÐÂÎÅ¡¶Å·ÃËÕýʽ·ñ¾ö¼×¹ÇÎÄÊÕ¹ºSun ¼×¹ÇÎľÝÀíÁ¦Õù¡·ºóÕæÊǸÐ̾°¡¡£¡£¡£¡£ SunÒ²ËãÊÇÊ¢¼«Ò»Ê±µÄ´ó¹«Ë¾ÁË£¬ÒòΪJAVAÓïÑÔ¶øÎÅÃûÓÚÊÀ£¬ºóÀ´¹ÉƱ´úÂë¶¼¸Ä³ÉJAVAÁË£¬ËäÈ»JAVAʵ¼ÊÉÏûÓÐΪÆä´øÀ´Ì«¶àµÄÀûÈ󣬵«ÊÇSunÒ²ËãÊÇÄܹ»×Ô¼ ......