nixCraft

Hello,

My configuration:

phpMyAdmin - 2.8.2.4

MySQL - 5.0.22-Debian_0ubuntu6.06.2

I have a database with 15 tables, and I can't browse or Search three of them using phpMyAdmin.

The application which uses the database saves and retrives information ok.

The other tables work ok (Browse, Search, Export)

I am logged in as root.

Any idea why this is happening?



P.S If I select SQL on any of the tables that I can't browse I see:

Error
SQL query:

SELECT label, id
FROM `mysql`.`pma_bookmark`
WHERE dbase = 'dbo_mydb'
AND (

user = 'root'
OR user = ''
)
ORDER BY label

MySQL said:

#1142 - SELECT command denied to user 'admin'@'localhost' for table

'pma_bookmark'

Make sure mbstring PHP extension is installed use yum / up2date/ apt-get command to install the same. Also make sure php (defined in /etc/php.ini / etc/php4/php.ini file) session.save_path is writable by web server.

__________________
Vivek Gite
Linux Evangelist
Be proud RHEL user, and let the world know about your enterprise choices! Join RedHat user group.
Always use CODE tags for posting system output and commands!
Do you run a Linux? Let's face it, you need help