½âѹ°æ/Ãâ°²×°°æMySQLÅäÖÃÈ«½â
Ò» ÏÂÔØMySQL
http://dev.mysql.com/downloads/mysql/5.0.html
½âѹMySQL£¨F:\Program Files\MySQL\£©MySQL°²×°Ä¿Â¼
¶þ н¨my.ini
ÔÚF:\Program Files\MySQL\Ͻ¨Á¢my.iniÎļþ£¬ÄÚÈÝΪ
my.ini
[mysqld]
# ÉèÖÃmysqlµÄ°²×°Ä¿Â¼
basedir=F:\\Program Files\\MySQL
# ÉèÖÃmysqlÊý¾Ý¿âµÄÊý¾ÝµÄ´æ·ÅĿ¼£¬±ØÐëÊÇdata£¬»òÕßÊÇ\\xxx-data
datadir=F:\\Program Files\\MySQL\\data
# ÉèÖÃmysql·þÎñÆ÷µÄ×Ö·û¼¯ £¬Ä¬ÈϱàÂë
default-character-set=latin1
[client]
# ÉèÖÃmysql¿Í»§¶ËµÄ×Ö·û¼¯
default-character-set=latin1
[WinMySQLAdmin]
# Ö¸¶¨mysql·þÎñÆô¶¯Æô¶¯µÄÎļþ
Server=F:\\Program Files\\MySQL\\bin\\mysqld.exe
Èý ×¢²áMySQL·þÎñ£¬Ê¹MySQL¿ÉÒÔÔÚ·þÎñÏîÄ¿ÖÐÆô¶¯»ò¹Ø±Õ
1£©½øÈ밲װĿ¼\bin£¬Ö´ÐУº
F:\Program Files\MySQL\bin>mysqld -install
ÏÔʾ£ºService successfully installed. Ôò×¢²á·þÎñ³É¹¦¡£
Èç¹ûҪɾ³ý·þÎñ£º
F:\Program Files\MySQL\bin>mysqld -remove
2£©ÐÞ¸Ä×¢²á±í£º
HKEY_LOCAL_MACHINE\System\CurrentControlSet\Services\MySQL\ImagePath
ÐÞ¸ÄΪ£º
"F:\Program Files\MySQL\bin\mysqld" --defaults-file=
"F:\Program Files\MySQL\my.ini" MySQL
ÕâÑùÅäÖþͿÉÒÔʹÓÃnet start mysqlÃüÁîÕý³£Æô¶¯MySQL¡£
ËÄ ÐÞ¸ÄrootÃÜÂë
MySQLÅäÖÃºÃºó£¬Æô¶¯³É¹¦£¬Ä¬ÈÏÃÜÂëÊǿգ¬µ«ÊÇΪÁ˰²È«£¬ÉèÖÃÃÜÂ루һ°ãÓû§ÃûΪroot£¬ÃÜÂëΪroot£©¡£
1£©µÇ¼MySQL rootÓû§£º
½øÈëMySQL°²×°Ä¿Â¼\bin£¬Ö´ÐУº
F:\Program Files\MySQL\MySQL-6.0.7\bin>mysql -u root;
2£© ÐÞ¸ÄrootÃÜÂ룺
mysql> update mysql.user set password=PASSWORD('new password') where User='root';
mysql> flush privileges;
±¾ÎÄÀ´×ÔCSDN²©¿Í£¬×ªÔØÇë±êÃ÷³ö´¦£ºhttp://blog.csdn.net/oswin_jiang/archive/2009/08/11/4433481.aspx
Ïà¹ØÎĵµ£º
×ªÔØÇë×¢Ã÷×÷Õߺͳö´¦
http://www.cnlinux.net
Ò»¡¢½éÉÜ
========
²âÊÔ»·¾³£º
Server1:ndbd 192.168.0.11
Server2:ndbd 192.168.0.12
Server3:mysqld --ndb-cluster 192.168.0.13 (ndbd_mgm ndbd_mgmdÒ²ÔÚ±¾»ú)
²Ù×÷ϵͳ¾ùΪ
RH ES3
kernel-2.4.21-9.EL
glibc-2.3.2-95.6
ËùÐèÈí¼þ°ü£º
mysql-max-5.0.22-lin ......
½ñÌ쿪¶àÒ»¸öÓ¦ÓÃÔÚ APP SERVER ÉÏ£¬±¨¸æÒ»¸ö´íÎó:
ERROR 1040 (00000): Too many connections
Õâµ¹ÊÇ´ÓÀ´Ã»Åöµ½¹ý£¬²»¹ýÔÚ console Ï¿ÉÒÔÓà root µÇ¼ £¨console ÏÂÓÃÆäËûÓû§Ò²²»¿ÉµÇ¼£¬Too many connections£©
mysql -uroot -p
mysql > show processlist;
...
ÕâÀïÁÐÁË100¸öÁ´½Ó£¡£¡ÆäÖÐÖ»ÓÐ2¸öÁ´½ÓÊÇQ ......
ÆÕͨË÷Òý¡¢Î¨Ò»Ë÷ÒýºÍÖ÷Ë÷Òý
1. ÆÕͨË÷Òý
ÆÕͨË÷Òý(Óɹؼü×ÖKEY»òINDEX¶¨ÒåµÄË÷Òý)µÄΨһÈÎÎñÊǼӿì¶ÔÊý¾ÝµÄ·ÃÎÊËÙ¶È¡£Òò´Ë£¬Ó¦¸ÃֻΪÄÇЩ×î¾³£³öÏÖÔÚ²éѯÌõ¼þ(WHERE column = …)»òÅÅÐòÌõ¼þ(ORDER BY column)ÖеÄÊý¾ÝÁд´½¨Ë÷Òý¡£Ö»ÒªÓпÉÄÜ£¬¾ÍÓ¦¸ÃÑ¡ÔñÒ»¸öÊý¾Ý×îÕûÆë¡¢×î½ô´ÕµÄÊý¾ÝÁÐ(ÈçÒ»¸öÕûÊýÀàÐ͵ÄÊý¾ÝÁÐ)À ......
/*²éѯÊý¾Ý¿â*/
show databases;
/*´´½¨Êý¾Ý¿â*/
create database dengheping;
/*ʹÓÃÊý¾Ý¿â*/
use dengheping;
/*´´½¨±í*/
create table user(id int primary key auto_increment,name char(255));
/*²éѯ±í*/
show tables;
/*ÏÔʾ±í½á¹¹*/
desc user;
/*²åÈë×Ö¶Î*/
alter table user add password varchar(6 ......