"Vmcloud Cloud Platform" Private cloud Portal the first MySQL cloud

complete the WAP VM Cloud, Web Cloud, MSSQL after that we can toss down the database cloud, Azure support for a wide variety of databases, where MySQL and MSSQL support the best, this article to introduce how to build MSSQL Cloud..

This article deals with servers such as (purple is completed, red is in progress, Blue is planned)

650) this.width=650; "title=" clip_image002[6] "style=" border-right-width:0px;background-image:none; border-bottom-width:0px;float:none;padding-top:0px;padding-left:0px;margin-left:auto;padding-right:0px; Border-top-width:0px;margin-right:auto; "border=" 0 "alt=" clip_image002[6] "src=" http://s3.51cto.com/wyfs02/M01/78 /8b/wkiom1z_ormjbzojaacslbmyxy4572.jpg "width=" 558 "height=" 338 "/>

Azure Web Cloud area such as:

650) this.width=650; "title=" clip_image004[4] "style=" border-right-width:0px;background-image:none; border-bottom-width:0px;float:none;padding-top:0px;padding-left:0px;margin-left:auto;padding-right:0px; Border-top-width:0px;margin-right:auto; "border=" 0 "alt=" clip_image004[4] "src=" http://s3.51cto.com/wyfs02/M01/78 /89/wkiol1z_otldifsoaabsqhyeemi767.jpg "width=" 558 "height=" 234 "/>

1, login WAP01, we will install the primary Management Server MySQL, in the Web platform installation program, search MySQL Windows 5.1:

