1、cmd 进入mysql: mysql -u root -p
2、增加用户: GRANT USAGE ON *.* TO 'vincent'@'localhost' IDENTIFIED BY '520' WITH GRANT OPTION;
注意不要用 insert into user (host,user,password) values ("localhost","vincent",PASSWORD("520")); 在5.1里面会出现Field 'ssl_cipher' doesn't have a default value错误
3、查看所有用户: SELECT DISTINCT CONCAT('User: ''',user,'''@''',host,''';') AS query FROM mysql.user;