WIN7+MARIADB Free installation version

1. Download Mariadb-10.0.15-winx64.zip website;

2. Unzip to D:/MARIADB;

3. Create a new My.ini file in the D:/MARIADB directory with the following contents:

[mysqld] 
basedir=d:\mariadb 
datadir= D:\MARIADB\DATA&NBSP
Character_set_server=utf8
# allow maximum number of connections
max_connections=200
Span style= "White-space:pre" > # The default storage engine that will be used when creating a new table
# Default-storage-engine=innodb error
#default-storage-engine=myisam
Span style= "White-space:pre" > port=3306 

federated# solution [Note] Plugin ' federated ' is disabled.
[Client]
port=3306
Default_character_set=utf8
#character_set_client =utf8 Error
[Winmysqladmin]
Server=d:\mariadb\bin\mysqld.exe

Encoding Format ansi! Otherwise it will error: ... 2003. No attention to content

4. Run the command line as an administrator; switch to D:/MARIADB

Running: mysqld Install MySQL--defaults-file=d:/mariadb/my.ini

Run: net start MySQL

Note: To this step, there should be no errors if not successful. Go to the D:/mariadb/data directory and have a. err file on your hostname to see where the error is. Generally more obvious. Can Google.

5. When the command enters MySQL, it enters the mariadb. But without MySQL database, launch database, execute mysqladmin-u root-p password Mima, next let input password, direct enter (default password is empty). Then log in Mysql-u root-p, enter the password you set Mima;

6. Then show databases; there is a MySQL database. Execute the following command: Update user set Password=password (' Mima ') where user= ' root '; flush privileges;

7. So far, mariadb.

WIN7+MARIADB Free installation version