Win7-free Installation mariadb

Source: Internet
Author: User

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

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.