help with root@localhost error

[tomburton87]

Hi everyone,

have a database and a table that connects to it and displays results.

im not sure what ive changed however now when i click on any search options on the page i get

access denied for user root@localhost using password NO.

 

im assuming that perhaps the root password has been set somewhere whereas it was blank before hand as im ready when phpmyadmin is installed it is defualted blank?

 

 

the page can currently be viewed here http://new.mansfields.net.au/austraflora/plants.php

as you can see the initail connect seems to work as it displays the content but if you make a change in the search filter options such as "frost tolerance high" etc it will fail.

 

any help would be fantastic thank you.

[ultraloveninja]

It indicates that root has a password, but you are not supplying it, hence the (Using password: NO)

 

check this out as this may help:

http://forums.macosxhints.com/showthread.php?t=58057

[tomburton87]

im slightly new to this,

if i ftp to my webserver, i have no config.inc.php file in the libraries folder like the link says...

i do however have one in the config folder.

if i open this there are none of the settings listed to change for the fix...

this is all there is

 

/* Servers configuration */

$i = 0;

 

/* End of servers configuration */

 

$cfg['notice'] = array (

  'ForceSSL' =>

  array (

    'fresh' => false,

    'active' => false,

    'title' => 'Force SSL connection',

    'message' => 'This <a href="?page=form&formset=features#tab_Security">option</a> should be enabled if your web server supports it',

  ),

);

$cfg['warning'] = 'Anix';

$cfg['blowfish_secret'] = '********';

$cfg['DefaultLang'] = 'en-utf-8';

$cfg['ServerDefault'] = 1;

$cfg['UploadDir'] = '';

$cfg['SaveDir'] = '';

?>

 

 

is there some sort of sql command i can run from within phpmyadmin to reset root password to blank?

\

[Deoctor]

run these commands in the phpmyadmin

 

USE mysql;
UPDATE USER SET PASSWORD='' WHERE USER='root';

i hope this will work..

[tomburton87]

afraid i get an access denied error

 

This has got me stumped.

[Deoctor]

are u using the root access. if it is a local machine then try using the sqlyog to change the password..