phpMyAdmin No Privileges

[Dr.Death]

Hi, I have some problem with mysql and phpmyadmin, I cant create DB with phpmyadmin, it show me "No Privileges", I changed the privilege to full from WHM phpMyAdmin. and still the same.

I tried to install phpBB and joomla, i create the DataBase from the cpanel and asign a user to it,
But no connection to the DB. i tried also with the root user and password but no chance.

From the command line i can connect to the DB "mysql -u -p DB", but not from the install.php file for phpBB and joomla.

Server info:

WHM 10.8.0 cPanel 10.9.0-S48
FreeBSD 6.1-RELEASE i386 - WHM X v3.1.0

mysql error message:

Warning: mysql_connect() [function.mysql-connect]: Client does not support authentication protocol requested by server; consider upgrading MySQL client in /usr/home/user/public_html/phpbb/db/mysql4.php on line 48

Warning: mysql_error(): supplied argument is not a valid MySQL-Link resource in /usr/home/user/public_html/phpbb/db/mysql4.php on line 330

Warning: mysql_errno(): supplied argument is not a valid MySQL-Link resource in /usr/home/user/public_html/phpbb/db/mysql4.php on line 331
phpBB : Critical Error

Could not connect to the database

phpMyAdmin message:

Create new database:
No Privileges

sorry for my bad English.

Thankx

[Manuel_accu]

Which version of MySQL are you using?


Also provide php version and my.cnf configuration details.

It seems you need to grant some access to related databases.

Thanks,

[Dr.Death]

Hi manuel,

MySQL version 4.1.21
PHP version 4.4.4
phpMyAdmin 2.9.0.2

my.cnf :

[mysqld]
set-variable = max_connections=500
safe-show-database

by defual Global privileges was set to "USAGE", Grant not enabled.
I enable all Global privileges options "Data, Structure, Administration" and Grant.

Still the same error messages appear.

Thankx

[Dr.Death]

I fixed the problem, the problem was that MySQL 4.1 and 5.0 require a different password exchange protocol than PHP prior to 5.x uses.
here is mysql doc. : http://dev.mysql.com/doc/refman/5.0/en/old-client.html

i add this line to /etc/my.cnf:

old-passwords = 1


also upgrade Mysql to V5.0.18

Its work fine now, thankx

[Dr.Death]

but still i need to add Grant privilege manually to the users.

any idea how to make it set by defualt !