Mysql knowledge

From JazzTeamWiki
Jump to: navigation, search

change password of root user

  • mysql -u root -p
  • use mysql;

(update user set password=PASSWORD("sql") where User='root';

  • flush privileges;

run sql file

  • mysql -u root -p
  • source %name of file%