Today, we need to install a database named MariaDB in windows because of our work. I am not familiar with this database, So Baidu has found two methods. Let's share the following.
Method 1: It looks simple, but it is not installed successfully.
1. Download MariaDB from the official website
Address: https://downloads.mariadb.org/
Ii. Installation
1. decompress the package.
2. unzip the directory to see the my-huge.ini, my-innodb-heavy-4G.ini, my-large.ini, my-medium.ini, my-small.ini 5 files, according to the size of the sub-memory select one of them COPY to C: Windows directory, and modify the name to my. ini.
3. Open my. ini and add
[WinMySQLAdmin]
Server = D:/dev/mariadb/bin/mysqld.exe
User = root
Password = mariadb
[Mysqld]
Basedir = decompressed path
Datadir = decompressed path/data
3. add and delete a service
1. CMD, switch to MariaDB, decompress the package, and run "mysqld -- install yourservicename ".
2. CMD, SC deleteyourservicename.
Iv. System Error 1076
When the service is started, "system error 1076" is displayed. Find "host name. err" in the path/data directory after MariaDB unzipping, and then find the cause.
5. Modify the ROOT password
CMD, switch to MariaDB, decompress the package, and run "mysql-uroot-p" to switch to MariaDB mode, run "set password for 'root' @ 'localhost' = PASSWORD ('new password.
Method 2: Detailed installation method with images
Note:
MariaDB is an open-source MySQL-based database that is compatible with MySQL. The existing MySQL database can be migrated to MariaDB for use.
Download MariaDB:
32-bit: http://mirrors.hustunique.com/mariadb/mariadb-5.5.33a/win32-packages/mariadb-5.5.33a-win32.msi
64-bit: http://mirrors.scie.in/mariadb/mariadb-5.5.33a/winx64-packages/mariadb-5.5.33a-winx64.msi
Operating System:32-bit Windows Server 2003
MariaDB version:Mariadb-5.5.33a (latest stable version)
Install MariaDB
Open the mariadb-5.5.33a-win32.msi installation file, as shown in
Next
Check I accept the terms in the License Agreement
Accept the terms in the license agreement
Next
Select to install all components
Click Browse... to Browse and modify the MariaDB installation directory.
Modify it to C: MariaDB 5.5
Next
Check Modify password for database user "root"
Set the root password of the MariaDB database account
Enable access from remote machines
Prohibit remote access to the MariaDB database. You can only connect to MariaDB locally
The Create An Anonymous Account option is deselected by default.
Prohibit new anonymous users from accessing MariaDB
Check Use UTF8 as default server's charater set
MariaDB uses UTF-8 encoding by default.
Next
Select Install as service to Install the service
Service Name: MySQL
The default service name of the MariaDB database is MySQL.
Enable networking
TCP port: 3306
MariaDB uses TCP port 3306 by default.
Optimize for transactions is selected by default.
Buffer pool size: 1022
The default cache is 12.5% of the memory size, and the 32-bit MariaDB has a maximum cache capacity of 1 GB.
Uncheck Enable the Feedback plugin and submit amonymous usage information
Disable feedback and submit usage information
Next
Install
Installing
Finish Installation
MariaDB 5.5 is displayed in the Start Menu.
As shown in
Open MySQL Client (MariaDB 5.5) and enter the root password set above to log on, as shown in
Open HeidiSQL, as shown in
Click Add, as shown in
Enter the root user password and click open, as shown in. The MariaDB Management page is displayed.
Open the MariaDB installation directory C: MariaDB 5.5 and you can see that the directory structure is consistent with that of MySQL!
Now, MariaDB is installed in Windows!