http://www.mysql.com/doc/en/Adding_users.html
First, use the mysql program to connect to the server as the MySQL root
user:
shell> mysql --user=root mysql
Then you can add new users by issuing GRANT statements:
mysql> GRANT ALL PRIVILEGES ON *.* TO [EMAIL PROTECTED]
-> IDENTIFIED BY 'some_pass' WITH GRANT OPTION;
mysql> GRANT ALL PRIVILEGES ON *.* TO monty@'%'
-> IDENTIFIED BY 'some_pass' WITH GRANT OPTION;
mysql> GRANT RELOAD,PROCESS ON *.* TO [EMAIL PROTECTED];
mysql> GRANT USAGE ON *.* TO [EMAIL PROTECTED]
====
Dear Caroline Jen,
Sometimes this is not quite clear explained in
All text books,
But the above snip does the trick,
Under windows XP.
If security is a very important topic for you,
A different Operating system could offer you more safety.
But please take into consideration that mysql behaves different under
Linux and windows. The commands are not exactly the same.
Even if it is the same MySQL version.
Yours sincerely
Morten Gulbrandsen
-----Ursprüngliche Nachricht-----
Von: Caroline Jen [mailto:[EMAIL PROTECTED]
Gesendet: Mittwoch, 10. September 2003 22:33
An: [EMAIL PROTECTED]
Betreff: How To Create Users In MySQL?
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.
__________________________________
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software
http://sitebuilder.yahoo.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
