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

MySQL¼¯Èº

1£¬½«6.0°æ±¾µÄmysql¼¯ÈºÈí¼þÉÏ´«µ½Linux»òÊÇSolarisÉÏ£¬½âѹ
 
 1>£¬ÎªÁË·½±ãµ÷Óý«Æä¸ÄÃûΪmysql£¬²¢ÇÒ·ÅÓÚ/usr/local/ÏÂ
 2>£¬´´½¨Á¬½ÓÎļþ£¬½øÈë/usr/local/ÏÂ
  
  ln -s ..../mysql mysql
2£¬´´½¨×飬Ìí¼ÓÓû§
 
 groupadd mysql
 useradd -g mysql mysql
3£¬È¨ÏÞµÄÐÞ¸Ä
 
 cd /usr/local/mysql
 
 chown -Rhf mysql .
 chgrp -Rhf mysql .
 
 Ö´Ðнű¾£¬´´½¨Êý¾Ý¿â
 
 scritps/mysql_install_db --user=mysql &
 chown -Rhf root .
 chown -Rhf mysql .
 chown -R mysql data
 chgrp -R mysql .
 
 cp support-file/mysql.server /etc/rc.d/ini.d/mysqld
 chmod +x /etc/rc.d/init.d/mysqld
 <chkconfig - add mysqld>
 ÑéÖ¤Æô¶¯Êý¾Ý¿â
 Æô¶¯Ê§°Ü¿ÉÒÔ³¢ÊÔ£º
  /etc/rc.d/init.d/mysqld stop/start
  service mysqld restart
 Èç¹û»¹ÊÇʧ°Ü
 ln -s /var/lib/mysql/mysql.sock /tmp/mysql.sock
 
  
 bin/mysqld_safe --user=mysql &
 
 ÑéÖ¤³É¹¦ºó£¬Í£Ö¹mysql£¬Í£Ö¹½ø³Ì
 ps -ef | grep mysql<ndb>
 kill -9 ½ø³Ì±êºÅ
4£¬´´½¨ÅäÖÃÎļþ
 vi my.cnf
 
[mysqld]
default-storage-engine=ndbcluster
ndbcluster
ndb-connectstring=10.85.0.90,10.85.0.80
[ndbd]
connect-string=10.85.0.90,10.85.0.80
[ndb_mgm]
connect-string=10.85.0.90,10.85.0.80
[ndb_mgmd]
config-file=/usr/local/mysql/config.ini
[mysql_cluster]
ndb-connectstring=10.85.0.90,10.85.0.80
5£¬´´½¨Æô¶¯Îļþ
 vi config.ini
[ndbd default]
NoOfReplicas= 2
MaxNoOfConcurrentOperations= 10000
DataMemory= 80M
IndexMemory= 24M
TimeBetweenWatchDogCheck= 30000
DataDir= /var/lib/mysql-cluster
MaxNoOfOrderedIndexes= 512
StartPartialTimeout=100
StartPartitionedTimeout=100
ArbitrationTimeout=5000
TransactionDeadlockDetectionTimeout=5000
HeartbeatIntervalDbDb=5000
StopOnError=0
[ndb_mgmd default]
DataDir= /var/lib/mysql-cluster
[ndb_mgmd]
Id=1
HostName= 10.85.0.90
[ndb_mgmd]
Id=2
Ho


Ïà¹ØÎĵµ£º

MysqlÓû§Ìí¼Ó¼°È¨ÏÞ·ÖÅä

     ¸ñʽ£ºgrant [PRIVILEGES]  on [databaseName.tableName] to [userName]@[host] identified by [password] with grant option;
     eg1:  grant select on mysql.user to wqh@localhost
     eg2:GRANT SELECT,INSERT,UPDATE,DELETE,CREATE ......

ÓÅ»¯MySQLÊý¾Ý¿âÐÔÄܵöºÃ·½·¨

1¡¢Ñ¡È¡×îÊÊÓõÄ×Ö¶ÎÊôÐÔ
¡¡¡¡MySQL¿ÉÒԺܺõÄÖ§³Ö´óÊý¾ÝÁ¿µÄ´æÈ¡£¬µ«ÊÇÒ»°ã˵À´£¬Êý¾Ý¿âÖеıíԽС£¬ÔÚËüÉÏÃæÖ´ÐеIJéѯҲ¾Í»áÔ½¿ì¡£Òò´Ë£¬ÔÚ´´½¨±íµÄʱºò£¬ÎªÁË»ñµÃ¸üºÃµÄÐÔÄÜ£¬ÎÒÃÇ¿ÉÒÔ½«±íÖÐ×ֶεĿí¶ÈÉèµÃ¾¡¿ÉÄÜС¡£ÀýÈ磬ÔÚ¶¨ÒåÓÊÕþ±àÂëÕâ¸ö×Ö¶Îʱ£¬Èç¹û½«ÆäÉèÖÃΪCHAR(255),ÏÔÈ»¸øÊý¾Ý¿âÔö¼ÓÁ˲»±ØÒªµÄ¿Õ¼ä£¬ÉõÖÁÊ ......

WindowsÏÂÓÃGCCÁ¬½ÓMySQLÊý¾Ý¿â

    Ò»¸öÍøÓÑÔÚ̳×ÓÉÏÎʵ½µÄÎÊÌ⣬˵ÓÃMinGW GCC±àÒëÔËÐÐÒ»¸öÁ¬½ÓMySQLÊý¾Ý¿âµÄ³ÌÐòʱÓöµ½´íÎó£º
undefined reference to `mysql_init@4'
undefined reference to `mysql_real_connect@32'
undefined reference to `mysql_close@4'

    ÎÒËìÈ¥MySQL¹ÙÍøÏÂÁ˸ö×îеÄWindows C Connect ......

¸ßÐÔÄÜMYSQL¶ÁÊé±Ê¼Ç£ºMYSQL×¼±¸Óï¾ä

MYSQL4.1¼°¸ü¸ß°æ±¾Ö§³Ö·þÎñÆ÷¶Ë×¼±¸Óï¾ä(Prepared Statements), ËüʹÓÃÔöÇ¿µÄ¶þ½øÖƿͻ§¶Ë/·þÎñÆ÷ЭÒéÔÚ¿Í»§¶ËºÍ·þÎñÆ÷Ö®¼ä¸ßЧµÄ·¢ËÍÊý¾Ý£¬¿ÉÒÔͨ¹ýÖ§³ÖÕâÖÖÐÐЭÒéµÄ±à³Ì¿âÀ´·ÃÎÊ×¼±¸Óï¾ä£¬ÁÐÈëMYSQL CAPI,MYSQL Connector/JºÍMYSQL Connector/NET ΪJAVAºÍ.NETÌṩÁËͬÑùµÄ·ÃÎʽӿڡ£ËüÒ²ÓÐSQLÓïÑԵķÃÎʽӿڡ£
´´½¨×¼ ......

MySqlÊý¾Ý¿â°æ±¾²éѯ

MySql°æ±¾ÐÅÏ¢µÄ²éѯ£º
1¡¢Í¨¹ýmysql -VÃüÁî²éѯ
C:\mysql\bin>mysql -V
mysql  Ver 12.22 Distrib 4.0.18, for Win95/Win98 (i32)
2¡¢Í¨¹ýmysqlģʽϵÄstatusÃüÁî²é¿´×´Ì¬
mysql> status
--------------
mysql  Ver 12.22 Distrib 4.0.18, for Win95/Win98 (i32)
Connection id:  &nbs ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