1. Copy the installation file to the server
< /p>
2. Unzip to the specified directory and create my.ini:
3. Edit the content of the my.ini file
[client]
port=3307
[mysql]
default-character-set=utf8
[mysqld]
port=3307
#Program installation directory
basedir=E:/mariadb-10.4.7
#DB storage path
datadir=E:/mariadb-10.4.7/data/
character-set-server=utf8
4. Command green path replacement for command creation service
sc create “MariaDb” binpath= “\”E:/mariadb-10.4.7/bin/mysqld\” \”–defaults-file=E:/mariadb-10.4.7/my.ini\” MariaDb” DisplayName= “MariaDb” start= “auto”
5. Execute Initialization: file under bin, execute:
6. Start the service
7. cmd to bin and execute mysql -u root -p password (if any)
Change user password:
-
GRANT ALL PRIVILEGES ON *.* TO ‘root’@‘%’ IDENTIFIED BY ‘123456’ WITH GRANT OPTION;
-
FLUSH PRIVILEGES;
[client]
port=3307
[mysql]
default-character-set=utf8
[mysqld]
port=3307
#Program installation directory
basedir=E:/mariadb-10.4.7
#DB storage path
datadir=E:/mariadb-10.4.7/data/
character-set-server=utf8
GRANT ALL PRIVILEGES ON *.* TO ‘root’@ ‘%’ IDENTIFIED BY ‘123456’ WITH GRANT OPTION; span>
GRANT ALL PRIVILEGES ON *.* TO ‘ root’@‘%’ IDENTIFIED BY ‘123456 ‘WITH GRANT OPTION;< /span>
FLUSH PRIVILEGES;
FLUSH PRIVILEGES;