首页 诗词 字典 板报 句子 名言 友答 励志 学校 网站地图
当前位置: 首页 > 教程频道 > 数据库 > Mysql >

绿色版mysql装配使用

2013-08-06 
绿色版mysql安装使用一、下载MySQL http://www.mysql.org/downloads我下载的是mysql-noinstall-5.0.67-win3

绿色版mysql安装使用
一、下载MySQL
http://www.mysql.org/downloads我下载的是mysql-noinstall-5.0.67-win32.zip二、安装过程
?1、解压缩 mysql-noinstall-5.0.67-win32.zip 到一个C盘，重新命名为 MySQL5 。
????? 假定MYSQL_HOME=C:/ MySQL5 ?2、编辑mysql的运行配置文件my.ini，如果没有，可以拿my-medium.ini复制然后更名成 my.ini?[xhtml] view plaincopy

  1. #?Example?MySQL?config?file?for?medium?systems.??#??
  2. #?This?is?for?a?system?with?little?memory?(32M?-?64M)?where?MySQL?plays??#?an?important?part,?or?systems?up?to?128M?where?MySQL?is?used?together?with??
  3. #?other?programs?(such?as?a?web?server)??#??
  4. #?You?can?copy?this?file?to??#?/etc/my.cnf?to?set?global?options,??
  5. #?mysql-data-dir/my.cnf?to?set?server-specific?options?(in?this??#?installation?this?directory?is?C:/mysql/data)?or??
  6. #?~/.my.cnf?to?set?user-specific?options.??#??
  7. #?In?this?file,?you?can?use?all?long?options?that?a?program?supports.??#?If?you?want?to?know?which?options?a?program?supports,?run?the?program??
  8. #?with?the?"--help"?option.????
  9. #?The?following?options?will?be?passed?to?all?MySQL?clients??[client]??
  10. #password???=?your_password??port????????=?3306??
  11. socket??????=?/tmp/mysql.sock????
  12. #?Here?follows?entries?for?some?specific?programs????
  13. #?The?MySQL?server??[mysqld]??
  14. basedir?=?"C:/MySQL5"??datadir?=?"C:/MySQL5/data"??
  15. default-character-set=utf8????
  16. port????????=?3306??socket??????=?/tmp/mysql.sock??
  17. skip-locking??key_buffer?=?16M??
  18. max_allowed_packet?=?1M??table_cache?=?64??
  19. sort_buffer_size?=?512K??net_buffer_length?=?8K??
  20. read_buffer_size?=?256K??read_rnd_buffer_size?=?512K??
  21. myisam_sort_buffer_size?=?8M????
  22. #?Don't?listen?on?a?TCP/IP?port?at?all.?This?can?be?a?security?enhancement,??#?if?all?processes?that?need?to?connect?to?mysqld?run?on?the?same?host.??
  23. #?All?interaction?with?mysqld?must?be?made?via?Unix?sockets?or?named?pipes.??#?Note?that?using?this?option?without?enabling?named?pipes?on?Windows??
  24. #?(via?the?"enable-named-pipe"?option)?will?render?mysqld?useless!??#???
  25. #skip-networking????
  26. #?Disable?Federated?by?default??skip-federated??
  27. ??#?Replication?Master?Server?(default)??
  28. #?binary?logging?is?required?for?replication??log-bin=mysql-bin??
  29. ??#?required?unique?id?between?1?and?2^32?-?1??
  30. #?defaults?to?1?if?master-host?is?not?set??#?but?will?not?function?as?a?master?if?omitted??
  31. server-id???=?1????
  32. #?Replication?Slave?(comment?out?master?section?to?use?this)??#??
  33. #?To?configure?this?host?as?a?replication?slave,?you?can?choose?between??#?two?methods?:??
  34. #??#?1)?Use?the?CHANGE?MASTER?TO?command?(fully?described?in?our?manual)?-??
  35. #????the?syntax?is:??#??
  36. #????CHANGE?MASTER?TO?MASTER_HOST=<host>,?MASTER_PORT=<port>,??#????MASTER_USER=<user>,?MASTER_PASSWORD=<password>?;??
  37. #??#????where?you?replace?<host>,?<user>,?<password>?by?quoted?strings?and??
  38. #????<port>?by?the?master's?port?number?(3306?by?default).??#??
  39. #????Example:??#??
  40. #????CHANGE?MASTER?TO?MASTER_HOST='125.564.12.1',?MASTER_PORT=3306,??#????MASTER_USER='joe',?MASTER_PASSWORD='secret';??
  41. #??#?OR??
  42. #??#?2)?Set?the?variables?below.?However,?in?case?you?choose?this?method,?then??
  43. #????start?replication?for?the?first?time?(even?unsuccessfully,?for?example??#????if?you?mistyped?the?password?in?master-password?and?the?slave?fails?to??
  44. #????connect),?the?slave?will?create?a?master.info?file,?and?any?later??#????change?in?this?file?to?the?variables'?values?below?will?be?ignored?and??
  45. #????overridden?by?the?content?of?the?master.info?file,?unless?you?shutdown??#????the?slave?server,?delete?master.info?and?restart?the?slaver?server.??
  46. #????For?that?reason,?you?may?want?to?leave?the?lines?below?untouched??#????(commented)?and?instead?use?CHANGE?MASTER?TO?(see?above)??
  47. #??#?required?unique?id?between?2?and?2^32?-?1??
  48. #?(and?different?from?the?master)??#?defaults?to?2?if?master-host?is?set??
  49. #?but?will?not?function?as?a?slave?if?omitted??#server-id???????=?2??
  50. #??#?The?replication?master?for?this?slave?-?required??
  51. #master-host?????=???<hostname>??#??
  52. #?The?username?the?slave?will?use?for?authentication?when?connecting??#?to?the?master?-?required??
  53. #master-user?????=???<username>??#??
  54. #?The?password?the?slave?will?authenticate?with?when?connecting?to??#?the?master?-?required??
  55. #master-password?=???<password>??#??
  56. #?The?port?the?master?is?listening?on.??#?optional?-?defaults?to?3306??
  57. #master-port?????=??<port>??#??
  58. #?binary?logging?-?not?required?for?slaves,?but?recommended??#log-bin=mysql-bin??
  59. ??#?Point?the?following?paths?to?different?dedicated?disks??
  60. #tmpdir?????=?/tmp/???????#log-update?????=?/path-to-dedicated-directory/hostname??
  61. ??#?Uncomment?the?following?if?you?are?using?BDB?tables??
  62. #bdb_cache_size?=?4M??#bdb_max_lock?=?10000??
  63. ??#?Uncomment?the?following?if?you?are?using?InnoDB?tables??
  64. #innodb_data_home_dir?=?C:/mysql/data/??#innodb_data_file_path?=?ibdata1:10M:autoextend??
  65. #innodb_log_group_home_dir?=?C:/mysql/data/??#innodb_log_arch_dir?=?C:/mysql/data/??
  66. #?You?can?set?.._buffer_pool_size?up?to?50?-?80?%??#?of?RAM?but?beware?of?setting?memory?usage?too?high??
  67. #innodb_buffer_pool_size?=?16M??#innodb_additional_mem_pool_size?=?2M??
  68. #?Set?.._log_file_size?to?25?%?of?buffer?pool?size??#innodb_log_file_size?=?5M??
  69. #innodb_log_buffer_size?=?8M??#innodb_flush_log_at_trx_commit?=?1??
  70. #innodb_lock_wait_timeout?=?50????
  71. [mysqldump]??quick??
  72. max_allowed_packet?=?16M????
  73. [mysql]??no-auto-rehash??
  74. #?Remove?the?next?comment?character?if?you?are?not?familiar?with?SQL??#safe-updates??
  75. ??[isamchk]??
  76. key_buffer?=?20M??sort_buffer_size?=?20M??
  77. read_buffer?=?2M??write_buffer?=?2M??
  78. ??[myisamchk]??
  79. key_buffer?=?20M??sort_buffer_size?=?20M??
  80. read_buffer?=?2M??write_buffer?=?2M??
  81. ??[mysqlhotcopy]??
  82. interactive-timeout??
