Mariadb database installation process, mariadb database Process

Mariadb database installation process, mariadb database Process

As we all know, after Oracle acquired MySQL, there is a potential risk of shutting down the source of MySQL. MariaDB aims to be fully compatible with MySQL, including APIs and command lines, it can easily become a substitute for MySQL. MariaDB name is the name of MariaDB, daughter of Michael verius.

1. first download mariadb from the official website. Here I download MariaDB 10.2 Series. ZIP stable version (the time is 2017.11 months) 2. first decompress the zip file, and then find my-large, my-medium, my-small, three files, and then choose according to your own needs, copy a copy of The my-large.ini, rename the copy to my. ini, open my. modify ini as follows:

3. Then cd to the bin directory of mariadb and execute

Mysqld.exe -- install mariadb // install mariadb service mysqld -- initialize // initialize datanet start mariadb // start the service

Then, when starting the service, you may encounter "system error 1067". Find "host name. err" in the path/data directory after extracting the package from MariaDB to find the cause.

4. after the problem is solved, cd goes to the mariadb/bin directory, log on to mariadb, and then execute "set password for 'root' @ 'localhost' = PASSWORD ('new password ');", you can change the account password. 5. show variables like 'character % '; // view character sets

Possible problems: Access denied for user 'root' @ 'localhost' (using password: YES ).

The root account does not have the remote access permission by default, so you need to modify the relevant permissions.

Solution:

Open the my. ini file in the MySQL directory, add "skip-grant-tables" at the end of the file, and save and close the file. (My. ini is installed by default in WIN7 at C: \ ProgramData \ MySQL Server 5.6)

Restart the MySQL service.

Enter the MySQL BIN directory through the command line, enter "mysql-u root-p" (no password), and press enter to enter the database. (Windows 7 is installed by default. The BIN directory is C: \ Program Files \ MySQL Server 5.6 \ bin)

Run "use mysql;" to use the mysql database.

Run "update user set password = PASSWORD (" 123456 ") where user = 'root';" (modify the root password)

Open the my. ini file in the MySQL directory, delete "skip-grant-tables" in the last line, and save and close the file.

Restart the MySQL service.

Enter "mysql-u root-p 123456" in the command line to connect to the database.

After completing the preceding steps, MyEclipse can connect to MySQL.

Others' articles: Access denied for user 'root' @ 'localhost' (using password: YES)