I am using phpMyAdmin , written in

[newbiepg]

I am using phpMyAdmin , written in php3
and redhat 7.3
I have configured the usename and password of config.inc.php3 as "root" and "".
This shows me all the databases and the tables in it.
However it cannot insert or update most of the tables(except for test).
Can someone tell me what to do?
Do I have to change privileges anywhere?

 

[anders2002]

Are you sure 'root' and '' are the username and pass you have setup on your version of mySQL?

If so..

Have you tried restarting the database? Sometimes this helps if you have altered any privilages.

Otherwise, click the HOME button from within phpmyadmin(top left), then the USERS link and check the privilages allowed to your user there? Here you can specify for global privilages or individual DBs, or even individual tables.

make sure your user is set to have these privilages: Select Insert Update Delete Create Drop Reload Shutdown Process File Grant References Index Alter

and that you have set it up correctly for localhost or remote(%) access.

Again, click RELOAD MYSQL after making any changes.

Is this any help?

Anders

 

[likeopensource]

I had the same problem, the thing is both netscape and opera cannot take too many lines as an sql query in the phpMyAdmin query block.

Check this

Use the sql query box to insert one row.If you are able to do that then it is basically a browser problem.

Most of the time we just copy the sql file in full and paste it on phpMyAdmin. This returns zero rows updated. Copy in parts and paste it.

If it still does not work check your configuration(username,password most probably)