ubuntu°²×°MySQL£¬Apache
°²裝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 install php5-mysql
測試¡¢設ÃÜ碼 MySQL
#mysql -u root
#mysqladmin -u root password 'your.password'
#mysql -u root -p
Ïà¹ØÎĵµ£º
ÔÚwindowsÏ£º
´ò¿ªÃüÁîÐд°¿Ú£¬Í£Ö¹mysql·þÎñ£º Net stop mysql
Æô¶¯mysql£¬Ò»°ãµ½mysqlµÄ°²×°Â·¾¶£¬ÕÒµ½ mysqld-nt.exe
Ö´ÐУºmysqld-nt --skip-grant-tables µ±Ç°´°¿Ú½«»áÍ£Ö¹¡£
ÁíÍâ´ò¿ªÒ»¸öÃüÁîÐд°¿Ú£¬Ö´ÐÐmysql Èç¹ûÌáʾûÓÐÕâ¸öÃüÁÏȽøÈëMYSQL ......
Ò»¡¢Á¬½ÓMYSQL
¸ñʽ£º mysql -hÖ÷»úµØÖ· -uÓû§Ãû £pÓû§ÃÜÂë
1¡¢Àý1£ºÁ¬½Óµ½±¾»úÉϵÄMYSQL¡£
Ê×ÏÈÔÚ´ò¿ªDOS´°¿Ú£¬È»ºó½øÈëĿ¼ mysqlbin£¬ÔÙ¼üÈëÃüÁîmysql -uroot -p£¬»Ø³µºóÌáʾÄãÊäÃÜÂ룬Èç¹û¸Õ°²×°ºÃMYSQL£¬³¬¼¶Óû§rootÊÇûÓÐÃÜÂëµÄ£¬¹ÊÖ±½Ó»Ø³µ¼´¿É½øÈëµ½MYSQLÖÐÁË£¬MYSQLµÄÌáʾ·ûÊÇ£ºmysql>
2¡¢Àý2£ºÁ¬½Óµ½Ô ......
»ù±¾²éѯ
SELECTÓï¾äÓÃÓÚ²éѯÊý¾Ý¿âºÍSQLÖеÄËùÓÐÊä³ö²Ù×÷¡£
SELECTc_u_name, emailfromcooya_users;
Êä³öcooya_users±íÖÐËùÓÐÐУ¨»ò¼Ç¼£©µÄÊôÐÔc_u_nameºÍemailµÄÖµ¡£
Èç¹ûÐèÒªËùÓÐÊôÐÔ£¬¿ÉÒÔʹÓÃÐǺţ¨*£©µÄ¿ì½Ý·½Ê½¡£
SELECT* from cooya_users;
SELECTÓï¾ä»¹¿ÉÒÔÊä³ö²»ÊÇÊý¾Ý¿âÖеÄÊý¾Ý¼°¿ÉÒÔÓÃ×÷¼òµ¥µÄ¼ÆËã·û ......
Ò»¡¢°²×°
1. Ê×ÏȰ²×°SSH
sudo apt-get install ssh
2.°²×°MySQL(ËäÈ»ÏÖÔÚ×îаæÎª5.1£¬µ«ÊÇ»¹Ö»ÄÜ×°5.0°æ±¾)
sudo apt-get install mysql-server-5.0
3.°²×°Apache
sudo apt-get install apache2
4.°²×°PHP
sudo apt-get install php5 libapache2-mod-php5
5.ÖØÆôApache
sudo /etc/init.d/apache2 restart ......
$sudo nano /etc/apparmor.d/usr.sbin.mysqld
ÔÚgeditÖÐÕÒµ½/var/lib/mysql/ÕâÁ½ÐУ¬×¢Ê͵ôÕâÁ½ÐУ¬ÔÚÕâÁ½ÐÐǰ·Ö±ðÌí¼ÓÒ»¸ö·ûºÅ“#”¼´¿É×¢ÊÍ£¬ÔÚÕâÁ½ÐÐ֮ǰ»ò
Ö®ºó¼ÓÉÏÏÂÃæÄÚÈÝ£º
/home/mysql/ r,
/home/mysql/** rwk,
±£´æºóÍ˳ö£¬Ö´ÐÐÃüÁ
$sudo /etc/init.d/apparmor reload
·µ»ØReloading AppArmo ......