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';