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?
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.
