Proplem with phpmyadmin

[Derick]

I got MySQL working and installed phpMyAdmin. Started the database (mysqlstart)
and logged in as root (mysql -u root -p  ...ect.).
However, when I start up phpMyAdmin and navigate to the front page I get:
"MySQL 3.2.32-log running on localhost as root@localhost",
which seems to be ok, but when I click on the Privileges link, I get:
"User overview
No Priviliges"

And whenever I attempt to perform any finction in phpMyAdmin, it fails, giving me a "You have an error in your SQL syntax" - I'm guessing because I don't have the correct priviliges, even though it seems to understant that I'm logged in as root..

What am I doing wrong?

Thanx!

p.s. config.inc.php has the lines:

$cfg["Servers"][$i]['user']='root'
$cfg["Servers"][$i]['password']='xxxx'

[totaln00b]

What version of phpmyadmin are you using? I'm using version 2.5.3, and it works fine, but it too says "User Overview, no privileges"- so I'm guessing that that's not your problem.

When you say that performing any function gives you an SQL error, can you give an example of what you're trying to do? Can you see any databases in the drop down list? Can you browse them or add new rows?

Jo

[Guest]

What version of phpmyadmin are you using? I'm using version 2.5.3, and it works fine, but it too says "User Overview, no privileges"- so I'm guessing that that's not your problem.

When you say that performing any function gives you an SQL error, can you give an example of what you're trying to do? Can you see any databases in the drop down list? Can you browse them or add new rows?

Jo

Well, it says I'm using 2.6.0-rc1

I can see the databases, but if I select one of them from the pull-down
(a database called test1 in this example), I get an error:

"
Error

Sql-query

Show table status from 'test1'

MySQL said:

#1064 you have an error in  your SQL syntax near 'TABLE STATUS FROM 'test1';' at line 1

"

[totaln00b]

Hmm,

I'm casting around for solutions here, but it might be that the most recent versions of phpmyadmin aren't designed to work properly with the older versions of php/apache/mysql. I would try starting with a version that's proven to work, ie 2.5.3 and move up from there incrementally if that solves your problem.

Hope this helps

Jo

[Derick]

Hmm,

I'm casting around for solutions here, but it might be that the most recent versions of phpmyadmin aren't designed to work properly with the older versions of php/apache/mysql. I would try starting with a version that's proven to work, ie 2.5.3 and move up from there incrementally if that solves your problem.

Hope this helps

Jo

I downloaded and installed 2.5.3 .. and it works!!

Thanx!