windows 7 32 or 64bit 下 MySQL 5.5 安装笔记

1. 准备文件
   mysql 5.5 解压版(绿色版) 下载地址    

   http://cdn.mysql.com/Downloads/MySQL-5.5/mysql-5.5.30-win32.zip       (32 bit)

   http://cdn.mysql.com/Downloads/MySQL-5.5/mysql-5.5.30-winx64.zip      (64 bit)

                  
2. 解压到本地目录
   D:\devTools\mysql

3. 把MySql添加到系统环境变量
   MYSQL_HOME  ==>    D:\devTools\mysql  (新建)
   Path                   ==>    ;%MYSQL_HOME%\bin  (追加)

4. 修改MySQL5.5的配置文件,把my-small.ini(我用的是my-large.ini)改名为my.ini进行编辑
   a). 在[client]下追加

#设置mysql客户端的字符集
default-character-set = utf8

 

    b). 在[mysqld]下追加

#设置mysql的安装目录
basedir = D:\DevTools\mysql
#设置mysql数据库的数据存放目录,必须是data或者\xxx-data
datadir = D:\DevTools\mysql\data
#设置服务器段的字符集
character_set_server = utf8


5. 保存my.ini的配置, 然后打开命令行(开始菜单==>运行==>cmd )
   输入: mysqld --console  然后回车将看到如下类似内容:

C:\Users\Lstoryc>mysqld --console
130405 15:22:50 [Note] Plugin 'FEDERATED' is disabled.
130405 15:22:50 InnoDB: The InnoDB memory heap is disabled
130405 15:22:50 InnoDB: Mutexes and rw_locks use Windows interlocked functions
130405 15:22:50 InnoDB: Compressed tables use zlib 1.2.3
130405 15:22:50 InnoDB: Initializing buffer pool, size = 128.0M
130405 15:22:50 InnoDB: Completed initialization of buffer pool
130405 15:22:50 InnoDB: highest supported file format is Barracuda.
130405 15:22:51  InnoDB: Waiting for the background threads to start
130405 15:22:52 InnoDB: 5.5.30 started; log sequence number 2537522
130405 15:22:52 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
130405 15:22:52 [Note]   - '0.0.0.0' resolves to '0.0.0.0';
130405 15:22:52 [Note] Server socket created on IP: '0.0.0.0'.
130405 15:22:52 [Note] Event Scheduler: Loaded 0 events
130405 15:22:52 [Note] mysqld: ready for connections.
Version: '5.5.30-log'  socket: ''  port: 3306  MySQL Community Server (GPL)

   ==> 证明mysql服务已正常启动

6. 设置登陆mysql root帐号的的密码
    打开新的命令行,输入 mysql -uroot 回车

Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 1
Server version: 5.5.30-log MySQL Community Server (GPL)

Copyright (c) 2000, 2013, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql>

    ==〉看到上面类似内容说明登陆成功,此时的root帐号是没有密码的
    执行命令修改密码:

 

   use mysql;  

   update user set password=PASSWORD("这里填写你要设置的密码") where user='root';

  
   执行完成后退出mysql操作,然后关闭mysql服务(ctrl+C 关闭另一个命令窗口),然后重启mysql服务

 

 
Translate
From:—Detect language—AfrikaansAlbanianArabicArmenianAzerbaijaniBasqueBelarusianBengaliBulgarianCatalanChineseCroatianCzechDanishDutchEnglishEsperantoEstonianFilipinoFinnishFrenchGalicianGeorgianGermanGreekGujaratiHaitian CreoleHebrewHindiHungarianIcelandicIndonesianIrishItalianJapaneseKannadaKoreanLaoLatinLatvianLithuanianMacedonianMalayMalteseNorwegianPersianPolishPortugueseRomanianRussianSerbianSlovakSlovenianSpanishSwahiliSwedishTamilTeluguThaiTurkishUkrainianUrduVietnameseWelshYiddish
From: Detect language
 
 
To:English—AfrikaansAlbanianArabicArmenianAzerbaijaniBasqueBelarusianBengaliBulgarianCatalanChinese (Simplified)Chinese (Traditional)CroatianCzechDanishDutchEnglishEsperantoEstonianFilipinoFinnishFrenchGalicianGeorgianGermanGreekGujaratiHaitian CreoleHebrewHindiHungarianIcelandicIndonesianIrishItalianJapaneseKannadaKoreanLaoLatinLatvianLithuanianMacedonianMalayMalteseNorwegianPersianPolishPortugueseRomanianRussianSerbianSlovakSlovenianSpanishSwahiliSwedishTamilTeluguThaiTurkishUkrainianUrduVietnameseWelshYiddish
To: English
 
