Error : File does not exist: W:/home/admin/www/phpMyAdmin/themes/original/img/error.ico

[somnath]

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

[olajideolaolorun]

The username and password is root/root.

 

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

[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 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.

[olajideolaolorun]

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.

[somnath]

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'

[olajideolaolorun]

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

[somnath]

No, I only see phpMyAdmin only for mysql administration.

[olajideolaolorun]

What version are you using?