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

¸ü¸ÄMySQLĿ¼µÄ·½·¨

   ÀýÈ磬MySQLĬÈϵÄÊý¾ÝÎļþ´æ´¢Ä¿Â¼Îª/var/lib/mysql¡£¼ÙÈçÒª°ÑÄ¿Â¼ÒÆµ½/home/dataÏÂÐèÒª½øÐÐÏÂÃæ¼¸²½£º
1¡¢homeĿ¼Ï½¨Á¢dataĿ¼
       cd /home
       mkdir data
2¡¢°ÑMySQL·þÎñ½ø³ÌÍ£µô£º
       mysqladmin -u root -p shutdown
3¡¢°Ñ/var/lib/mysqlÕû¸öÄ¿Â¼ÒÆµ½/home/data
       mv /var/lib/mysql /home/data/
       ÕâÑù¾Í°ÑMySQLµÄÊý¾ÝÎļþÒÆ¶¯µ½ÁË/home/data/mysqlÏÂ
4¡¢ÕÒµ½my.cnfÅäÖÃÎļþ
       Èç¹û/etc/Ŀ¼ÏÂûÓÐmy.cnfÅäÖÃÎļþ£¬Çëµ½/usr/share/mysql/ÏÂÕÒµ½*.cnfÎļþ£¬¿½±´ÆäÖÐÒ»¸öµ½/etc/Ŀ¼Ï²¢¸ÄÃûΪmy.cnf¡£ÃüÁîÈçÏ£º
       [root@test1 mysql]# cp /usr/share/mysql/my-medium.cnf  /etc/my.cnf
5¡¢±à¼­MySQLµÄÅäÖÃÎļþ/etc/my.cnf
       Ϊ±£Ö¤MySQLÄܹ»Õý³£¹¤×÷£¬ÐèÒªÖ¸Ã÷mysql.sockÎļþµÄ²úÉúλÖᣠÐÞ¸Äsocket=/var/lib/mysql/mysql.sockÒ»ÐÐÖеȺÅÓұߵÄֵΪ£º/home/mysql/mysql.sock ¡£²Ù×÷ÈçÏ£º
vi my.cnf (ÓÃvi¹¤¾ß±à¼­my.cnfÎļþ£¬ÕÒµ½ÏÂÁÐÊý¾ÝÐÞ¸ÄÖ®)
# The MySQL server
[mysqld]
port = 3306
#socket = /var/lib/mysql/mysql.sock£¨Ô­ÄÚÈÝ£¬ÎªÁ˸üÎÈÍ×ÓÓ#”×¢ÊÍ´ËÐУ©
socket = /home/data/mysql/mysql.sock £¨¼ÓÉÏ´ËÐУ©
6¡¢ÐÞ¸ÄMySQLÆô¶¯½Å±¾/etc/rc.d/init.d/mysql
   ×îºó£¬ÐèÒªÐÞ¸ÄMySQLÆô¶¯½Å±¾/etc/rc.d/init.d/mysql£¬°ÑÆäÖÐdatadir=/var/lib/mysqlÒ»ÐÐÖУ¬µÈºÅÓұߵÄ·¾¶¸Ä³ÉÄãÏÖÔÚµÄʵ¼Ê´æ·Å·¾¶£º/home/data/mysql¡£
[root@test1 etc]# vi /etc/rc.d/init.d/mysql
#datadir=/var/lib/mysql £¨×¢ÊÍ´ËÐУ©
datadir=/home/data/mysql £¨¼ÓÉÏ´ËÐУ©
7¡¢ÖØÐÂÆô¶¯MySQL·þÎñ
   /etc/rc.d/init.d/mysql start
   »òÓÃrebootÃüÁîÖØÆôLinux ¡£
   Èç¹û¹¤×÷Õý³£Òƶ¯¾Í³É¹¦ÁË£¬·ñÔò¶ÔÕÕÇ°ÃæµÄ7²½ÔÙ¼ì²éһϡ£


Ïà¹ØÎĵµ£º

PHP·ÃÎÊMySQLÊý¾Ý¿â

PHPÊÖ²áÉÏÌṩÁËÒÔÏÂһЩÖ÷ÒªµÄmysqlÊý¾Ý¿âµÄÖ§³Öº¯Êý£º
mysql_affected_rows -- È¡µÃǰһ´Î MySQL ²Ù×÷ËùÓ°ÏìµÄ¼Ç¼ÐÐÊý
mysql_change_user --  ¸Ä±ä»î¶¯Á¬½ÓÖеǼµÄÓû§
mysql_client_encoding -- ·µ»Ø×Ö·û¼¯µÄÃû³Æ
mysql_close -- ¹Ø±Õ MySQL Á¬½Ó
mysql_connect -- ´ò¿ªÒ»¸öµ½ MySQL ·þÎñÆ÷µÄÁ¬½Ó
mysql_c ......

MySQLÊý¾Ý¿âÏê½â

´Ó±¾Æª²©ÎÄ¿ªÊ¼£¬ÎÒÃǾÍÒªÉîÈëµ½PHPµÄÓ¦Óõ±ÖÐÈ¥ÁË¡£PHPµÄÊý¾Ý¿âÓ¦ÓÃÊÇÖØÖÐÖ®ÖØ£¬±ØÐëÕÆÎÕ¡£Ñ¡ÔñʲôÑùµÄÊý¾Ý¿âÄØ£¬µ±È»ÊÇÎÒÃǵÄMySQLÀ²£¬Ã»ÓÐÈË»áȥʹÓÃÄÇЩÅÓ´ó¡¢µÍЧ¶øÓÖ°º¹óµÄÉÌÒµÊý¾Ý¿âÀ´¹¹½¨PHPÓ¦Óðɡ£
1 MySQLÊý¾Ý¿âµÄ°²×°
¹ýÈ¥£¬°²×°Ò»¸öMySQLÊý¾Ý¿â²¢ÇÒÒªÆô¶¯ÆðÀ´ºÜ·ÑÊ£¬ÌرðÊÇÔÚLinuxÕâÑùµÄ¿ª·¢»·¾³Ï£¬ÐèÒª¸ ......

MySQLµÄÃÜÂëÉèÖÃ

http://www.3d308.cn/article.asp?id=37
shell> mysql -u root mysql
mysql> Update user SET Password=PASSWORD('new_password')
           Where user='root';
mysql> FLUSH PRIVILEGES; ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