Install the unpacked version of MARIADB

Today tried to install the decompression version of the MARIADB, on the official web https://downloads.mariadb.org/downloaded the 5.5 version of the mariadb Zip package,

After practice found that the MARIADB decompression version of the installation and MySQL version of the install is basically the same.

1. First unpack the installation package, create the My.ini file in the bin directory, the file content is:

= 11111Port=3306socket=/tmp/mysql.sockdefault-character-set=utf-8# The MariaDB server#[mysqlid]port=3306socket=/tmp/mysql.sockdefault-character-set= Utf-8

2. Next configure the MARIADB environment variable so that you can access the MARIADB in any directory on the command line, locate the environment variable path, and add the address of the bin directory under MySQL.

3. Open the command line with administrator privileges bymysqld --install-manual "服务名" 命令安装windows服务，其中服务名是自己定义的；如果想要卸载服务，则使用：

Mysqld--remove.

4. Start the service, reopen the command line, enter the MySQL return, found to log in to MySQL, using Mysql-uroot can log in, indicating that the root user does not set a password,

Use the command mysqladmin-u root password "New password", if you want to change the password, then use mysqladmin-u root-p old password password "new password",

This way, the MARIADB can be used normally.

Attention:

(1). If the login password is incorrect, an error 1045 (28000) will appear: Access denied for user ' ODBC ' @ ' localhost ' (using Password:yes)

Error, you need to change the root login password:

Update user set Password=password ("MySQL") where user= ' root ';

flush privileges;.

(2). During the installation process, it is found that only MySQL can log in to the database, because there is a user named "" in the database, need to use the command after logging into the database

Delete from Mysql.user where user= ""; Delete it.

Install the unpacked version of MARIADB