[mysqld]
# 设置mysql的安装目录
basedir=$MYSQL_HOME
# 设置mysql数据库的数据的存放目录，必须是data，或者是//xxx/data
datadir=$MYSQL_HOME/data
# 设置mysql服务器的字符集
default-character-set=utf8
?
[client]
# 设置mysql客户端的字符集
default-character-set=gbk ?3、安装mysql服务
从MS-DOS窗口进入目录E:/myserver/mysql-5.0.37-win32/bin，运行如下命令：
mysqld --install mysql --defaults-file=C:/MySQL5/my.ini ?4、启动mysql数据库
还在上面的命令窗口里面，输入命令：net start mysql
这样就启动了mysql 服务。 ?5、停止服务
执行 net stop mysql 即可

6、删除服务
执行mysqld --remove mysql 即可 ?7、修改密码以上安装完毕之后，默认的root用户密码为空的。为了安全起见，需要设置一个root用户的密码。[xhtml] view plaincopy
  1. <STRONG><SPAN?style="COLOR:?#ffffff"?mce_style="COLOR:?#ffffff">C:/>cd?MySQL5????
  2. C:/MySQL5>cd?bin????
  3. C:/MySQL5/bin>mysql?-uroot?-p??Enter?password:??
  4. Welcome?to?the?MySQL?monitor.??Commands?end?with?;?or?/g.??Your?MySQL?connection?id?is?3??
  5. Server?version:?5.0.67-community-log?MySQL?Community?Edition?(GPL)????
  6. Type?'help;'?or?'/h'?for?help.?Type?'/c'?to?clear?the?buffer.????
  7. mysql>?use?mysql??Database?changed??
  8. mysql>?update?User?set?Password=PASSWORD('admin')?where?User='root';??Query?OK,?2?rows?affected?(0.08?sec)??
  9. Rows?matched:?2??Changed:?2??Warnings:?0</SPAN>????
  10. </STRONG>?

?

转自：http://blog.csdn.net/rocket5725/article/details/4278347

读书人精选
热点排行