Win7-free Installation mariadb

1. Download the mariadb version of Windows on the website

Address: https://downloads.mariadb.org/mariadb/10.0.17/

Currently the latest version is 10.0.17

2. Unzip and configure after the download is complete.

Note: The compressed folder is placed under the C packing directory. can also be placed in other directories.

3, the directory has three my INI file, according to the configuration of their own machine, select one (I choose the My-large.ini), and edit the content. Add the following content:

Add below [client]

Default_character_set=utf8

[Mysqld] Add below

BASEDIR=C:/MARIADB #Mariadb所在目录

Datadir=c:/mariadb/data #Mariadb所在目录

Character_set_server=utf8

Further increase

[Winmysqladmin]

Server=c:/mariadb/bin/mysqld.exe #Mariadb所在目录

If the maximum number of connections is required, add the following under [Mysqld]

# Maximum number of connections allowed
max_connections=200

When you're done, rename the file to My.ini and place it under Windows C.

4. Installation Services

Enter CMD as Administrator

Use the command to enter the bin directory under MARIADB.

Input mysqld Install ServiceName

ServiceName Service Name

Then, start it

net start MySQL

The application is started properly here.

If it does not start successfully, go to the Mariadb/data directory and have a. err file on your hostname to see where the error is, generally more obvious.

5. Change the root password

Or in the cmd window just now, enter MySQL into the MARIADB database

with show databases; command to see if there is a MySQL database. Normally the new installation is not, then exit exits.

Enter mysqladmin–u root–p password Mima Prompt Enter password, enter directly

Then log in as Mysql–u root–p and enter the password you just set Mima

and then show Databases; Look, there should be a database.

Execute the command update user set password = password (' Your password ') where user = ' root ';

Flush prvileges; The modification is complete.

6, using Navicat Premium connection mariadb

Ok. This is the end, the next step is to build the table development.

Win7-free Installation mariadb