Stuart ONE

我有一头小毛驴，我从来也不骑……

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 阅读(2750) 评论(0) 编辑收藏所属分类: DataBase


只有注册用户登录后才能发表评论。




网站导航: 博客园 IT新闻知识库 C++博客博问管理
相关文章: create user in MySQL 5.0 How to connect to a postgresql server from client in Debian Postgresql 8.0