mysql新規ユーザーの追加

2433 ワード

           
INSERT INTO user (host, user, password, select_priv, insert_priv, update_priv) VALUES ('localhost', 'dcw', PASSWORD('dcw123'), 'Y', 'Y', 'Y');

Field 'ssl_cipher' doesn't have a default value


mysql , , ,mysql insert user , MYSQL , user INSERT , MYSQL 5.1 , 。
:(dcw ,dcw123 )

 mysql> GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP    -> ON TUTORIALS.*  -> TO 'dcw'@'localhost'  -> IDENTIFIED BY 'dcw123';