MySQL Installation and Configuration

<01> Download the MySQL to D drive and rename the folder to MySQL

<02> Console Status Enter Mysql/bin directory input mysqld-install carriage return installation Service

<03> new Data directory under MySQL directory, console input command mysqld--initialize

<04> find Mydefault.ini in MySQL directory to edit under [mysqld], add skip-grant-tables, and modify the file name to My.ini

<05> console input net start MySQL Enter start service

<06> Console input mysqld-u root-p create root account

<07> console input Mysql-u root-p return

<08> Ignore password direct return

<09> console input Use MySQL

<10> console Input Update mysql.user set Authentication_string=password (' New password ') where user= ' root ' and Host = ' localhost ';

<11> console input Mysql>flush privileges;

<12> Delete Skip-grant-tables added to My.ini

<13> Restart MySQL

<14> common ways to change passwords

MySQL Installation and Configuration