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?
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?
http://www.tenon.com/support/itools7/phpMyAdmin-howto.shtml
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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?
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?
ASKER
Stuck here
$cfg['Servers'][$i]['passw ord'] = '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]['passw ord'] = ''; // MySQL password (only needed
$cfg['Servers'][$i]['passw
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_
$cfg['Servers'][$i]['user'
$cfg['Servers'][$i]['passw
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
$cfg['Servers'][$i]['auth_
// 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.