I have been using an earlier version of Xamp for a while. Recently I installed 1.8 on my Win7 64 bit computer.
Installation went well, and I could access MySQL from the control panel and run php. So I set up a site in htdocs in the Xampp directory of my C drive. I then went on line to the server and downloaded my files from the net with no problems. I then accessed my on line database and downloaded it in MySQL format and dumped it into the new MySQL using the PhpMyinfo import / export method. I set the passwords and access rights to be identical to the ones that I had on my old system. I made no changes to any of the "ini" files, assuming that the default ones would work, like they did when I installed earlier versions of Xampp. The data files are all on my computer and can be viewed.
I now have problems.
In my earlier version, I could access mysql from the control panel and programatically using a username other than the root username. Now I cannot. Only the root password works. Other users that I have set up cannot connect at all. My code has not changed, and as far as I can see I have the same usernames and passwords. Do I need to make any changes to the standard ini files? Is it normal for only the root user to be able to access via the control panel in 1.8? I was always told that to use the root for a live site was dangerous as this would be bad security.
Here is the connection script that I use as an include file:
<?php
# FileName="Connection_php_mysql.htm"
# Type="MYSQL"
# HTTP="true"
$hostname_conshipsviewer = "localhost";
$database_conshipsviewer = "databasename"; /*not the root user */
$username_conshipsviewer = "username";
$password_conshipsviewer = "xxxxxxxxxxxxxxx";
$conshipsviewer = mysql_pconnect($hostname_conshipsviewer, $username_conshipsviewer, $password_conshipsviewer) or trigger_error(mysql_error(),E_USER_ERROR);
?>
It works currently on two versions of Xampp but not with 1.8
Can anyone help please?