![]() ![]() The inserted record will appear in the list. Click on the 'Go' button to send the request. So far we haven't inserted any so there's only an info message. It's time to add some content.Ĭlick on the client table in the list. Now there are table names listed under vertabelo_mysql_example. Click on vertabelo_mysql_example and select the 'Import' tab to continue.Ĭhoose the file downloaded from Vertabelo and click 'Go' to start the import. In that database – nothing appears under the database name when you click on the plus sign. Note that only vertabelo_mysql_example database is visible. Alternatively, you could choose only some of the privileges from the lists in the last group. The last option should be checked since we want the user to have full control over the database. Please take a look at the 'Database for user' group. We don't want anyone to connect remotely, right? This means that the user will be able to log in only from the local machine. Now navigate to the privilege management page by clicking on the 'Check privileges' link next to the database name.Įnter the login and password for a new user (please note you can also generate a password using the button at the end of the group).Ĭhoose 'Local' from dropdown labeled 'Host'. A success message should appear as well as the vertabelo_mysql_example in the databases list. Now go to the 'Databases' tab and enter vertabelo_mysql_example in text field under 'Create database'.Ĭlick the 'Create' button. Open phpMyAdmin in your browser and login using root credentials. Option 1: Setup the database in phpMyAdmin Create the database and a user on MySQL server Now you can click on the 'Download' button to grab a copy or 'Save' to save this file within your account. Now press Ctrl+G (or Cmd+G) or click on the 'Generate SQL Script' icon in the top bar to show the options dialog:Ĭlick on the 'Generate' button to prepare SQL output. If you don't see it you may need to scroll down a bit. 'Additional SQL scripts' allows you to add extra SQL code to be executed at the beginning and the end of the file. Please take a look at the right-hand 'Model Properties' panel: in the 'SQL generation settings' tab you can turn on comments generation. Since your project is finished, you can now export the database structure. You can continue with the current project as well. (A detailed description is beyond the scope of this article). In this step you can edit the project using options from the left panel and the toolbox visible in the main area. Now proceed to the editor by clicking the 'Start modeling' button. ![]() For this tutorial, let's use the 'Example'. You can create an empty model, import SQL code, Vertabelo XML or use an example project. The model creation form will appear.Įnter the model name and set the database engine (in this article, we use MySQL 5.5). The first step is to click the 'Create new model' button and then pick 'Physical data model'. Please make sure you have a MySQL server as well as MySQL CLI installed on your machine. This article is divided in two sections – the first one shows how to generate SQL code and the second covers interaction with MySQL through phpMyAdmin or Linux terminal. ![]() In this tutorial we will show you step-by-step how to prepare a working MySQL DB based on a Vertabelo project. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |