Lab7 MySQL安装以及简单数据库操作 实验目的 1)学习在 windows环境中安装 My Sql数据库 2)根据需求建立满足三个范式的数据库表 3)学习 INSERT, DELETE, UPDATE SELECT等几中常用的SQL命令及用法 实验任务 安装 MySQL数据库,并且按照需求建立数据库表,使用SQL语句进行表 内容的增、删、修改和查询 实验环境 操作系统: Windows xp或以上 ●数据库: MySQL Community Server5.0或以上 实验检查 将所有sq1语句导出到txt文件并且上传到10.132.141.33用户名:学号密 码java 实验步骤
Lab 7 MySQL安装以及简单数据库操作 实验目的 1）学习在 windows 环境中安装 MySql 数据库 2）根据需求建立满足三个范式的数据库表 3）学习INSERT,DELETE,UPDATE,SELECT等几中常用的SQL命令及用法 实验任务 安装 MySQL 数据库，并且按照需求建立数据库表，使用 SQL 语句进行表 内容的增、删、修改 和查询 实验环境 z 操作系统：Windows xp 或以上 z 数据库：MySQL Community Server5.0 或以上 实验检查 将所有 sql 语句导出到 txt 文件并且上传到 10.132.141.33 用户名：学号 密 码 java 实验步骤
1试验工具的安装 1) MySQL的安装及配置,从ftp:/ classes/07/072Web应用基础 Il/ software上下载相应的安装文件,按照如下步骤安装 MySQL数据库 2)点击NEXT按钮 I MySQL Server 5.0-Setup Wizard Welcome to the Setup Wizard for MySQL Server 5.0 The Setup Wizard will install MySQL Server 5.0 release 5.0.51a on your computer. To continue, cick Next. WARNING: This program is protected by copyright law. MuSG 匚N=x>]_cc 3)选择安装类型为“ Typical”,点击“Next”按钮
1 试验工具的安装 1) MySQL 的安装及配置，从 ftp:/classes/07/072 Web 应 用 基 础 II//software 上下载相应的安装文件，按照如下步骤安装 MySQL 数据库 2)点击 NEXT 按钮 3) 选择安装类型为“Typical”，点击“Next”按钮
iu MySQL Server 5.0-Setup Wizard Setup Type Choose the setup type that best suits your needs Please select a setup type Common program features will be installed. Recommended for C Complete All program features will be installed. Requires the most disk Custom Choose which program features you want installed and where they vill be installed. Recommended for advanced users <Back Cancel 4)点击“ Instal”按钮进行安装 Ii MySQL Server 5.0-Setup wizard Ready to Install the Program The wizard is ready to begin installation. If you want to review or change any of your installation settings, dick Back. Click Cancel to exit the wizard Current settings: Setup Type Ty Destination Folder C: Program Files MysQL MySQL Server 5.0\ < Back Cancel
4) 点击“Install”按钮进行安装
5)点击几次“Nex”按钮后,到类似下图的步骤,选中“ Configure the MySQL Server now”,然后点击“ Finish”,按钮进行 MySQL的配置 ie MySQL Server 5.0-Setup Wizard Wizard Completed Setup has finished installing MysQL Server 5.0. Click Finish to v Configure the MySQL Serve Use this option to generate an optimized MySQL config file, setup a windows service running on a dedicated port and to set the password for the root account. ySQ 6)选择“ Detailed Configuration”,点击“Next”按钮
5) 点击几次“Next”按钮后，到类似下图的步骤，选中“Configure the MySQL Server now”，然后点击“Finish”，按钮进行 MySQL 的配置 6) 选择“Detailed Configuration”，点击“Next”按钮
MySQL Server Instance Configuration Wizard My SQL Server Instance Configuration Configure the MysQL Server 5.0 server instance. Please select a configuration type a Detailed Configuration C Standard Configuration Use this only on machines that do not already have a MySQL server installation. This will use a general purpose configuration for the server that can be tuned manually <B」Nx>cace 7)由于我们安装 MySQL是为了做实验和项目,所以选择“ Developer Machine”,点击“Next”按钮 MYSQL Server Instance Configuration Wizard MySQL Server Instance Configuration Configure the MySQL Server 5.0 server instance Please select a server type. This will influence memory, disk and CPU usage C Developer Machine This is a development machine, and many other applications will be un on it. MySQL Server should only use a minimal amount of emory C Server Machine Several server applications will be running on this machine. Choose this option for web/application servers. MySQL will have medium C Dedicated My SQL Server Machine This machine is dedicated to run the MySQL Database Server. No other servers, such as a web or mail server, will be run, MySQL will utilize up to all available memory <Bs□Nx
7) 由于我们安装 MySQL 是为了做实验和项目，所以选择“Developer Machine”，点击“Next”按钮