关于数据库拷贝，新建(MySql)

学习中遇到的两个问题，记录一下， 当时用英文写的，这里就不翻译过来了。

1. Copy a database to a new database:   

  For example,  copy database redmine to database redmineForDev,
    first , you should create database redmineForDev,
    then run command" mysqldump -u root -p redmine | mysql -u root -p redmineForDev "
    then you have to enter your password for twice.
    Done.

Tips: mysqldump can only run in command line not in shell. Which means you can't log on to mysql, just finish this in CMD(windows,add mysql/bin to path) or terminal(LINUX).
      More info about mysqldump on Google.


2. Problem, access denied for user.
    This means you don't have the privilege to access the database.
    Maybe you should examine the "create user" command.
  For example,  create user 'redminedev'@'localhost' identified by 'redminedevPwd';
    ...@'localhost' means  only localhost user can access to the dabatase.
    you should use create user 'redminedev'@'%' identified by 'redminedevPwd';
    so all host user can access to the database.