Setting Up Users 2

[MadJock]

HELP!!!

I know this is probably a really simple question but I haven't been able to suss it.

I have just installed mySQL on my PC as I am hoping to use it as an alternative to SQL server for some ASP Forms.

Whenever I try to connect to the database (I have been trying via Access 2000) I get 'Access Denied for User'.

I have looked in the .INI file and the username I have set up is 'gtaylor' and the password is 'grt'. Is this a different kind of user (like admin or something)?

How do I add new users? I am running the GUI Admin tool on Windows NT 4.0

Thanks in advance for any help.

Graeme website:

http://www.graeme-taylor.co.uk

 

[piti]

i'm not familiar with the win build of mysql, but on the *ix systems, and i assume on wins it's the same, there are users and their rights stored in a database called mysql, which is created during install
so you'll need to add your users to that database

hope that helps

 

[sleipnir214]

Check out the options of the "GRANT" directive.