Win a copy of Functional Reactive Programming this week in the Other Languages forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

How To Create User In The MySQL?

 
JiaPei Jen
Ranch Hand
Posts: 1309
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I have the MySQL-3.23.55 installed in my PC. Therefore, I am the DBA without the required DBA knowledge.
First, how do I create users in the MySQL database?
Second, how do I grant table creation privilege to users? Is
GRANT ALL PRIVILEGES ON databasename TO someuser IDENTIFIED
BY 'somepassword';
the correct command?
Thanks for your guidance.
[ September 10, 2003: Message edited by: JiaPei Jen ]
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic