aspose file tools*
The moose likes JDBC and the fly likes How To Create User In The MySQL? Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "How To Create User In The MySQL?" Watch "How To Create User In The MySQL?" New topic
Author

How To Create User In The MySQL?

JiaPei Jen
Ranch Hand

Joined: Nov 19, 2000
Posts: 1309
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 ]
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: How To Create User In The MySQL?