I am having problem with the set up in my local machine . I am doing this so that I can test some php script.

I am using Windows XP home with Uniserver to test the PHP code. I am using phpmyadmin to adminstor the sql server.

I created a new database and an user using phpadmin . I have added all the required tables for the script as well.

Now the problem is the script can read the database but can't insert.
I see only this error in the error log :
[Wed Jul 25 11:08:29 2007] [error] [client 127.0.0.1] File does not exist: W:/home/admin/www/phpMyAdmin/themes/original/img/error.ico, referer: http://localhost/apanel/phpMyAdmin/read_dump.php
- [Wed Jul 25 11:08:15 2007] [error] [client 127.0.0.1] File does not exist: W:/home/admin/www/phpMyAdmin/themes/original/img/error.ico, referer: http://localhost/apanel/phpMyAdmin/tbl_pro...e=exam_customer

So I tried to access the database using cmd line. Here are the error messages :
C:\UniServer\Uniform Server\diskw\usr\local\mysql\bin>mysql -u somnathnag -p abc123 -D somnath -b
Enter password: *******
ERROR 1045 (28000): Access denied for user 'somnathnag'@'localhost' (using passw
ord: YES)
C:\UniServer\Uniform Server\diskw\usr\local\mysql\bin>mysql -u somnathnag -p abc123 -D somnath -b
Enter password: *******
ERROR 1049 (42000): Unknown database 'abc123'

I searched the web but nothing helped me. Moreover I am new to mySql as well.
Any pointers will help.

Thanks
Somnath

The username and password is root/root.

If you chnaged it, as it seem, can you tell me how you changed it?

I changed the password through the phpmyadmin in the previlege menu and then clicking on the edit button for user 'root' and then did the change password.



I have the password for the root as root - I haven't changed it - I changed for the user - somnathnag that I have added. I have given all previleges and grant to the user but then also I can't do the insert.

Thats the wrong way to change the username and password. The right way is through the admin panel: http://localhost/apanel

Unless you make a new user, the root stays root! But you can change the password.

I checked localhost/apanel but didn't find any option to change the password. Moreover I added a new user somnathnag but don't know what previleges to give so that php scripts can insert into the database.

Why I am getting this error from command line ?
C:\UniServer\Uniform Server\diskw\usr\local\mysql\bin>mysql -u somnathnag -p abc123 -D somnath -b
Enter password: *******
ERROR 1045 (28000): Access denied for user 'somnathnag'@'localhost' (using passw
ord: YES)
C:\UniServer\Uniform Server\diskw\usr\local\mysql\bin>mysql -u somnathnag -p abc123 -D somnath -b
Enter password: *******
ERROR 1049 (42000): Unknown database 'abc123'

In the admin panel, dont you see MySQL Administration or soemthing like that?

No, I only see phpMyAdmin only for mysql administration.

What version are you using?