14 messages in com.mysql.lists.win32RE: Adding a User
FromSent OnAttachments
Dwight Ian02 Feb 2004 16:34 
Armando02 Feb 2004 17:10 
Dwight Ian02 Feb 2004 19:31 
Armando02 Feb 2004 21:06 
Dwight Ian03 Feb 2004 00:07 
Josue Mora03 Feb 2004 08:18 
jbon...@sola.com.au03 Feb 2004 14:31 
Armando03 Feb 2004 18:57 
Armando03 Feb 2004 19:02 
Armando04 Feb 2004 14:48 
PF: MySQL04 Feb 2004 15:04 
Randy Clamons04 Feb 2004 15:20 
Armando04 Feb 2004 16:22 
Randy Clamons04 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.

-----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?