I am still with no connection to PHP. I cannot get through the password window in phpMyAdmin Welcome Page.

To try to solve this, I followed this procedure:1. I stopped MySQL (running on port 3307) in the XAMPP control panel.2. I left Apache running (on ports 4499, 8080) in the XAMPP control panel.3. I changed this line in the config.inc.php file: BEFORE $cfg['Servers'][$i]['host'] = '127.0.0.1';

AFTER $cfg['Servers'][$i]['host'] = '127.0.0.1:8080';

4. I deleted the browsing history (except favorites) in browser (Internet Explorer 9).5. I started MySQL (running on port 3307) in the XAMPP control panel.6. I clicked on phpMyAdmin under Tools in XAMPP for Windows 1.8.1 home page http://localhost:8080/xampp/7. phpMyAdmin Welcome Page opens. Username root appears automatically.8. I tried different combinations of username / password: root / blank root / password found in c:/xampp/security/mysqlrootpasswd.txt * blank / blank

I still cannot get a connection to PHP in any case.The command just turns and turns in the background, trying to connect to 127.0.0.1:8080 (I suppose), then stops. The screen never left the phpMyAdmin Welcome Page.I do not know if it is relevant, but, at the same time, in the XAMPP control panel, the Apache server lost its usual assigned ports (4499, 8080) and displayed instead ports like 51041, 51061 or just a single one 51106.

* Under Security section, in XAMPP for Windows 1.8.1 home page, the status is:PhpMyAdmin password login is enabled.In fact, at the beginning of the installation, I tried to create a password for the first time (using http://localhost/security/xamppsecurity.php), and that is when I could not access PHP anymore...

1. I stopped MySQL (running on port 3307) in the XAMPP control panel.2. I left Apache running (on ports 4499, 8080) in the XAMPP control panel.3. I added this line in the config.inc.php file:

$cfg['Servers'][$i]['port'] = '3307';

4. I had already reverted the host line to its original content:

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

5. I started MySQL (running on port 3307) in the XAMPP control panel.6. I clicked on phpMyAdmin under Tools in XAMPP for Windows 1.8.1 home page http://localhost:8080/xampp/7. phpMyAdmin Welcome Page opens. Username root is entered automatically.8. I do not type any password. *9. I click GO.10. I am finally in phpMyAdmin application home page!!!

* I tried also the password included in c:/xampp/security/mysqlrootpasswd.txt, but it did not work. I got this error message: Cannot log in to the MySQL server.

So, since it seems that I have a phpMyAdmin connexion, before going any further, in order to avoid any security issues with my password, I would like to get some advice on how to proceed from now on. What are the next steps?

My goal is to ultimately get to work on a local environment with WordPress.

I paste here my current config.inc.php file. I would like to know what I should change there so everything is secure and consistent.

<?php/* * This is needed for cookie based authentication to encrypt password in * cookie */$cfg['blowfish_secret'] = 'xampp'; /* YOU SHOULD CHANGE THIS FOR A MORE SECURE COOKIE AUTH! */

Fantasia_00 wrote:My goal is to ultimately get to work on a local environment with WordPress.

If this is a local environment and you are the only user on that machine you are safe as long as you don't forward your webserver component ports 8080, 4499, 3307 in your router. your router is your protection from the outside.

If i were you i would next create a new database and a new user for wordpress. The user should have limited permissions on just this single database (best practice).

best wishes,Altrea

We don't provide any support via personal channels like PM, email, Skype, TeamViewer!

Fantasia_00 wrote:May I ask a few more questions, just to be sure? (I am very new into all this...)

Of cause! That's the purpose of this board here

Fantasia_00 wrote:1. Do I need to set or not a personal username and password to access phpMyAdmin? (What is the best practice?)

It is best practice to use one user for global database management (creating, changing and deleting databases and database users) with a very secure password.For each application and database you should create a new user and password. This users should haveas limited as possible permissions on just this single database.

Well, that is best practice for production servers (especially in maybe insecure networks like the internet). On your very own local machine there is not really a security reason to do the same because the security is provided by the fact that your server is not reachable from insecure networks. But because it just costs a minute to create a new user with databse, there is no good reason to don't do that on local development machines too (simply just to accustom you to that behaviour).

Fantasia_00 wrote:2. Do I need to insert or not some generated string for 'blowfish_secret'?

If your local server is not accessible from insecure networks, you don't need to change that secret key

Fantasia_00 wrote:3. Do I need to change or not the 'extension' to mysqli? (It is currently mysql)

Well, you don't need to change that yet, because phpmyadmin works very well with the old mysql functions.But these old functions will be marked as deprecated with the next minor PHP release 5.5 and will be removed in PHP 5.6 or PHP 6.Maybe it is not a bad idea to work with the new mysqli functions right now. It is up to you.

Fantasia_00 wrote:4. Please explain your comment (so I do not accidentally do this mistake):"as long as you don't forward your webserver component ports 8080, 4499, 3307 in your router".

As long as your XAMPP Apache/MySQL is not reachable on your public IP-Address, you will be safe.I don't know what the standard is for your contries internet service provider. Here in Germany most of the private persons are using an ADSL Router/Modem to connect to the internet.These routers have firewalls with access rules which protects the pc from unwanted requests coming from the outside. These requests will be blocked by this router and not sended through it to the pc.But users for example can configure their routers to let for requests pass through for specific ports. Tne requests will be forwarded by the router from the public ip to the pcs private ip.

best wishes,Altrea

We don't provide any support via personal channels like PM, email, Skype, TeamViewer!