If you'd like to raise innodb_buffer_pool_size without restarting mysqld, you can set the variable at run-time. The size unit is in byte. mysql> set global… Read More »Change innodb_buffer_pool_size Online
Before MySQL 5.7 For the first time to reset root password before MySQL 5.7, you set the new password by mysqladmin: On Windows.C:\Users\ed>mysqladmin -u'root' password… Read More »MySQL Set Root Password