create user in MySQL 5.0
The create user command:mysql> CREATE?USER?yy?IDENTIFIED?BY?'123';
grant:
mysql> GRANT?ALL?PRIVILEGES?ON?*.*?TO?'user'@'host' [ IDENTIFIED BY'password' ];
flush:
mysql> flush?privileges;
now u can login with:
$ mysql -u username -p
posted on 2006-03-21 22:21 Stuart 閱讀(2762) 評論(0) 編輯 收藏 所屬分類: DataBase