¸ü¸Ä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Êý¾Ý¿âµÄÖ§³Öº¯Êý£º
mysql_affected_rows -- È¡µÃǰһ´Î MySQL ²Ù×÷ËùÓ°ÏìµÄ¼Ç¼ÐÐÊý
mysql_change_user -- ¸Ä±ä»î¶¯Á¬½ÓÖеǼµÄÓû§
mysql_client_encoding -- ·µ»Ø×Ö·û¼¯µÄÃû³Æ
mysql_close -- ¹Ø±Õ MySQL Á¬½Ó
mysql_connect -- ´ò¿ªÒ»¸öµ½ MySQL ·þÎñÆ÷µÄÁ¬½Ó
mysql_c ......
´Ó±¾Æª²©ÎÄ¿ªÊ¼£¬ÎÒÃǾÍÒªÉîÈëµ½PHPµÄÓ¦Óõ±ÖÐÈ¥ÁË¡£PHPµÄÊý¾Ý¿âÓ¦ÓÃÊÇÖØÖÐÖ®ÖØ£¬±ØÐëÕÆÎÕ¡£Ñ¡ÔñʲôÑùµÄÊý¾Ý¿âÄØ£¬µ±È»ÊÇÎÒÃǵÄMySQLÀ²£¬Ã»ÓÐÈË»áȥʹÓÃÄÇЩÅÓ´ó¡¢µÍЧ¶øÓÖ°º¹óµÄÉÌÒµÊý¾Ý¿âÀ´¹¹½¨PHPÓ¦Óðɡ£
1 MySQLÊý¾Ý¿âµÄ°²×°
¹ýÈ¥£¬°²×°Ò»¸öMySQLÊý¾Ý¿â²¢ÇÒÒªÆô¶¯ÆðÀ´ºÜ·ÑÊ£¬ÌرðÊÇÔÚLinuxÕâÑùµÄ¿ª·¢»·¾³Ï£¬ÐèÒª¸ ......
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;
......