by Rukie » 09. January 2005 05:20
I just found "(3) MySQL starts with standard values for the user id and the password. The preset
user id is "root", the password is "" (= no password). To access MySQL via PHP
with the preset values, you'll have to use the following syntax:
mysql_connect("localhost","root","");
If you want to set a password for MySQL access, please use of mysqladmin.
To set the passwort "secret" for the user "root", type the following:
C:\xampp\mysql\bin\mysqladmin -u root password secret
After changing the password you'll have to reconfigure PHPMyAdmin to use the
new password, otherwise it won't be able to access the databases. To do that,
open the file config.inc.php in \xampp\phpmyadmin\ and edit the
following lines:
$cfg['Servers'][$i]['user'] = 'root'; // MySQL user
$cfg['Servers'][$i]['auth_type'] = 'http'; // HTTP authentificate
So first the 'root' password is queried by the MySQL server, before PHPMyAdmin
may access.
"
This was in the readme.. I never noticed it before... I can not seem to locate the second line in the config.in.php file...... (even tho this is phpmyadmin, its still something I may need to update..)
A half german american child....with no knowledge of his history