![]() In case you are interested to see MySQL in action, Post Spring 4 MVC + Hibernate4 + MySQL + Maven integration example using annotations contains a real-world example of a Spring MVC based web application, connecting to MySQL using Hibernate. You may do everything we discussed above using mysql command line option instead of workbench. Port mentioned in URL is the default port used but you can change it using workbench. User/password : myuser/mypassword as defined in step 4. URL : jdbc:mysql://localhost:3306/mydatabase In order to operate it on your computer smoothly, you need to enable USB debugging on your phone, and you can follow the steps on the picture below to finish this process. ![]() Then download, install and open this program on your computer. ![]() Step 5: Now you can access your database from your external applications using following url: Firstly, connect your ZTE mobile phone to computer via a USB cable. ![]() User, password mentioned here are the one your external application will use to connect to database. $> GRANT ALL PRIVILEGES ON mydatabase.* TO IDENTIFIED BY “mypassword” Step 4: Grant necessary privileges so that your user can access the tables/other artifacts from that database. You may decide to set it as Default schema by select schema->Right click->Set As Default Schema. Step 3: Once the schema created, it will be shown in Navigator pane on left. In MySQL, a schema is synonymous with a database.Ĭlick on highlighted link to create a schema, it will open a popup and guide you to create a Schema.Īlternatively, you can execute following SQL in SQL tab from above toolbar to create the database. Step 2: Once the installation done, You can create a new Schema/database.
0 Comments
Leave a Reply. |