nixCraft Linux Forum

nixCraft

Linux Tech Support Forum

PhpmyAdmin-Can browse/search some tables, but not others

This is a discussion on PhpmyAdmin-Can browse/search some tables, but not others within the Databases servers forums, part of the Mastering Servers category; 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 ...


Go Back   nixCraft Linux Forum > Mastering Servers > Databases servers

Register FAQ Members List Calendar Forgotten your password? Mark Forums Read
  #1 (permalink)  
Old 06-08-2007, 08:58 PM
Junior Member
User
 
Join Date: Jun 2007
My distro: Ubuntu
Posts: 1
Rep Power: 0
blinton25 is on a distinguished road
Default PhpmyAdmin-Can browse/search some tables, but not others

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'
Reply With Quote
Sponsored Links
  #2 (permalink)  
Old 06-09-2007, 12:28 AM
nixcraft's Avatar
Never say die
User
 
Join Date: Jan 2005
Location: BIOS
My distro: Ubuntu
Posts: 1,060
Rep Power: 10
nixcraft has a reputation beyond repute nixcraft has a reputation beyond repute nixcraft has a reputation beyond repute nixcraft has a reputation beyond repute nixcraft has a reputation beyond repute nixcraft has a reputation beyond repute nixcraft has a reputation beyond repute nixcraft has a reputation beyond repute nixcraft has a reputation beyond repute nixcraft has a reputation beyond repute nixcraft has a reputation beyond repute
Default

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 | My personal blog
Linux Evangelist
Play hard stay cool
Reply With Quote
Reply

Bookmarks


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)

 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Similar Threads

Thread Thread Starter Forum Replies Last Post
Not able to browse one particular URL through squid bubloob_13 Proxy Servers 1 10-03-2008 02:54 PM
pattern search with numbers mercuryshipz Coding in General 0 02-15-2008 12:16 AM
PHPMyAdmin Problems JoeDively Coding in General 0 09-21-2007 10:30 PM
phpmyadmin question paul555 Databases servers 2 07-13-2007 09:27 AM
squid problem cannot connect or browse internet raghuram Linux software 2 03-27-2007 10:31 PM


All times are GMT +5.5. The time now is 02:42 AM.


Powered by vBulletin® Version 3.7.4 - Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Search Engine Optimization by vBSEO 3.2.0

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36