phpmyadmin

[snuk]

hi everyone, i have a problem with settings config.ini.php,
if iam connecting from phpmyadmin site
there is no privilege to create new database, if i connect
to my sql from console it is ok

 

[Netelligent]

You need to have all the proper settings in config.ini.php

If you're using 'config' as your 'auth_type', then you should have:
$cfg['Servers'][$i]['controluser'] = '';
$cfg['Servers'][$i]['controlpass'] = '';
$cfg['Servers'][$i]['auth_type'] = 'config';
$cfg['Servers'][$i]['user'] = 'super_user;
$cfg['Servers'][$i]['password'] = 'your_pass';
$cfg['Servers'][$i]['only_db'] = '';

If you're using 'cookie' or 'http' or 'advanced', you need ot have:
$cfg['Servers'][$i]['controluser'] = 'super_user';
$cfg['Servers'][$i]['controlpass'] = 'your_pass';
$cfg['Servers'][$i]['auth_type'] = 'cookie';
$cfg['Servers'][$i]['user'] = '';
$cfg['Servers'][$i]['password'] = '';
$cfg['Servers'][$i]['only_db'] = '';

Right now, you're probably entering as a normal user if you're settings aren't properly configured. While you logon as a different user from the console.

Another thing to check is if you have in your 'user' table of the 'mysql' database 2 same users with different passwords/access rights?

Also make sure that you're using the latest version (at least 2.3)

Let me know!

.M

 

[snuk]

Iam using 'config' & username and pass is same like in
user database in mysql, still no privilege to create databaze through phpMyAdmin

 

[Netelligent]

Hmmm what option do you see on your main phpMyAdmin page then? Can you post your config file options?

You made sure there are no duplicate usernames with different hosts/passwords in your DB and USER tables on mysql?

 

[snuk]

yes i can, can U giveme your mail adress?

 

[Netelligent]

send it to temp@netelligent.ca

While you're at it, send me the contents of your USER and DB tables of your MYSQL DB.

 

[snuk]

OK, I will send U tonight, iam in da work now
thanx