![]() ![]() Which user account do you want to change the password?. ![]() ![]() Remember to use full path both for mysqld-nt.exe and your created file.Before changing the password of a MySQL user account, you should consider the following important questions: So first you have to create file as stated in point 3 and then, using a command line (Start->Run->CMD(ENTER), run mysqld-nt.exe with -init-file param pointing to that file. After the server has started successfully, delete C:\mysql-init.txt. Find the MySQL service in the list, right-click it, andĬhoose the Properties option. The Start menu, select Control Panel, then Administrative Tools, then defaults-file setting can be found using the Services Manager: From You may need to specify a -defaults-file option: C:\> "C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt.exe" -defaults-file="C:\\Program Files\\MySQL\\MySQL Server 5.0\\my.ini" -init-file=C:\\mysql-init.txt If you installed MySQL using the MySQL Installation Wizard, Want server output to appear in the console window rather than in a You can also add the -console option to the command if you The -init-file option at startup, changing each root account The server executes the contents of the file named by MySQL to a location other than C:\mysql, adjust the commandĪccordingly. That the backslash in the option value is doubled): C:\> C:\mysql\bin\mysqld-nt -init-file=C:\\mysql-init.txt Start the MySQL server with the special -init-file option (notice Menu, select Run, then enter cmd as the command to be run.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |