PHP4 PHP5 Switching and Mysql Passwords

Problems with the Windows version of XAMPP, questions, comments, and anything related.

PHP4 PHP5 Switching and Mysql Passwords

Postby Rukie » 08. January 2005 22:25

... 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?
A half german american child....with no knowledge of his history :(
Rukie
 
Posts: 14
Joined: 08. January 2005 22:20

Postby Wiedmann » 08. January 2005 22:40

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.
Wiedmann
AF Moderator
 
Posts: 17106
Joined: 01. February 2004 12:38
Location: Stuttgart / Germany

Postby Rukie » 08. January 2005 22:44

my username (root) and password ****** do not work when I switch to php4...
A half german american child....with no knowledge of his history :(
Rukie
 
Posts: 14
Joined: 08. January 2005 22:20

Postby Rukie » 08. January 2005 23:07

do you know how I could just add the user *root* and the corresponding password once apache is setup to use php4?
A half german american child....with no knowledge of his history :(
Rukie
 
Posts: 14
Joined: 08. January 2005 22:20

Postby Wiedmann » 08. January 2005 23:22

Your XAMPP version?
Wiedmann
AF Moderator
 
Posts: 17106
Joined: 01. February 2004 12:38
Location: Stuttgart / Germany

Postby Rukie » 09. January 2005 05:10

uh...
ApacheFriends XAMPP (basic package) version 1.4.10a (win32)
A half german american child....with no knowledge of his history :(
Rukie
 
Posts: 14
Joined: 08. January 2005 22:20

Postby 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 :(
Rukie
 
Posts: 14
Joined: 08. January 2005 22:20

Postby Wiedmann » 09. January 2005 12:23

ApacheFriends XAMPP (basic package) version 1.4.10a (win32)

You should update to version 1.4.11
Wiedmann
AF Moderator
 
Posts: 17106
Joined: 01. February 2004 12:38
Location: Stuttgart / Germany


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 36 guests