Link to home
Start Free TrialLog in
Avatar of Donkadelics
Donkadelics

asked on

phpMyAdmin error

Whenever I'm at the main page, I always get this error:

The $cfg['PmaAbsoluteUri'] directive MUST be set in your configuration file!
Your configuration file contains settings (root with no password) that correspond to the default MySQL privileged account. Your MySQL server is running with this default, is open to intrusion, and you really should fix this security hole.
The mbstring PHP extension was not found and you seem to be using multibyte charset. Without mbstring extension phpMyAdmin is unable to split strings correctly and it may result in unexpected results.

How can I fix this?
Avatar of ldbkutty
ldbkutty
Flag of India image

ASKER CERTIFIED SOLUTION
Avatar of ldbkutty
ldbkutty
Flag of India image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Donkadelics
Donkadelics

ASKER

I followed the steps but only get rid of the first part.

Your configuration file contains settings (root with no password) that correspond to the default MySQL privileged account. Your MySQL server is running with this default, is open to intrusion, and you really should fix this security hole.
The mbstring PHP extension was not found and you seem to be using multibyte charset. Without mbstring extension phpMyAdmin is unable to split strings correctly and it may result in unexpected results.

There are still some more things to do.
Went to the server settings part in the config.inc.php file
Where do I put in the username and the password I wanted so that it will ask for this whenever phpMyAdmin starts?
Stuck here

$cfg['Servers'][$i]['password'] = 'myRoot'; // MySQL password

When i tried to change this, the page went blank and nothing came up at all until i remove it.
Currently this is mine.

$cfg['Servers'][$i]['auth_type']     = 'config';    // Authentication method (config, http or cookie based)?
$cfg['Servers'][$i]['user']          = 'root';      // MySQL user
$cfg['Servers'][$i]['password']      = '';          // MySQL password (only needed
Make 'cookie' based authentication (not config) :

$cfg['Servers'][$i]['auth_type']     = 'cookie';    // Authentication method (config, http or cookie based)?

// if 'config' option is selected, you have to give the "username" and "password" in the config.inc.php file
Donkadelics, I will post the "password" related posts in your other thread.