MySQL username password

[neont]

Hi guys. Any help will be much appreciated.

 

I am trying to make use of the 'dataface' application. In doing so I need to have a password in order to access the MySQL database. As it stands, I have no password as a line of code in my config.ini.php file states 'allow no password'.

 

However, trying to alter this code gives me errors when loading the my localhost/phpmyadmin page.

 

/* Authentication type and info */

$cfg['Servers'][$i]['auth_type']            = 'config';

$cfg['Servers'][$i]['user']                = 'root';

$cfg['Servers'][$i]['password']            = '';

$cfg['Servers'][$i]['AllowNoPassword']      = true;  //This is what i remove and simply type a password..

 

<<<<<>>>>>

 

MSQL VERSION: # Server version: 5.1.41

 

PHP: 3.2.4

 

APACHE: 2.2.14

 

mysql said: #1045 - Access denied for user 'root'@'localhost' (using password: YES)

 

 

<<<<<>>>>>

 

 

Im not sure if this is of any particular significance...

 

/* Server parameters */

$cfg['Servers'][$i]['host']            = 'localhost';

$cfg['Servers'][$i]['connect_type']    = 'tcp';

$cfg['Servers'][$i]['compress']        = false;

 

/* Select mysqli if your server has it */

$cfg['Servers'][$i]['extension'] = 'mysqli';

 

/* User for advanced features */

$cfg['Servers'][$i]['controluser'] = 'root';

$cfg['Servers'][$i]['controlpass'] = '';

 

 

[trq]

What exactly is your question?

[neont]

 

Basically I am currently ultilising phpMyadmin with no password.

 

I would like to be able initiate a password, but i'm not sure how to structure the script.

[Scanjo]

This is quoted from the tutorial at http://www.reg.ca/faq/PhpMyAdminTutorial.html

 

"...a dialog box will prompt you for a username and password. This will be the username and password given you when we set  it up for you."

 

According to this, I would say it's not a simple matter of changing a script. You need to talk to whomever set it up for you and get it changed.  If there is no password setup, then how would the program know if the password you logged in with was right or not?