This week's giveaway is in the Android forum.
We're giving away four copies of Android Security Essentials Live Lessons and have Godfrey Nolan on-line!
See this thread for details.
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


Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
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 ]
 
 
subject: How To Create User In The MySQL?
 
Similar Threads
SQL Plus and Batch files
Problems with hibernate and mysql?
Mysql administration
How Do I Remove Users From MySQL Database?
Cannot login to isqlplus