mysqld –initialize-insecure –user=admin_userįor simplicity, in this example, we will initialize using the default username ( root ) without a password. MySQL 5. While for mysqld –initialize-insecure, there is no password to be set, Nevertheless, we can still create a password later.īy default, the process will create a user to login with root as the username, we can define another username by adding –user option, e.g.

The Difference is: mysqld –initialize will create a random password that written to the log file, in this example mysql_log.log file located in the data folder. This process will create necessary files and databases that used to run MySQL including making a username and optionally a password and set privileges to the user.

Initialization MySQL (It needs only once) The folder shows the following structure: bin cgi. Reference to the configurations can be found on the official page: Click Here 6. The folder is located under c: xampp (in Windows environment) and under Applications (in OS X environment). The Optional – Default Configuration section is optional, you can remove or change it as needed.

Install mysql xampp windows