Use MySQL for the first time

The notes here are for the first time the people who use MySQL can get started quickly ... are very basic instructions. My environment is MySQL server installed on Ubuntu, client side on Windows 7, the most popular client software is Toad for MySQL, if there is no special reason, download this software to use it!

Take a look at how the installation is used ...

• Installation Server

On Ubuntu, you don't need to download MySQL, just follow the instructions below, and it will download and install it from the website!

sudo Install Mysql-server

The installation process will require you to enter the root password twice, just like this ... It's a simple finish!

Under normal circumstances, the client and server will not be on the same machine, however, MySQL presets to manage server only on the machine, in order to use the Toad installed on Windows can be connected to the server, to modify the settings, as root, to open/etc/m YSQL/MY.CNF, and find bind-address This setting, change it to the following:

0.0. 0.0

This means that it is allowed to be managed from any IP connection to the server!

Next, create a user on top and set up the repository to use, and set the permissions to user so that it can use the repository.

Mysql-u root-p
Enter Password:

After you enter the command on the terminal, enter the root code, enter the management mode, and then enter the following instructions to create the repository.

CREATE DATABASE db_name;

Next, to create a user, and grant this user can use the repository that was just created.

' Steven '@'localhost'mypassword';

As above, establish a user named Steven, whose password is MyPassword, and grant the rights to use the repository as follows.

' Steven '@'localhost'mypassword';

• Client Connect

Toad's installation is very simple, not much to explain, install the next click on the "file > New > connection", open the following screen, enter the Host, User, Password and Database, press "Connect" to connect Server (MySQL preset port is 3306).

Use MySQL for the first time