如何在IBM Worklight中设置MySQL [英] How to set up MySQL in IBM Worklight

问题描述

我刚学会了IBM Worklight，我想知道如何设置和配置MySQL数据库。我已经设置了Worklight Adapter，但是，我不知道如何使用MySQL创建数据库。

I just have learned about IBM Worklight, and I was wondering of how to set up and configure MySQL database. I've set Worklight Adapter, but, I have no clue of how to make database with MySQL.

推荐答案

你应该通过 IBM Worklight入门培训材料，以便您熟悉IBM Worklight。

You should go through the IBM Worklight Getting Started training materials to properly familiarize yourself with IBM Worklight.

使Worklight项目与MySQL协同工作的步骤如下：

The steps to make a Worklight project work in conjunction with MySQL are as follows.

数据库：

1. 下载并安装MySQL（v5.1或v5.5）


2. 下载MySQL Connector / J驱动程序并暂时保留在侧面


3. 下载并安装一些软件以与其连接。我推荐SQLYog的社区版。


4. 使用SQLyog，创建一个新的数据库Worklight


5. 使用SQLyog，创建一个新用户Worklight （密码Worklight）

1. Download and install MySQL (v5.1 or v5.5)
2. Download the MySQL Connector/J driver and keep it at the side for now
3. Download and install some software to interface with it. I recommend the Community edition of SQLYog.
4. Using SQLyog, create a new Database "Worklight"
5. Using SQLyog, create a new user "Worklight" (password "Worklight")

工作灯：

1. 下载Eclipse Java EE 4.2.2（JunoSR2）


2. 安装Worklight Studio（IBM Worklight Developer Edition Eclipse插件。您可以通过Eclipse搜索>>销售>>市场>>worklight）


3. 创建新项目


4. 在项目中，放置连接器yourProject\server \lib中的/ J驱动程序


5. 在项目中，打开位于yourProject \ server\conf的worklight.properties文件并搜索mysql。取消注释以下属性。还可以使用上面的数据库，用户名和密码值编辑它们：

1. Download Eclipse Java EE 4.2.2 ("Juno" SR2)
2. Install Worklight Studio (the IBM Worklight Developer Edition Eclipse plug-in. You can search for it via Eclipse >> Help >> Marketplace >> "worklight")
3. Create a new project
4. In your project, place the Connector/J driver in yourProject\server\lib
5. In your project, open the worklight.properties file located at yourProject\server\conf and search for "mysql". Uncomment the following properties. Also edit them with the database, username and password values from above:

wl.db.type = MYSQL

wl.db.url = jdbc：mysql：// localhost：3306 / Worklight

wl.db.username = Worklight

wl.db. password = Worklight

wl.db.type=MYSQL
wl.db.url=jdbc:mysql://localhost:3306/Worklight
wl.db.username=Worklight
wl.db.password=Worklight

如果您现在右键单击项目并选择启动Worklight Server，服务器应该成功启动;如果没有，你做错了什么。 ：）

If you now right-click the projcet and choose "Start Worklight Server", the server should launch successfully; if not, you did something wrong. :)

如果以上情况适合您，您现在可以按照 MySQL适配器培训模块 - 按照步骤操作，并确保还使用页面中请求的数据库属性配置适配器XML 8。

If the above works for you, you can now follow the MySQL adapter training module - follow the steps, and make sure to also configure the adapter XML with the database properties as requested in page 8.

这篇关于如何在IBM Worklight中设置MySQL的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！