1 有环境变量可以省略这个 cd d:\program\mysql\mysql server 5.5\bind:\program\mysql\mysql server 5.5\binmysql -uroot -p 2 建用户并授权 grant all privileges on *.* to user@localhost identified by pwd with grant option;grant all privileges on
1 有环境变量可以省略这个
cd d:\program\mysql\mysql server 5.5\bind:\program\mysql\mysql server 5.5\bin>mysql -uroot -p

2 建用户并授权
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;
3建库删库
create database test2 default character set utf8 collate utf8_bin;drop database test2;
4导入导出
mysqldump -uroot -proot dbname>d:\1.sqlmysql -uroot -proot --default-character-set=utf8 dbname
5 查看mysql配置
ps aux | grep mysqldroot 5036 0.0 0.0 61220 748 pts/2 s+ 17:21 0:00 grep mysqldroot 25970 0.0 0.0 64020 1292 ? s sep15 0:00 /bin/sh /usr/bin/mysqld_safe --defaults-file=/mysqldata/mysql3306/3306.cnfnobody 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
6 重启 停止 启动 状态service mysqld stop/start/restart/status%mysqld_path%/mysqld stop/start/restart/status
错误1
error 2002 (hy000): can't connect to local mysql server through socket '/var/lib/mysql/mysql.sock' (2)
mysql -uroot -p --socket=/tmp/mysql3306.sock
错误2
please read security div of the manual to find out how to run mysqld as root!
mysql -uroot -p --user==root