TalkPHP
 
 
Account Login
Latest Articles
» The basic usage of PHPTAL, a XML/XHTML template library for PHP
» Vulnerable methods and the areas they are commonly trusted in.
» Simple way to protect a form from bot
» The Basics On: How Session Stealing Works
» How to keep your forms from double posting data
IRC Channel
IRC Speech Bubble Join the friendly bunch on IRC...
(#TalkPHP on Freenode)

...Also available via a web interface.

See this thread for information on the TalkPHP Free Hugs Initiative™. Subject to availability.
Associates
Associates
CSS Tutorials
Reply
 
LinkBack Thread Tools Search this Thread Display Modes
Old 01-03-2008, 01:06 PM   #1 (permalink)
The Acquainted
 
EyeDentify's Avatar
 
Join Date: Nov 2007
Location: Sweden
Posts: 106
Thanks: 13
EyeDentify is on a distinguished road
Big Grin Error in connecting to MySQL via PHP - SOLVED

Hi all.

I got a problem wich eludes me, i have tried to come up with solutions and failed. Thatīs why i turn to you.

Anyway to make a long story short, i installed a webserver (Aprelium Abyss Webserver) and PHP 5.2.5 wich run excelent and fine.

The problem started when i wanted MySQL database integration.

I installed MySQL 5.0.45 for windows on the same machine as the webserver. I got MySQL configured and changed the "root" users password. So far so good.

Now i can not figure out why i can connect to the MySQL server with SQLyog using the "root" user and his password and work with databases and tables just fine, but not via PHP with the standard MySQL connection proceedures with connecting with login credentials and choosing a database. and then when i run SQL query this is whats comes out:

Code:
Could not perform MySQL query: Access denied for user 'ODBC'@'localhost' (using password: NO)
as it been a while since i worked with a server "at home" i thought that it was permission related so with the "root" user logged in to SQLyog i created a regular user named "mysite" and gave it limited permissions so it could read and list and manipulate tables to some degree. but that donīt seem to have worked either.

It may be a simple overlook on my part. i have checked that the extensions for php_mysql.dll gets loaded and are in the right location.

Would be much aprechiated for help in this mather.

Is there any other info you need i will suply it when asked.

/EyeDentify

Edit: Problem solved.
Seems i wasenīt using my brain and a simple typo did hinder me from connecting. so while i get my foot out of my mouth i wish you all a nice weekend.
__________________
Of course the whole point of a doomsday machine, would have been lost if you keep it a secret.

Last edited by EyeDentify : 01-03-2008 at 11:25 PM.
EyeDentify is offline  
Reply With Quote
Reply



Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


All times are GMT. The time now is 02:28 PM.

 
     

Powered by vBulletin® Version 3.6.8
Copyright ©2000 - 2013, Jelsoft Enterprises Ltd.
Search Engine Optimization by vBSEO 3.1.0
Inactive Reminders By Icora Web Design