Page 1 of 1

PHP4 PHP5 Switching and Mysql Passwords

PostPosted: 08. January 2005 22:25
by Rukie
... alright.. I currently run php5... but I wish to change to php4..
I shutdown xampp, run the switch, and change to php4
I proceed to start xampp again.
Once started, I am no longer to access my Mysql.
The mysql password and username changes from
Root
******
in php5
to

Admin
(no password)
in php4

I cannot seem to change or add root and a password with ****** to it,
how can I do this from command prompt?

PostPosted: 08. January 2005 22:40
by Wiedmann
The mysql password and username changes from
Root / ****** in php5
to
Admin / (no password)in php4

That's not possible...

"php-switch.bat" makes no changes to MySQL.

PostPosted: 08. January 2005 22:44
by Rukie
my username (root) and password ****** do not work when I switch to php4...

PostPosted: 08. January 2005 23:07
by Rukie
do you know how I could just add the user *root* and the corresponding password once apache is setup to use php4?

PostPosted: 08. January 2005 23:22
by Wiedmann
Your XAMPP version?

PostPosted: 09. January 2005 05:10
by Rukie
uh...
ApacheFriends XAMPP (basic package) version 1.4.10a (win32)

PostPosted: 09. January 2005 05:20
by Rukie
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..)

PostPosted: 09. January 2005 12:23
by Wiedmann
ApacheFriends XAMPP (basic package) version 1.4.10a (win32)

You should update to version 1.4.11