MySQL Installation and uninstallation

1.1 Previous lesson Content review:

MVC case:

* Servlet

* Processing requests.

* JSP

* Show Data

* Jstl+el display data.

* JavaBean

* Package and process data

* Beanutils package data.

* XML

* Store data.

* Analytic xml:dom4j

What is MVC:

MVC software Development of a design idea, the software layered operation.

The process of development:

Each request is submitted to the controller, which processes the request and encapsulates the submitted data to the model layer to process the data. The results of the processing are displayed on the JSP.

1.2 MySQL Database 1.2.1 What is a database

Database: is a file system. Manipulate data with standard SQL.

Relational databases: The relationships between entities are preserved! The relational data model is saved.

Common relational databases:

Oracle:oracle (Oracle) develops a large database of fees. Oracle acquires Sun, Mysql

SQL Server: Microsoft Corporation developed a fee-medium database.

DB2:IBM a large database of fees developed by the company. WebSphere

MYSQL: Open source free small database.

SQLite: Small database, embedded database.

Developed by the Sybase:sybase company. PowerDesigner. (Data modeling tools.)

...

Frequently used databases in Java EE development: MySQL, oracle!

1.2.2 Using the database: Installing MySQL:

1. Select when installing: Typical, custom, complete.

* Custom Installation: Remember two paths

* C:\Program Files\mysql\mysql Server 5.5\

* C:\Documents and Settings\All Users\Application Data\mysql\mysql Server 5.5\

2.MySQL Default port number:

3. Modifying the MySQL character set

4.Include Bin directory in Windows path: The front tick needs to be checked.

5. Enter the password for the top root administrator:

6. Execution: The following four are all hooks. Then the installation is successful. If there is a place where an error occurs. Uninstall REINSTALL!!!

7. Test whether the installation was successful:

Cmd>mysql-u Root-p Enter

Enter password

To uninstall MySQL:

1. Open the My.ini file:

Basedir= "C:/Program files/mysql/mysql Server 5.5/"

Datadir= "C:/Documents and Settings/all users/application data/mysql/mysql Server 5.5/data/"

2. Uninstall MySQL in the Control Panel.

3. Delete all the files under the Basedir and datadir paths.

4. Reinstall

Reset Root Password:

1. Stop the MySQL service.

* Run window: services.msc

* Find the MySQL service and stop.

2.cmd>mysqld--skip-grant-tables

* Open a new MySQL service, can skip permission authentication.

3. Reopen a new CMD window:

* Cmd>mysql-u Root-p

* You do not need to enter a password to connect.

4.use MySQL

5.update user Set Password=password (' 123 ') where user= ' root ';

6. Close the two CMD window

7. End a process in Task Manager. MYSQLD process.

8. Restart the MySQL service.

MySQL Installation and uninstallation