14 messages in com.mysql.lists.win32RE: Adding a User| From | Sent On | Attachments |
|---|---|---|
| Dwight Ian | 02 Feb 2004 16:34 | |
| Armando | 02 Feb 2004 17:10 | |
| Dwight Ian | 02 Feb 2004 19:31 | |
| Armando | 02 Feb 2004 21:06 | |
| Dwight Ian | 03 Feb 2004 00:07 | |
| Josue Mora | 03 Feb 2004 08:18 | |
| jbon...@sola.com.au | 03 Feb 2004 14:31 | |
| Armando | 03 Feb 2004 18:57 | |
| Armando | 03 Feb 2004 19:02 | |
| Armando | 04 Feb 2004 14:48 | |
| PF: MySQL | 04 Feb 2004 15:04 | |
| Randy Clamons | 04 Feb 2004 15:20 | |
| Armando | 04 Feb 2004 16:22 | |
| Randy Clamons | 04 Feb 2004 16:58 |
| Subject: | RE: Adding a User![]() |
|---|---|
| From: | Armando (diji...@shaw.ca) |
| Date: | 02/02/2004 05:10:02 PM |
| List: | com.mysql.lists.win32 |
On a fresh install there is already a default user, and that's root. If you want to add more users, you have to login to mysql with root first. Instead of just typing mysql at the \mysql\bin directory command prompt, type:
mysql -u root myqsql
This will connect you to the mysql server as root. Also, the user 'root' doesn't have a password on a fresh installed so once you've successfully connected using the above, you should change root's password:
update user set password=password('your_password') where user='root';
Then you can add all the users you like. Check the manual for this information as it is clearly detailed on what you need to do to create new users. Cheers.
Armando
-----Original Message----- From: Dwight Ian [mailto:meim...@yahoo.com] Sent: Monday, February 02, 2004 6:35 PM To: win...@lists.mysql.com Subject: Adding a User
Good Computing day to you All, :)
I have installed MySQL 4.0.17 in my computer (c:/mysql). I tried to access it so I go to, in Windows...
c:/mysql/bin> mysql (successful connection) mysql>
How to I add a user so that I can use the form c:/mysql/bin/ mysql -u username -p ?
Please... thanks. Where will I add the user, and what is the syntax?
--------------------------------- Do you Yahoo!? Yahoo! SiteBuilder - Free web site building tool. Try it!




