I crewed my DB access permissions in mySQL using phpmyadmin...

[Wreck-It]

Can anyone help?


Here's a sample :

SQL-query :

SHOW TABLE STATUS FROM `wreckit`

MySQL said:


#1044 - Access denied for user: 'root@localhost' to database 'wreckit'

And it seems that i've also killed phpmyadmin's permission to create a new DB:

[mjmaltese]

What OS is your server running on? In a UNIX environment, you would start mysqld with the --skip-grant-tables argument. This will allow you to reset your password, then stop and restart the server as usual. On Windows you can do this from the command line.

As for the error phpMyAdmin is giving you, open up the file config.inc.php and change $cfg['PmaAbsoluteURI'] to the full URI of your phpMyAdmin installation, i.e., $cfg['PmaAbsoluteURI'] = 'http://www.example.com/phpmyadmin';. I would also recommend setting $cfg['Servers'][$i]['auth_type'] to 'http' and setting $cfg['Servers'][$i]['user'] and $cfg['Servers'][$i]['password'] to empty strings ('').

[Wreck-It]

Thanks for the reply

I've gotten in a even deeper a mess after posting this, so I finally had to remove PHPmyadmin, and my mySQL package. After re-installing mySQL, though, I've decided to use the mySQLadmin utility, and all is well now.

¸I found out the my system did'nt like PHPmyadmin..