English
Spanish
French
Translate text or webpage
C:\Windows\system32>mysqld --console 120410 14:25:22 [Note] Plugin 'FEDERATED' is disabled. 120410 14:25:22 InnoDB: The InnoDB memory heap is disabled 120410 14:25:22 InnoDB: Mutexes and rw_locks use Windows interlocked functions 120410 14:25:22 InnoDB: Compressed tables use zlib 1.2.3 120410 14:25:22 InnoDB: Initializing buffer pool, size = 128.0M 120410 14:25:22 InnoDB: Completed initialization of buffer pool 120410 14:25:22 InnoDB: highest supported file format is Barracuda. 120410 14:25:22 InnoDB: Waiting for the background threads to start 120410 14:25:23 InnoDB: 1.1.8 started; log sequence number 1595675 120410 14:25:23 [Note] Event Scheduler: Loaded 0 events 120410 14:25:23 [Note] mysqld: ready for connections. Version: '5.5.30' socket: '' port: 3306 MySQL Community Server (GPL)
 
 
Type text or a website address or translate a document.
 
 
English
Spanish
Arabic
C:\Windows\system32>mysqld --console 120410 14:25:22 [Note] Plugin 'FEDERATED' is disabled. 120410 14:25:22 InnoDB: The InnoDB memory heap is disabled 120410 14:25:22 InnoDB: Mutexes and rw_locks use Windows interlocked functions 120410 14:25:22 InnoDB: Compressed tables use zlib 1.2.3 120410 14:25:22 InnoDB: Initializing buffer pool, size = 128.0M 120410 14:25:22 InnoDB: Completed initialization of buffer pool 120410 14:25:22 InnoDB: highest supported file format is Barracuda. 120410 14:25:22 InnoDB: Waiting for the background threads to start 120410 14:25:23 InnoDB: 1.1.8 started; log sequence number 1595675 120410 14:25:23 [Note] Event Scheduler: Loaded 0 events 120410 14:25:23 [Note] mysqld: ready for connections. Version: '5.5.30' socket: '' port: 3306 MySQL Community Server (GPL)
 
 
Alpha
 
 

Dictionary

Would you mind answering some questions to help improve translation quality?
We do not support the type of file you drop. Please try other file types.
  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
内容介绍 项目结构: Controller层:使用Spring MVC来处理用户请求,负责将请求分发到相应的业务逻辑层,并将数据传递给视图层进行展示。Controller层通常包含控制器类,这些类通过注解如@Controller、@RequestMapping等标记,负责处理HTTP请求并返回响应。 Service层:Spring的核心部分,用于处理业务逻辑。Service层通过接口和实现类的方式,将业务逻辑与具体的实现细节分离。常见的注解有@Service和@Transactional,后者用于管理事务。 DAO层:使用MyBatis来实现数据持久化,DAO层与数据库直接交互,执行CRUD操作。MyBatis通过XML映射文件或注解的方式,将SQL语句与Java对象绑定,实现高效的数据访问。 Spring整合: Spring核心配置:包括Spring的IOC容器配置,管理Service和DAO层的Bean。配置文件通常包括applicationContext.xml或采用Java配置类。 事务管理:通过Spring的声明式事务管理,简化了事务的处理,确保数据一致性和完整性。 Spring MVC整合: 视图解析器:配置Spring MVC的视图解析器,将逻辑视图名解析为具体的JSP或其他类型的视图。 拦截器:通过配置Spring MVC的拦截器,处理请求的预处理和后处理,常用于权限验证、日志记录等功能。 MyBatis整合: 数据源配置:配置数据库连接池(如Druid或C3P0),确保应用可以高效地访问数据库。 SQL映射文件:使用MyBatis的XML文件或注解配置,将SQL语句与Java对象映射,支持复杂的查询、插入、更新和删除操作。
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值