mysql导入导出数据库,并增加用户
dumping the whole database:
mysqldump -uroot -p mydb > bkp.sql
restore data:
mysql -uroot -p mydb < bkp.sql(can also use source after login.)
为创建的数据库增加用户和权限,并运行从本地和远程登陆.
GRANT ALL PRIVILEGES ON *.* TO myusername@'%' IDENTIFIED BY 'mypassword' WITH GRANT OPTION;
FLUSH PRIVILEGES;
不能远程访问的问题:
/etc/mysql/my.cnf
# Instead of skip-networking the default is now to listen only on
# localhost which is more compatible and is not less secure.
#bind-address = 127.0.0.1
注释bind-address后重新启动mysql
sudo /etc/init.d/mysqld restart(使用该命令重新启动不好使,重启了机器后好使了,喂马?)
mysqldump -uroot -p mydb > bkp.sql
restore data:
mysql -uroot -p mydb < bkp.sql(can also use source after login.)
为创建的数据库增加用户和权限,并运行从本地和远程登陆.
GRANT ALL PRIVILEGES ON *.* TO myusername@'%' IDENTIFIED BY 'mypassword' WITH GRANT OPTION;
FLUSH PRIVILEGES;
不能远程访问的问题:
/etc/mysql/my.cnf
# Instead of skip-networking the default is now to listen only on
# localhost which is more compatible and is not less secure.
#bind-address = 127.0.0.1
注释bind-address后重新启动mysql
sudo /etc/init.d/mysqld restart(使用该命令重新启动不好使,重启了机器后好使了,喂马?)
