Code Newbie
News     Forums     Search     Members     Sign Up    

My Code Newbie
Username

Password

Articles/Snippets
ASP Classic
ASP.NET
C
C#
C++
HTML / CSS
Java
Javascript
Linux / BSD
Perl
PHP
Python
Ruby
SQL
VB 6
VB.NET

C.N. Friends
  Planet Rome

Link to Us!
Code Newbie
  Code Newbie
    forums
Old 01-10-2003, 05:35 AM   #1 (permalink)
trevor
Code Monkey
 
Join Date: Jan 2003
Location: Canada
Posts: 91
trevor is on a distinguished road
permissions in MySQL

hey,

I set up a MySQL database on my Slackware 8.1 box which stores user information such as username, password and email. I have a page where you enter your username and password and it authenticates it on the MySQL database and if authentic, it sends you to the main page.
The problem is that whenever I have the code to access the database the page wont load at all. No html or PHP. If I remove the script at the top that accesses the database it loads fine but doesn't do nothing.

I think it might be a problem with permissions. Do I have to set up anything special to allow a PHP script to access the database?

thanks

-Trevor :rock:
trevor is offline   Reply With Quote
Old 01-10-2003, 05:50 AM   #2 (permalink)
trevor
Code Monkey
 
Join Date: Jan 2003
Location: Canada
Posts: 91
trevor is on a distinguished road
damn im dumb.....and smart.

I solved it, within seconds of posting.

the guy that gave me the code took out the username and password so I ASSUMED that it had to be blank.

duh.

sorry guys,

Trevor
trevor is offline   Reply With Quote
Old 01-10-2003, 06:22 AM   #3 (permalink)
Ilya020
Techno Rat
 
Ilya020's Avatar
 
Join Date: Jan 2003
Location: San Diego
Posts: 559
Ilya020 is on a distinguished road
Send a message via AIM to Ilya020
Agh......I love it when the poster solves the problem.


Keep it up! :rock:

Ilya
__________________
> SELECT * FROM users WHERE clue > 0
0 rows returned
Ilya020 is offline   Reply With Quote
Old 01-10-2003, 01:47 PM   #4 (permalink)
revolution
Legend in my own mind
 
revolution's Avatar
 
Join Date: May 2002
Location: florida
Posts: 618
revolution is on a distinguished road
Send a message via AIM to revolution
Quote:
Originally posted by trevor

the guy that gave me the code took out the username and password so I ASSUMED that it had to be blank.

when you showed it to me in IRC i figured you took them out for security reasons...opps
__________________
Is it me or does the word abbreviation seem a little long?


registered user #193524 with the Linux Counter,
http://counter.li.org
revolution is offline   Reply With Quote
Reply

Bookmarks

Thread Tools
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

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
MySQL Views sde PHP 1 05-01-2003 12:06 PM
and on to mysql .. sde Linux / BSD / OS X 2 01-18-2003 07:39 PM
yeah...i didn't fix it.....mySQL trouble (permissions?) trevor PHP 7 01-10-2003 08:29 PM


All times are GMT -8. The time now is 12:16 AM.


Powered by vBulletin® Version 3.7.0
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Search Engine Optimization by vBSEO 3.0.0 RC8





Copyright © 2000-2008, Milano Interactive
Web Hosting provided by Portal 360 Web Hosting