There is a small text file called my.ini that is part of the MySQL or MariaDB installation.
The file for MariaDB users will look like this:
basedir="C:/Program Files/MariaDB 10.5/"
The files looks like this:
basedir="C:/Program Files (x86)/MySQL/MySQL Server 5.5/"
Or, if you are still using MySQL 5.0, then it might look like this:
basedir="C:/Program Files/MySQL/MySQL Server 5.0/"
If you are a power user, you can look at the examples of alternate my.ini files in the same folder. For example, open my-huge.ini and look under the [mysqld] section. Selective copying of some of those Variables above into your my.ini file would help to take advantage of a more powerful server. For example, here is a suggested my.ini file. DO NOT change the existing path of the basedir or datadir. The paths in the example below might not be the same as on your system.
basedir="C:/Program Files/MySQL/MySQL Server 5.5/"
key_buffer = 384M
table_cache = 512
sort_buffer_size = 2M
read_buffer_size = 2M
read_rnd_buffer_size = 8M
myisam_sort_buffer_size = 64M
thread_cache_size = 8
query_cache_size = 32M
tmp_table_size = 32M
join_buffer_size = 128M
Because the my.ini file is the Program Files folder, you will not be allowed by Windows to edit the file directly. There are two workarounds to the Windows security issue:
In both cases, stop the MySQL service before making the changes, and then start the service after saving the changes.