650) this.width=650; "title=" clip_image006[4] "style=" border-right-width:0px;background-image:none; border-bottom-width:0px;padding-top:0px;padding-left:0px;margin:0px;padding-right:0px;border-top-width:0px; " Border= "0" alt= "clip_image006[4" "src=" http://s3.51cto.com/wyfs02/M02/78/89/wKioL1Z_oTPBQ-kMAAC0Vox6VQY863.jpg " Width= "558" height= "382"/>

2. In the search results, click Add next to MySQL Windows 5.1, and then click Install. In the Prerequisites window, enter the password for the default database administrator account (root). Type the password again to confirm, and then click Continue.

650) this.width=650; "title=" clip_image008[4] "style=" border-right-width:0px;background-image:none; border-bottom-width:0px;padding-top:0px;padding-left:0px;margin:0px;padding-right:0px;border-top-width:0px; " Border= "0" alt= "clip_image008[4" "src=" http://s3.51cto.com/wyfs02/M00/78/89/wKioL1Z_oTTiUhfPAAB0i9DrgCI489.jpg " Width= "558" height= "356"/>

3. Review the list of software that you want to install, and then click I Accept. MySQL will be downloaded and installed. Click Finish to close the installation window.

650) this.width=650; "title=" clip_image010[4] "style=" border-right-width:0px;background-image:none; border-bottom-width:0px;padding-top:0px;padding-left:0px;margin:0px;padding-right:0px;border-top-width:0px; " Border= "0" alt= "clip_image010[4" "src=" http://s3.51cto.com/wyfs02/M01/78/89/wKioL1Z_oTXRxI-XAABcYDBZgek688.jpg " Width= "558" height= "356"/>

4. In the WAP01 Administrator Management portal, click SQL Serverin the left navigation Pane.

650) this.width=650; "title=" clip_image012[4] "style=" border-right-width:0px;background-image:none; border-bottom-width:0px;padding-top:0px;padding-left:0px;margin:0px;padding-right:0px;border-top-width:0px; " Border= "0" alt= "clip_image012[4" "src=" http://s3.51cto.com/wyfs02/M02/78/89/wKioL1Z_oTbyrr63AAB9Vrz9Bm8571.jpg " Width= "558" height= "376"/>

5. In the Administrator management Portal, click MySQL Serverin the left navigation Pane.

650) this.width=650; "title=" clip_image014[4] "style=" border-right-width:0px;background-image:none; border-bottom-width:0px;padding-top:0px;padding-left:0px;margin:0px;padding-right:0px;border-top-width:0px; " Border= "0" alt= "clip_image014[4" "src=" http://s3.51cto.com/wyfs02/M02/78/8A/wKioL1Z_oTfDj3NZAAB2I7rkAT0135.jpg " Width= "557" height= "373"/>

6. Open MySQL Command line Client, enter GRANT all privileges on * * to ' root ' @ '% ' identified by ' [email protected] ' with GRAN T OPTION; , which indicates an authorized remote connection:

650) this.width=650; "title=" clip_image016[4] "style=" border-right-width:0px;background-image:none; border-bottom-width:0px;padding-top:0px;padding-left:0px;margin:0px;padding-right:0px;border-top-width:0px; " Border= "0" alt= "clip_image016[4" "src=" http://s3.51cto.com/wyfs02/M00/78/8B/wKiom1Z_oSDTBjHbAAC_fePu0Os235.jpg " Width= "558" height= "367"/>

7. At the bottom of the window, click New or add, and then click Connect to to add a new instance. Enter MySQL Server instance information: Group name, server name, administrator user name, administrator password, and size of the host server (GB).

650) this.width=650; "title=" clip_image018[4] "style=" border-right-width:0px;background-image:none; border-bottom-width:0px;padding-top:0px;padding-left:0px;margin:0px;padding-right:0px;border-top-width:0px; " Border= "0" alt= "clip_image018[4" "src=" http://s3.51cto.com/wyfs02/M00/78/8B/wKiom1Z_oSHijgf1AABpx8b-95Q506.jpg " Width= "558" height= "314"/>

8. Click "Connect". A message appears at the bottom of the window indicating whether the operation succeeded or failed. Click OK.

650) this.width=650; "title=" clip_image020[4] "style=" border-right-width:0px;background-image:none; border-bottom-width:0px;padding-top:0px;padding-left:0px;margin:0px;padding-right:0px;border-top-width:0px; " Border= "0" alt= "clip_image020[4" "src=" http://s3.51cto.com/wyfs02/M01/78/8B/wKiom1Z_oSKg5mS3AABx9UoeSLU843.jpg " Width= "558" height= "333"/>

9. After completion, similarly, we create a new plan to correspond to the MySQL cloud subscription:

650) this.width=650; "title=" clip_image022[4] "style=" border-right-width:0px;background-image:none; border-bottom-width:0px;padding-top:0px;padding-left:0px;margin:0px;padding-right:0px;border-top-width:0px; " Border= "0" alt= "clip_image022[4" "src=" http://s3.51cto.com/wyfs02/M02/78/8A/wKioL1Z_oTzQU_KVAAByROuJZWs651.jpg " Width= "558" height= "343"/>

10, assigned to the user:

650) this.width=650; "title=" clip_image023[4] "style=" border-right-width:0px;background-image:none; border-bottom-width:0px;padding-top:0px;padding-left:0px;margin:0px;padding-right:0px;border-top-width:0px; " Border= "0" alt= "clip_image023[4" "src=" Http://s3.51cto.com/wyfs02/M01/78/8A/wKioL1Z_oT3T59xIAABD9Mm_ZGg699.png " Width= "554" height= "380"/>

11, after using Clouduser login, try to create a MySQL database, create a success:

650) this.width=650; "title=" clip_image025[4] "style=" border-right-width:0px;background-image:none; border-bottom-width:0px;padding-top:0px;padding-left:0px;margin:0px;padding-right:0px;border-top-width:0px; " Border= "0" alt= "clip_image025[4" "src=" http://s3.51cto.com/wyfs02/M00/78/8B/wKiom1Z_oSjRdzLGAABOeBRNi9c653.jpg " Width= "557" height= "327"/>

650) this.width=650; "title=" clip_image027[4] "style=" border-right-width:0px;background-image:none; border-bottom-width:0px;padding-top:0px;padding-left:0px;margin:0px;padding-right:0px;border-top-width:0px; " Border= "0" alt= "clip_image027[4" "src=" http://s3.51cto.com/wyfs02/M02/78/8B/wKiom1Z_oS3RcNcmAABvtREW1y0987.jpg " Width= "557" height= "336"/>

12. Click on the management information to see the connection string:

650) this.width=650; "title=" clip_image029[4] "style=" border-right-width:0px;background-image:none; border-bottom-width:0px;padding-top:0px;padding-left:0px;margin:0px;padding-right:0px;border-top-width:0px; " Border= "0" alt= "clip_image029[4" "src=" http://s3.51cto.com/wyfs02/M02/78/8A/wKioL1Z_oUailJxzAABSTxYDi6s362.jpg " Width= "558" height= "414"/>

13. Switch to WAP01 and open MySQL Command line client to see that Test01 is actually created in the database:

650) this.width=650; "title=" clip_image031[4] "style=" border-right-width:0px;background-image:none; border-bottom-width:0px;padding-top:0px;padding-left:0px;padding-right:0px;border-top-width:0px; "border=" 0 "alt = "Clip_image031[4]" src= "http://s3.51cto.com/wyfs02/M02/78/8A/wKioL1Z_oUfS6L2QAABd9jIb8Dw317.jpg" width= "558" height= "213"/>

14. The database login name you entered also appears in security.

650) this.width=650; "title=" article suffix "style=" border-right-width:0px;background-image:none;border-bottom-width:0px; float:none;padding-top:0px;padding-left:0px;margin-left:auto;padding-right:0px;border-top-width:0px; Margin-right:auto; "border=" 0 "alt=" article suffix "src=" http://s3.51cto.com/wyfs02/M00/78/8A/wKioL1Z_ Ouixttieaadvpc6tcse166.png "width=" 533 "height=" 347 "/>

This article from "Vmcloud" blog, declined reprint!

"Vmcloud Cloud Platform" Private cloud Portal the first MySQL cloud