"adnan alsamari" <scarswell@rochester.rr.com> wrote in message
news:RRcQc.87429$yd5.35278@twister.nyroc.rr.com...[color=blue]
> Hi,
> I can only access mysql through the root by typing mysql -u root -p. But
> when I use any other user to connect to mysql I get the access denied[/color]
error[color=blue]
> message. Mysql is installed on windows xp. I looked up information online
> to solve this problem and saw that there are some scripts that i may be[/color]
able[color=blue]
> to run in order to fix the problem. But I am not sure how to handle those
> scripts since they are only made for unix systems. I tried to connect to
> the server using PHP, but i cant connect as well. I am really new to this
> and would appreciate the least help..
>
> The way i am create users is by inserting a user in the user table.. or by
> granting privileges to a random user. Is there any other way of creating
> users? The way I am checking whether a user account is working is by[/color]
typing[color=blue]
> mysql -u username -ppassword. Is there any other way of doing this..[/color]
Anyone[color=blue]
> know why access denied but the users i created do show in the user table[/color]
Try logging in as root then grant access to other users:
suppose your database you are granting access is called "mydb"
GRANT ALL ON mydb.* TO username@localhost;
Check the mysql documentation for more information at
http://dev.mysql.com/doc/mysql/en/SQL_Syntax.html 
