Mysql

From Foochal

Jump to: navigation, search


Contents

Logging in

mysql --user <username> <dbname> -h <hostname> -p

Changing root password

http://www.cyberciti.biz/nixcraft/vivek/blogger/2006/04/recover-mysql-root-password.php

Adding new user

http://dev.mysql.com/doc/refman/5.0/en/adding-users.html

Backing up a database

mysqldump dbname > dbname_backup.sql

Personal tools