December 19th, 2013, 02:39 AM
Working on setting up MySQL
I would like to Replace the Root password in MySQL 5.6 running in Win7 Pro.
I have a .bat file called:
I have a .txt file called:
:: Replace Root Password
net stop MySQL56
CD "C:\Programs\MySQL\MySQL Server 5.6\bin"
mysqld -nt --init-file=D:\Dnload\MySQLRootPasswordReplace.txt --console
::net start MySQL56
When I run it I get this:
UPDATE mysql.user SET Password=PASSWORD('MyPassword') WHERE User='root';
C:\Programs\MySQL\MySQL Server 5.6\bin>mysqld -nt --init-file=D:\Dnload\MySQLRoo
2013-12-18 23:37:48 0 [Warning] option 'new': boolean value 't' wasn't recognize
d. Set to OFF.
2013-12-18 23:37:48 0 [Warning] TIMESTAMP with implicit DEFAULT value is depreca
ted. Please use --explicit_defaults_for_timestamp server option (see documentati
on for more details).
What did I do wrong?
December 21st, 2013, 01:29 PM
What is your purpose with the "-nt" argument?
Originally Posted by Docfxit
My guess is that is what mysqld is complaining about because if I run:
It shows that the argument -n means:
mysqld --verbose --help
-n, --new Use very new possible "unsafe" functions
December 21st, 2013, 02:38 PM
Thank you for the reply...
I had just copied what someone else posted on how to change the root password. I have removed the -nt and that took care of the first warning. I now have remaining this warning:
C:\Programs\MySQL\MySQL Server 5.6\bin>mysqld --init-file=D:\Dnload\MySQLRootPas swordReplace.txt --console
2013-12-21 11:34:57 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option
(see documentation for more details).
Thank you very much for the suggestion,