somnath Posted July 25, 2007 Report Share Posted July 25, 2007 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 -bEnter password: *******ERROR 1045 (28000): Access denied for user 'somnathnag'@'localhost' (using password: YES)C:\UniServer\Uniform Server\diskw\usr\local\mysql\bin>mysql -u somnathnag -p abc123 -D somnath -bEnter 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. ThanksSomnath Quote Link to comment Share on other sites More sharing options...
olajideolaolorun Posted July 25, 2007 Report Share Posted July 25, 2007 The username and password is root/root. If you chnaged it, as it seem, can you tell me how you changed it? Quote Best Regards Olajide Olaolorun The Uniform Server Development Team Link to comment Share on other sites More sharing options...
somnath Posted July 25, 2007 Author Report Share Posted July 25, 2007 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. Quote Link to comment Share on other sites More sharing options...
olajideolaolorun Posted July 25, 2007 Report Share Posted July 25, 2007 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. Quote Best Regards Olajide Olaolorun The Uniform Server Development Team Link to comment Share on other sites More sharing options...
somnath Posted July 26, 2007 Author Report Share Posted July 26, 2007 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 -bEnter password: *******ERROR 1045 (28000): Access denied for user 'somnathnag'@'localhost' (using password: YES)C:\UniServer\Uniform Server\diskw\usr\local\mysql\bin>mysql -u somnathnag -p abc123 -D somnath -bEnter password: *******ERROR 1049 (42000): Unknown database 'abc123' Quote Link to comment Share on other sites More sharing options...
olajideolaolorun Posted July 26, 2007 Report Share Posted July 26, 2007 In the admin panel, dont you see MySQL Administration or soemthing like that? Quote Best Regards Olajide Olaolorun The Uniform Server Development Team Link to comment Share on other sites More sharing options...
somnath Posted July 26, 2007 Author Report Share Posted July 26, 2007 No, I only see phpMyAdmin only for mysql administration. Quote Link to comment Share on other sites More sharing options...
olajideolaolorun Posted July 26, 2007 Report Share Posted July 26, 2007 What version are you using? Quote Best Regards Olajide Olaolorun The Uniform Server Development Team Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.