When I start mysqld I see: > mysqld -console -init-file=.\set_root_password.sql Sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES # Adjust sizes as needed, experiment to find the optimal values. # The server defaults are faster for transactions and fast SELECTs. # Remove leading # to set options mainly useful for reporting servers. # These are commonly set, remove the # and set as required.ĭatadir=c:\Programs\mysql-5.6.10-win32\data # changes to the binary log between backups. # Remove leading # to turn on a very important data integrity option: logging Start at 70% of total RAM for dedicated server, else 10%. # Remove leading # and set to the amount of RAM for the most important data # *** upgrade to a newer version of MySQL.
# *** default location during install, and will be replaced if you It's a template which will be copied to the my.ini # For advice on how to change settings please see
I know it’s not secure to connect as a root without the password, but I just need to do some test, so it’s ok for me to do it now (and if I know how to connect as a root I know how to add another user too). I followed this tutorial, but I’m not able to connect to my MySQL database as root. I simply donwloaded and unzipped mysql-5.6.10-win32.zip from MySQL site. I know, it’s really sad, but I’m not able to connect to MySQL database.
