Jump to content

Connection/User privileges problem - need help fast please


SaturdayNightSpecial

Recommended Posts

Hello,

 

i would greatly appreciate any help I could get as soon as possible, I've got to go to a trade show tomorrow to pitch this new site and I can't get my local server set up.

 

I just did a fresh download of xammp, the php ver. is 3.2.0.1 with MySql ver. 5.1.37 running on XP.  I'm very new to site design and especially php/mysql but i did get it running fine on my desktop.  With this new installation I never get a login screen.  It runs fine on the default root@localhost login but I can't get it to work with an additional user privilege of root@locahost using the password that my site uses on the desktop.  I can change the host on the default root username to 127.0.0.1 like I have it on the desktop and it says it was saved but then i get the error message "Access denied for user root@localhost (using password "No")  and it never displays a login screen.  i then have to uninstall and reinstall xammp to take another shot at it but I'm running out of time.  There's no "Exit" icon in the top left beside the "home" button either.  I'm not sure if there was a setting that I did on the desktop install to get the login screen or not but if there was i don't remember what it was.

 

Again, any help would be greatly appreciated.

Link to comment
Share on other sites

I added a new user in phpMyadmin with the host set to 127.0.0.1 and saving a copy of the old default root@localhost  I then edited the root@localhost to have a password.  Then I used the config.ini flie from my desktop which already had authentication turned on and now i get the login page.  It still won't login without a password even though the "AllowNoPassword" in the config file is set to true but i can deal with that problem since i always logging in with the password anyway.

 

Unfortunately, I'm still having problems.  The site files that run fine on my desktop are doing some weird stuff on this new install on the laptop.  I know it's making the database connection because some of the information from the database is displaying (mostly photos) but the text from the database is not displaying.  I'm also getting a syntax error on one of the pages.  It's one of those errors that says the problem is on a line that is higher than the code actually goes to.  In other words, the code goes to line 621 but it's reporting syntax error expecting $end on line 626.  I've run into this before but I can't remember what the fix was.  Any ideas?

Link to comment
Share on other sites

For those who may be having the same problem in the future this turned out to be a setting in the php.ini file.  There were some short tags in my code so the answer is to go into the php.ini and look for short_open_tag and turn it "On".  Look carefully in the php.ini file as there are two references to short_open_tag in there and the second one is the one that needs to be changed.

 

As far as the login page not showing up on phpmyadmin I can't give much direction there.  I just copied the config.inc file in the phpmyadmin folder from my desktop that I knew was working correctly.  I'm sure it has something to do with authentication but even when I put the authentication in the new download of xammp it still didn't work but my old file from the desktop did work.

Link to comment
Share on other sites

This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.