Just setup a private mysql server on RHES 5.1. I installed phpmyadmin on a different server (RHES 4) on the same LAN which I have public access to. Phpmyadmin is finding the database, and everything seems ok, however, when I login as the root user, There is no option to change privileges, or drop databases.
I am currently using phpmyadmin on another machine, which the database is on localhost, and the root use has access to drop, change privilegs, etc.
I also setup my.cnf to use a separate partition for mysql, but I dont think that has anything to do with it.
# Default to using old password format for compatibility with mysql 3.x
# clients (those using the mysqlclient10 compatibility package).
Another interesting thing is that "mysql -V" reports:
mysql Ver 14.12 Distrib 5.0.22, for redhat-linux-gnu (i686) using readline 5.0
$rpm -qa | grep -i mysql
however, phpmyadmin says
# Server version: 3.23.32
# Protocol version: 10
Anyone know what I can do to allow root user access to modify privileges?
Thanks very much!!