How to create Table in database

Question

Dear Team,

I am a student plan to use to run my project in DBaaS(Database as a Service). I created a Free account and created MySQL instance database. My question is , How I can create tables in that database ? Please advise ...

 

Thanks

Anes P.A

Answer 1

Hello Anes,

                There are two ways to create tables in your created service database.

1-  By clicking on Upload backup icon. You can upload backup and restore it directely on your created service, if you have database backup file.

2-  By clicking on Bind IP List icon. You can bind your created service providing  Source IP (IP of machine from where you want to access database). After that  click on Details icon and use the credentials ( Public IP, VM Port, User Name, Password, Databse Name) to connect the service  from your machine using your favorite client.  Now you can execute all the MySQL commands( create tables etc.).

Hope this will help you.

 

Thanks

Deo