摘要:
下载:http://downloads.sourceforge.net/project/phpmyadmin/phpMyAdmin/4.0.2/phpMyAdmin-4.0.2-all-languages.tar.bz2?r=http%3A%2F%2Fsourceforge.net%2Fprojects%2Fphpmyadmin%2F&ts=1370058054&use_mirror=ncu输入用户名和密码后点击“执行”,报错: “#2002 无法登录 MySQL 服务器”。解决:将 “phpMyAdmin/libraries”文件夹下的config.default.php文件 阅读全文
摘要:
修改用户密码: 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 < 阅读全文