加拿大华人论坛 美国华人新闻MySQL常用命令
在加拿大
添加用户 & 用户授权: 代码: mysql> GRANT ALL PRIVILEGES ON *.* TO 'monty'@'localhost'IDENTIFIED BY 'some_pass' WITH GRANT OPTION;mysql> GRANT ALL PRIVILEGES ON *.* TO 'monty'@'%'IDENTIFIED BY 'some_pass' WITH GRANT OPTION;mysql> GRANT RELOAD,PROCESS ON *.* TO 'admin'@'localhost';mysql> GRANT USAGE ON *.* TO 'dummy'@'localhost'; 用文件倒入整个数据库 代码: mysql -u chineseinla -p -h localhost chineseinla --default-character-set=utf8 < /srv/www/mysql.sql 导出一个数据到文件引用:mysqldump -u username -p --databases database > database.sql
·新西兰新闻 今日,涉嫌谋杀尼尔森女警男子出庭,否认谋杀指控!
·新西兰新闻 “恶心!”新西兰男子在派中发现“恶心”异物,疑似牛“菊花