somnath

No, I only see phpMyAdmin only for mysql administration.

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'

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.

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