incutonez wrote:Ok, I did that, but now I have two root users when I log in with phpmyadmin. One is for the localhost and the other is for any host, is this alright?
incutonez wrote:And when I'm using my php connect statement, do I use "http://ipaddress" or just "ipaddress" for the host name? Also, do I include the port number with it?
Don't add the http:// bit only use the IP address and the port number if you have changed it from the default port 3306 or use the domain name instead of the IP address, with or without the port number as explained above.
Some useful examples can be found here to help with most of your questions:http://php.net/manual/en/function.mysql-connect.php
Also there are some comments included re the Windows Host file usage.
(Leave in place as the first entry in the Hosts file 127.0.0.1 localhost
You can disable IPv6 in the Hosts file - ::1 localhost - if required using the xampp_setup.bat file).
Not sure if you need to add your IP to the Hosts file, I have never had the need to add it except for the Apache web server when testing sites locally, in the form:
BTW super user root should not be applied as an individual database user, rather you should define a separate user/pass combo for each individual database you create.
This has an added security advantage in that if an individual user logs into their associated database in phpMyAdmin then that user will see that associated database only.
On the other hand if you assign the super user root to your databases then anyone logging in via phpMyAdmin can see and manipulate all databases in your system - not very secure as you can imagine as only you as the server admin should be the super user root.
If you have problems with all this and you get error messages, then it would help to troubleshoot if you paste the errors here.
I hope this has been of more help for you to be able to move forward.