Service Registration and password modification in MariaDB Green Edition windows

After more than an hour, I checked the summary on the Internet and successfully registered the MariaDB Green Edition Service and changed the password. I will share it with you. Please do not spray it. Mysqlmariamariadb1optimize and create Windows Service mysql_install_db.exe -- datadirD: mariadb-10.0.16-win32 -- serviceMySql -- passworddsidea

After more than an hour, I checked the summary on the Internet and successfully registered the MariaDB Green Edition Service and changed the password. I will share it with you. Please do not spray it. MySQL Maria MariaDB 1. initialize and create WINDOWS service mysql_install_db.exe -- datadir = D: \ mariadb-10.0.16-win32 -- service = MySql -- password = dsidea

After more than an hour, I checked the summary on the Internet and successfully registered the MariaDB Green Edition Service and changed the password. I will share it with you. Please do not spray it. MySQL Maria MariaDB

1. initialize and create the WINDOWS Service mysql_install_db.exe -- datadir = D: \ mariadb-10.0.16-win32 -- service = MySql -- password = dsideal, start service SC start MySql3, delete service SC stop MySql SC delete MySql rmdir/s/q D: \ mariadb-10.0.16-win324, modify the Default Login Password 1) Find my in the corresponding directory under windows. INI file, type skip-grant-tables to save. 2) restart the service. net stop MySql net start MySql. 3) log on to the database: mysql-uroot-p. If "Enter password:" is displayed, press Enter. 4) In the MariaDB database, you need to switch to the user: use mysql; 5) change the password: update user set PASSWORD = password ("newpass") where user = "root"; note: the password of the root user under localhost is changed here. In database management tools, enter localhost for database/IP. 6) Update permission: flush privileges; 7) Exit: quit; 8) modify my. INI file, remove the content skip-grant-tables and save it. 9) restart the service. net stop MySql net start MySql5. log on to the database: mysql-uroot-p Enter password: sy31214 use mysql to switch the user (myqql indicates the database that comes with it) select * from user; check whether debugging is correct