Download MySQL Server as zip format from :
https://dev.mysql.com/downloads/mysql
https://downloads.mysql.com/archives/community
Example, I downloaded mysql-v5.7.44, mysql-v8.0.46, mysql-v8.4.10, mysql-v9.7.1
Orchestrated your mariadb with multiple port, example :
* mysql-v5.7.44 = 3421
* mysql-v8.0.46 = 3422
* mysql-v8.4.10 = 3423
* mysql-v9.7.1 = 3424
Example I extracted those files above into directory C:\Users\dell\programs\mysql-server
Now, let's begin installation process.
* MySQL-v5.7.44 (port 3421)
Create file mysql-p3421.sock in C:\Users\dell\programs\mysql-server\mysql-v5.7.44\tmp\mysql-p3421.sock
Create file my.ini in C:\Users\dell\programs\mysql-server\mysql-v5.7.44\my.ini and paste these configurations :
[client]
port = 3421
socket = "C:/Users/dell/programs/mysql-server/mysql-v5.7.44/tmp/mysql-p3421.sock"
default-character-set = ascii
[mysqld]
port = 3421
socket = "C:/Users/dell/programs/mysql-server/mysql-v5.7.44/tmp/mysql-p3421.sock"
basedir = "C:/Users/dell/programs/mysql-server/mysql-v5.7.44"
datadir = "C:/Users/dell/programs/mysql-server/mysql-v5.7.44/data"
character-set-server = ascii
collation-server = ascii_general_ci
default-storage-engine = InnoDB
max_connections = 100
back_log = 50
max_connect_errors = 10
table_open_cache = 2048
max_allowed_packet = 16M
binlog_cache_size = 1M
max_heap_table_size = 64M
sort_buffer_size = 8M
join_buffer_size = 8M
thread_cache_size = 8
query_cache_size = 64M
query_cache_limit = 2M
ft_min_word_len = 4
thread_stack = 256K
tmp_table_size = 64M
innodb_buffer_pool_size = 2G
innodb_data_file_path = ibdata1:10M:autoextend
innodb_log_buffer_size = 8M
innodb_log_file_size = 256M
innodb_log_files_in_group = 3
innodb_max_dirty_pages_pct = 90
innodb_lock_wait_timeout = 120
innodb_use_native_aio = 1
[mysqldump]
quick
max_allowed_packet = 16M
[mysql]
no-auto-rehash
[myisamchk]
key_buffer_size = 512M
sort_buffer_size = 512M
read_buffer = 8M
write_buffer = 8M
--- --- --- --- ---
Open command prompt and run as administrator
$ cd C:\Users\dell\programs\mysql-server\mysql-v5.7.44\bin
$ mysqld --defaults-file="C:\Users\dell\programs\mysql-server\mysql-v5.7.44\my.ini" --initialize-insecure
$ mysqld --install "MySQL_p3421_v5.7.44" --defaults-file="C:\Users\dell\programs\mysql-server\mysql-v5.7.44\my.ini"
$ net start "MySQL_p3421_v5.7.44"
$ mysql -u root -p (enter)
$ use mysql;
$ GRANT ALL ON *.* TO 'root'@'localhost' IDENTIFIED BY 'type_your_password' WITH GRANT OPTION;
$ FLUSH PRIVILEGES;
$ exit
$ mysql -u root -p (enter, then type your password, then enter again)
--------------------------------------------------
* MySQL-v8.0.46 (port 3422)
Create file mysql-p3422.sock in C:\Users\dell\programs\mysql-server\mysql-v8.0.46\tmp\mysql-p3422.sock
Create file my.ini in C:\Users\dell\programs\mysql-server\mysql-v8.0.46\my.ini and paste these configurations :
[client]
port = 3422
socket = "C:/Users/dell/programs/mysql-server/mysql-v8.0.46/mysql-p3422.sock"
default-character-set = ascii
[mysqld]
port = 3422
socket = "C:/Users/dell/programs/mysql-server/mysql-v8.0.46/mysql-p3422.sock"
basedir = "C:/Users/dell/programs/mysql-server/mysql-v8.0.46"
datadir = "C:/Users/dell/programs/mysql-server/mysql-v8.0.46/data"
character-set-server = ascii
collation-server = ascii_general_ci
max_connections = 100
back_log = 50
max_connect_errors = 10000
max_allowed_packet = 16M
binlog_cache_size = 1M
max_heap_table_size = 64M
tmp_table_size = 64M
sort_buffer_size = 8M
join_buffer_size = 8M
read_buffer_size = 2M
read_rnd_buffer_size = 16M
default-storage-engine = InnoDB
innodb_buffer_pool_size = 2G
innodb_buffer_pool_instances = 2
innodb_log_buffer_size = 8M
innodb_flush_log_at_trx_commit = 1
innodb_lock_wait_timeout = 50
innodb_thread_concurrency = 8
innodb_flush_method = unbuffered
innodb_redo_log_capacity = 512M
key_buffer_size = 32M
thread_cache_size = 8
--- --- --- --- ---
Open command prompt and run as administrator
$ cd C:\Users\dell\programs\mysql-server\mysql-v8.0.46\bin
$ mysqld --defaults-file="C:\Users\dell\programs\mysql-server\mysql-v8.0.46\my.ini" --initialize-insecure
$ mysqld --install "MySQL_p3422_v8.0.46" --defaults-file="C:\Users\dell\programs\mysql-server\mysql-v8.0.46\my.ini"
$ net start "MySQL_p3422_v8.0.46"
$ mysql -u root -p (enter)
$ use mysql;$ ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'type_your_password';$ ALTER USER 'root'@'localhost' IDENTIFIED BY 'type_your_password';
$ ALTER USER 'root'@'localhost' IDENTIFIED WITH caching_sha2_password BY 'type_your_password';
$ FLUSH PRIVILEGES;
$ exit
$ mysql -u root -p (enter, then type your password, then enter again)
--------------------------------------------------
* MySQL-v8.4.10 (port 3423)
Create file mysql-p3423.sock in C:\Users\dell\programs\mysql-server\mysql-v8.4.10\tmp\mysql-p3423.sock
Create file my.ini in C:\Users\dell\programs\mysql-server\mysql-v8.4.10\my.ini and paste these configurations :
[client]
port=3423
socket = "C:/Users/dell/programs/mysql-server/mysql-v8.4.10/mysql-p3423.sock"
default-character-set = ascii
[mysql]
default-character-set = ascii
[mysqld]
port=3423
socket = "C:/Users/dell/programs/mysql-server/mysql-v8.4.10/mysql-p3423.sock"
basedir="C:/Users/dell/programs/mysql-server/mysql-v8.4.10"
datadir="C:/Users/dell/programs/mysql-server/mysql-v8.4.10/data"
character-set-server = ascii
collation-server = ascii_general_ci
innodb_buffer_pool_size=2500M
innodb_buffer_pool_instances=2
innodb_redo_log_capacity=512M
innodb_log_buffer_size=16M
max_connections=500
thread_cache_size=50
table_open_cache=2000
tmp_table_size=64M
max_heap_table_size=64M
join_buffer_size=8M
sort_buffer_size=8M
read_buffer_size=2M
read_rnd_buffer_size=8M
innodb_flush_log_at_trx_commit=1
innodb_flush_method = unbuffered
log_error="mysql-err.log"
slow_query_log=1
slow_query_log_file="mysql-slow.log"
long_query_time=2
--- --- --- --- ---
Open command prompt and run as administrator
$ cd C:\Users\dell\programs\mysql-server\mysql-v8.4.10\bin
$ mysqld --defaults-file="C:\Users\dell\programs\mysql-server\mysql-v8.4.10\my.ini" --initialize-insecure
$ mysqld --install "MySQL_p3423_v8.4.10" --defaults-file="C:\Users\dell\programs\mysql-server\mysql-v8.4.10\my.ini"
$ net start "MySQL_p3423_v8.4.10"
$ mysql -u root -p (enter)
$ use mysql;$ ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'type_your_password';$ ALTER USER 'root'@'localhost' IDENTIFIED BY 'type_your_password';
$ ALTER USER 'root'@'localhost' IDENTIFIED WITH caching_sha2_password BY 'type_your_password';
$ FLUSH PRIVILEGES;
$ exit
$ mysql -u root -p (enter, then type your password, then enter again)
--------------------------------------------------
* MySQL-v9.7.1 (port 3424)
Create file mysql-p3424.sock in C:\Users\dell\programs\mysql-server\mysql-v9.7.1\tmp\mysql-p3424.sock
Create file my.ini in C:\Users\dell\programs\mysql-server\mysql-v9.7.1\my.ini and paste these configurations :
[client]
port = 3424
socket = "C:/Users/dell/programs/mysql-server/mysql-v9.7.1/mysql-p3424.sock"
default-character-set = ascii
[mysqld]
port = 3424
socket = "C:/Users/dell/programs/mysql-server/mysql-v9.7.1/mysql-p3424.sock"
basedir = "C:/Users/dell/programs/mysql-server/mysql-v9.7.1"
datadir = "C:/Users/dell/programs/mysql-server/mysql-v9.7.1/data"
log-error = "C:/Users/dell/programs/mysql-server/mysql-v9.7.1/mysql_error.log"
character-set-server = ascii
collation-server = ascii_general_ci
default-storage-engine = INNODB
innodb_buffer_pool_size = 2G
key_buffer_size = 32M
max_connections = 100
max_connect_errors = 10000
thread_cache_size = 10
sort_buffer_size = 2M
join_buffer_size = 2M
read_buffer_size = 128K
read_rnd_buffer_size = 256K
innodb_io_capacity = 1000
innodb_flush_log_at_trx_commit = 1
innodb_log_buffer_size = 16M
innodb_file_per_table = 1
sql_mode = "STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION"
max_allowed_packet = 64M
--- --- --- --- ---
Open command prompt and run as administrator
$ cd C:\Users\dell\programs\mysql-server\mysql-v9.7.1\bin
$ mysqld --defaults-file="C:\Users\dell\programs\mysql-server\mysql-v9.7.1\my.ini" --initialize-insecure
$ mysqld --install "MySQL_p3424_v9.7.1" --defaults-file="C:\Users\dell\programs\mysql-server\mysql-v9.7.1\my.ini"
$ net start "MySQL_p3424_v9.7.1"
$ mysql -u root -p (enter)
$ use mysql;$ ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'type_your_password';$ ALTER USER 'root'@'localhost' IDENTIFIED BY 'type_your_password';
$ ALTER USER 'root'@'localhost' IDENTIFIED WITH caching_sha2_password BY 'type_your_password';
$ FLUSH PRIVILEGES;
$ exit
$ mysql -u root -p (enter, then type your password, then enter again)
--------------------------------------------------
If you get error message "Public Key Retrieval is not allowed",
change these on your database properties :
* allowPublicKeyRetrieval = true
* sslMode = disabled
* useSSL = false
Finish.
Comments
Post a Comment