Register Login





|

Top Links: >> 80. Technology >> Internet Technology Summit Program >> 2. Java and Databases
Current Topic: 2.7. MySql Database
Sub-Topics: 2.7.1. MySQL Problem and Solution | 2.7.1. MySQL and MS SQL (Microsoft DB) Comparison
-- Scroll to check for more content below...
You have a privilege to create a quiz (QnA) related to this subject and obtain creativity score...
MySQL is the most popular open source database. With its proven performance, reliability and ease-of-use, MySQL has become the leading database choice for web-based applications, used by high profile organizations, including Facebook, Twitter, YouTube, Yahoo! and many more.

Since Oracle acquired MySql, it keeps it free with most features available in the Community Edition. Oracle delivers new capabilities to power next generation web, cloud, mobile and embedded applications.

Web applications allow many users simultaneously access data. This capability is supported by the connection pool in MySQL.

ITU uses MySQL internally to increase availability and reliability of our web applications.

Assignments
Check these links:MySQL is the most popular open-source database. With its proven performance, reliability, and ease of use, MySQL has become the leading database choice for web-based applications, used by high-profile organizations, including Facebook, Twitter, YouTube, Yahoo!, and many more.

Since Oracle acquired MySql, it keeps it free with most features available in the Community Edition. Oracle delivers new capabilities to power next-generation web, cloud, mobile, and embedded applications.

Web applications allow many users simultaneously access data.
This capability is supported by the connection pool in MySQL.

Create a user
mysql -u root -p
(Enter root password)

(Provide the username and the password for this new user.)
mysql> CREATE USER 'username'@'localhost' IDENTIFIED BY 'password';

Grant ALL permissions to a new user for all databases
mysql> GRANT ALL PRIVILEGES ON *.* TO 'sammy'@'localhost' WITH GRANT OPTION;
(To make it safe, it is better to GRANT specific privileges to a specific database.)

Copy MySql Database from one server to another.

In the sample below the user "root" will save DB "store" in the store.sql file by running the command below in the shell / cmd window. MySql will ask for a password.
>mysqldump -u root -p store > store.sql
Was it clear so far? Highlight the text in question Or


Then copy this file, for example with the Bitvise, to another server.
In the other server in the shell / cmd window run the following command to create this database in another server.
>mysql -u root -p store < store.sql

Copy MySql table from one server to another.

In the sample below the user "root" will save the table "product" in the DB "store" in the product.sql file by running the command below in the shell / cmd window. MySql will ask for a password.
>mysqldump -u root -p store product > store.sql

Then copy this file, for example with the Bitvise, to another server.
On the other server in the shell / cmd window run the following command to create this table in the database "store" in another server.
>mysql -u root -p store < product.sql


ITU uses MySQL internally to increase the availability and reliability of our web applications.

Assignments
Check these links:
Setting MySQL in AWS cloud
Universal Connection Pool (UCP) for JDBC
Configure the C3P0 connection pool in Hibernate
Apache Tomcat8 JDBC Connection Pool
Add more links and descriptions of the features that you find especially useful and post here (if you have privileges) or email to dean@ituniversity.us

Setting MySQL in AWS cloud
Universal Connection Pool (UCP) for JDBC
Configure the C3P0 connection pool in Hibernate
Apache Tomcat8 JDBC Connection Pool
Add more links and descriptions of the features that you find especially useful and post here (if you have privileges) or email to dean@ituniversity.us

We invite you to create your own questions and answers (QnA) to increase your rank and win the Top Creativity Prize!

Topic Graph | Check Your Progress | Propose QnA | Have a question or comments for open discussion?

Have a suggestion? - shoot an email
Looking for something special? - Talk to AI
Read: IT of the future: AI and Semantic Cloud Architecture | Fixing Education
Do you want to move from theory to practice and become a magician? Learn and work with us at Internet Technology University (ITU) - JavaSchool.com.

Technology that we offer and How this works: English | Spanish | Russian | French

Internet Technology University | JavaSchool.com | Copyrights © Since 1997 | All Rights Reserved
Patents: US10956676, US7032006, US7774751, US7966093, US8051026, US8863234
Including conversational semantic decision support systems (CSDS) and bringing us closer to The message from 2040
Privacy Policy