修改用户密码:
mysqladmin -uroot password "mylovelypassword"
创建一个utf-8编码的数据库:
CREATE DATABASE `test2` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci
备份数据库:
mysqldump -hhostname -uusername -ppassword databasename > backupfile.sql
还原数据库:
mysql -hhostname -uusername -ppassword databasename < backupfile.sql
数据库压缩备份:
mysqldump -hhostname -uusername -ppassword databasename | gzip > backupfile.sql.gz
还原压缩的数据库:
gunzip < backupfile.sql.gz | mysql -uusername -ppassword databasename
关于MysQLdb使用
当使用MySQLdb出现类似Image not found之类的错误时,试试这个:
sudo ln -s /usr/local/mysql/lib/libmysqlclient.18.dylib /usr/lib/libmysqlclient.18.dylib sudo ln -s /usr/local/mysql/lib /usr/local/mysql/lib/mysql