root password in config.inc.php and in MYSQL databases
Posted by: norman_mm (---.inter.net.il)
Date: May 25, 2014 09:21AM

Hi:
I just installed WAMP 2.2 ( 32 bit) in my Winows 7 Ultimate computer (64 bit).I installed the following component versions:
Apache: 2.2.22
PHP: 5.4.3
MySQL 5.5.24

Following the advice in phpmyadmin I changed the root password from null to some value . Immediately after that phpadmin could not connect to MySQL server. After reading a bit about this problem I changed the password in config.inc.php and now everything things back to work.
I just would like to understand what's the meaning of the password in the above file and the root password of each database.
If I create a new database, can it have a null password? or some other different password from that in the file?
In the database that I have currently , there are 3 different "root" users:
user: root host: 127.0.1
user: root :: 1
user: root localhost
What's the meaning of each one?
(I think the problem occurred when i changed the password to root::1 )
Thanks,
Norman

Options: ReplyQuote
Re: root password in config.inc.php and in MYSQL databases
Posted by: Otomatic (Moderator)
Date: May 25, 2014 10:15AM

Hi,

> If I create a new database
The creation of the database and the use are completely independent of the management of passwords.

> user: root host: 127.0.0.1
For IPv4
> user: root :: 1
For IPv6
> user: root localhost
For ServerName

---------------------------------------------------------------
Documentation Apache - Documentation PHP - Documentation MySQL - Wampserver install files & addons

Options: ReplyQuote
Re: root password in config.inc.php and in MYSQL databases
Posted by: norman_mm (---.inter.net.il)
Date: May 25, 2014 09:48PM

Thanks. I just perused through the documentation in www.phpmyadmin.net and things are becoming more clear.

Options: ReplyQuote


Sorry, only registered users may post in this forum.