There's no such thing as a stupid question, but they're the easiest to answer.
JoinTour
Login
 
Tag Cloud
black screen blue screen blue screen of death boot computer connection crash css dell display driver drivers error excel firefox firefox 3 game hard drive internet internet explorer itunes laptop lcd linux malware monitor network networking nvidia outlook outlook 2003 outlook express partition password printer problem ram router slow software sound sprtcmd.exe trojan usb video virus vista windows windows xp wireless
Software Development
Search
Search in:
 
Advanced Search
Tech Support Guy Forums > Software & Hardware > Software Development >
[Solved] mysql/phpmyadmin database connection problems


HELLO AND WELCOME! Before you can post your question, you'll have to register -- it's completely free! Click here to join today! We highly recommend that you print a copy of our Guide for New Members. Enjoy!

Closed Thread
 
Thread Tools
downtime's Avatar
Senior Member with 690 posts.
 
Join Date: Oct 2002
Location: Quebec
21-May-2004, 09:20 AM #1
[Solved] mysql/phpmyadmin database connection problems
I've installed and configured Apache 2.0.49 and mysql 4.0.18, configured for php, and configured the database using phpmyadmin 4.3.77 on Windows Server 2003 Enterprise. I'm using a linksys DL-604 on a lan.

When I connect to phpmyadmin on the server, there's no problem. When I connect to phpmyadmin from my work machine with xp pro, either with Mozilla, or IE, I can log in, but can't do anything once there. I also get access denied when I'm trying to set up the mysql database connection in Dreamweaver. Passwords are set, and I'm using them. I've made certain that the passwords match. I can only see the default test database connection as available in Dreamweaver. It's StudioMX I'm using, but not StudioMX 2004. Even though I've created the database, the user, and password, I'm denied access, but as I said, the test database is accessible. That seems to narrow it down to being a mysql problem.
Has anyone experienced this before?
Thanks.
deuce868's Avatar
Senior Member with 638 posts.
 
Join Date: Nov 2000
Location: MI
21-May-2004, 11:03 AM #2
there are pemissions not only as to who can connect, but where they can connect from. Look into the mysql permissions for the host setting. That tells you what IPs a user can connect from. My guess is that you don't have permissions to connect from any machine other than the one that works.
__________________
www.ricksweb.info
www.2webheads.com
Quote:
Techies just think a little differently...at least that's what they keep telling me.
downtime's Avatar
Senior Member with 690 posts.
 
Join Date: Oct 2002
Location: Quebec
22-May-2004, 12:29 PM #3
Thanks, deuce868. It was what you suggested, though it was how I set it in phpmyadmin. I had configured ['PmaAbsoluteUri'] in config.inc.php as localhost instead of the server address, so that gave access to the databases created through it in mysql only locally.
Closed Thread

THIS THREAD HAS EXPIRED.
Are you having the same problem? We have volunteers ready to answer your question, but first you'll have to join for free. Need help getting started? Check out our Welcome Guide.


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
WELCOME TO TECH SUPPORT GUY! Are you looking for the solution to your computer problem? Join our site today to ask your question -- for free! Our site is run completely by volunteers who help people like you solve computer problems. See our Welcome Guide to get started.



Thread Tools


You Are Using:
Server ID
Advertisements do not imply our endorsement of that product or service.
All times are GMT -4. The time now is 07:12 AM.
Copyright © 1996 - 2008 TechGuy, Inc. All rights reserved.
Powered by vBulletin, Copyright © 2000 - 2008, Jelsoft Enterprises Ltd.
Search Engine Optimization by vBSEO 3.1.0
Powered by Cermak Technologies, Inc.