MySQL快速上手

Install MySQL

1.DownLoad MySQL https://dev.mysql.com/downloads/installer/

2.ZIP file to c:\program Files\..

3.Amintor Open CMD.exe Wirte line

  Cd c:\program Files\..\bin

  Mysqld --install

  Mysqld --initialize

  Net start mysql

4.Yeild,You can use Mysql Beanch or Navcat for Mysql to Build a DB

 

5.Changed password : find c:\program Files\...\data\...err [Note] A temporary password is generated for root@localhost:...

6.Login the root :mysql -uroot -p

Write in the default password and than changed the password

 

SET PASSWORD FOR ‘root’@’localhost’=PASSWORD(‘123456’);

 

DONE!