mysql 命令

cd D:ProgramMySQLMySQL Server 5.5in
D:ProgramMySQLMySQL Server 5.5in>mysql -uroot -p

GRANT ALL PRIVILEGES ON *.* TO user@localhost IDENTIFIED BY 'pwd' WITH GRANT OPTION;
GRANT ALL PRIVILEGES ON *.* TO user@'%' IDENTIFIED BY 'pwd' WITH GRANT OPTION;#话说密码里有，执行这句的时候要在前边加\,变成一共3个斜杠
FLUSH PRIVILEGES;

CREATE DATABASE test2 DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;
DROP DATABASE test2;

mysqldump -uroot -proot dbname>D:
.sql
mysql -uroot -proot --default-character-set=utf8 dbname<D:
.sql

ps aux | grep mysqld
root      5036  0.0  0.0  61220   748 pts/2    S+   17:21   0:00 grep mysqld
root     25970  0.0  0.0  64020  1292 ?        S    Sep15   0:00 /bin/sh /usr/bin/mysqld_safe --defaults-file=/mysqldata/mysql3306/3306.cnf
nobody   26729  0.3  1.9 1873068 1316752 ?     Sl   Sep15  10:20 /usr/sbin/mysqld --defaults-file=/mysqldata/mysql3306/3306.cnf --basedir=/usr --datadir=/mysqldata/mysql3306 --plugin-dir=/usr/lib64/mysql/plugin --user=nobody --log-error=/mysqldata/mysql3306/slave.err --open-files-limit=8192 --pid-file=/mysqldata/mysql3306/slave.pid --socket=/tmp/mysql3306.sock --port=3306

service mysqld stop/start/restart/status
%mysqld_path%/mysqld stop/start/restart/status

mysql -uroot -p --socket=/tmp/mysql3306.sock

mysql -uroot -p --user==root