How to install MySQL Server in Windows without using Admin Credentials

config.ini -------------------------------------------------------------------------------------------------- # For advice on how to change settings please see # http://dev.mysql.com/doc/refman/5.7/en/server-configuration-defaults.html [mysqld] # Remove leading # and set to the amount of RAM for the most important data # cache in MySQL. Start at 70% of total RAM for dedicated server, else 10%. # innodb_buffer_pool_size = 128M # Remove leading # to turn on a very important data integrity option: logging # changes to the binary log between backups. # log_bin # These are commonly set, remove the # and set as required. # basedir = ..... # datadir = ..... # port = ..... # server_id = ..... # Remove leading # to set options mainly useful for reporting servers. # The server defaults are faster for transactions and fast SELECTs. # Adjust sizes as needed, experiment to find the optimal values. # join_buffer_size = 128M # sort_buffer_size = 2M # read_rnd_buffer_size = 2M sql_mode = NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES # set basedir to your installation path basedir = "C:\\Users\\user\\dev\\mysql-db\\mysql-5.7.17-winx64" # set datadir to the location of your data directory datadir = "C:\\Users\\user\\dev\\mysql-db\\mydb" # The port number to use when listening for TCP/IP connections. On Unix and Unix-like systems, the port number must be # 1024 or higher unless the server is started by the root system user. port = "3306" # Log errors and startup messages to this file. log-error = "C:\\Users\\user\\dev\\mysql-db\\logs\\error_log.err" [mysqladmin] user = "root" port = "3306" -------------------------------------------------------------------------------------------------- initialize "C:\Users\user\Downloads\mysql-db\mysql-8.0.32-winx64\bin\mysqld.exe" --defaults-file="C:\\Users\\user\\Downloads\\mysql-db\\config.ini" --initialize-insecure --console start the MySQL database server "C:\Users\user\Downloads\mysql-db\mysql-8.0.32-winx64\bin\mysqld.exe" --defaults-file="C:\\Users\\user\\Downloads\\mysql-db\\config.ini" start the MySQL database server "C:\Users\user\Downloads\mysql-db\mysql-8.0.32-winx64\bin\mysqld.exe" --defaults-file="C:\\Users\\user\\Downloads\\mysql-db\\config.ini" shutdown