MySQL database Quick Start

MySQL, as an open-source and lightweight database product, is really good. It is the first choice for making open-source, demonstration, and even small business projects.

I personally think that its biggest characteristic is "lightweight", "simple", "quick", and of course free :-) so this is the goal of this article.

What's default username and password with MySQL?

Default User:Root

Default password:Manager

How to install a service? For an example.

Mysql_home/bin/mysqld.exe-install

Service successfully installed.

How to remove a service? For an example.

Mysql_home/bin/mysqld.exe-Remove

Service successfully removed.

How to Write a bat script for startup MySQL, Tomcat and Internet Explorer? For an example.

Del % SystemRoot %/My. ini
@ Echo off
Start mysql_home/bin/mysqld -- Port = 3308 -- default-character-set = GBK
CD tomcat_home/bin/
Call startup. bat
CD ../../
Explorer http: // 127.0.0.1: 8080/yourapp

How to Write a bat script for shutdown MySQL and tomcat? For an example.

Mysql_home/bin/mysqladmin -- Port = 3308 Shutdown
CD tomcat_home/bin/
Call shutdown. bat
CD ../../

Some useful client tools for MySQL.

MySQL Administrator

MySQL query Browser