28, May 2012

Help! ,Newbee cant get Login right - webmaster forum

 
Webdigity webmaster forums
[ Home | Help | Search | Forum's Shop | Archive | Login | Register | Webmaster Directory ]
Webdigity Webmaster Forums  >  Web Development  >  PhP  >  PHP classes @finalwebsites.com  >  Access_user Class (Moderator: Olaf)
Topic: Help! ,Newbee cant get Login right
« previous next »
Pages: [1] Print

Author Topic: Help! ,Newbee cant get Login right  (Read 2430 times)
Total Zero
*
Posts: 5
34 credits
Members referred : 0


« on: Jul 29, 2006, 02:19:09 am »

I recently downloaded Access_user Class version 1.86

as a real newbee, the first Installation instruction:-Use the "users_table.sql" file to create your MySQL table. I do not know how do i use this file to as told, where do i start.

when  try to Run the register.php in my browser to enter the first user into mr database, i get this warning:

Warning: mysql_connect(): Access denied for user 'user'@'localhost' (using password: YES) in /home/myusername/public_html/classes/access_user/access_user_class.php on line 117

Warning: mysql_select_db(): Access denied for user 'myusername'@'localhost' (using password: NO) in /home/myusername/public_html/classes/access_user/access_user_class.php on line 118

Warning: mysql_select_db(): A link to the server could not be established in /home/myusername/public_html/classes/access_user/access_user_class.php on line 118

Warning: mysql_query(): Access denied for user 'myusername'@'localhost' (using password: NO) in /home/myusername/public_html/classes/access_user/access_user_class.php on line 89

Warning: mysql_query(): A link to the server could not be established in /home/myusername/public_html/classes/access_user/access_user_class.php on line 89
Access denied for user 'myusername'@'localhost' (using password: NO)

Can anyone tell me what do these mean and how do i fix the problem? Building websites is now the only thing i do, so i put all my time in it, its just that i do not know how to reach where i want to, can anyone wlk me though?
I crack Photoshop!
*
Posts: 3
28 credits
Members referred : 0


« Reply #1 on: Jul 29, 2006, 05:59:14 am »

Hey, I am going to attempt to answer your questions but a PHP book with MYSQL or some other MYSQL resource would probably be the best source

Use the "users_table.sql" file to create your MySQL table. I do not know how do i use this file to as told, where do i start

This means you need to import the 'user_table' table into your database.  There are different ways of doing this depending on how your setup is but if you have a server and it has a control panel, you can go into mysql databases and create a database where you can import the 'user_table'

Now all the other errors are a result of not editing the code with the proper MYSQL information.  To access a MYSQL database the script needs to know where is the database (the host), the database name, the user name that has access to that database, and the password.  In the db_config file you can set all of these but your MYSQL server needs to know all of these as well so you need to set them server side by either using the control panel like I mentioned above or by command line.
Moderator
Community Supporter ?
Jedai Sword Master
*****
Gender: Male
Posts: 6691
34714 credits
Members referred : 374


It's time to use PHP5!


« Reply #2 on: Jul 29, 2006, 10:18:09 am »

Danke PsychoZwei!

@ceaser,

Right you have to know a little bit about php and Mysql to start with a member system. In fact first you have to know what is a database connection, results, arrays, headers...

By the way where do you got version 1.86? the current version in 1.90...

Total Zero
*
Posts: 5
34 credits
Members referred : 0


« Reply #3 on: Jul 30, 2006, 04:14:13 pm »

Hey, I am going to attempt to answer your questions but a PHP book with MYSQL or some other MYSQL resource would probably be the best source

Use the "users_table.sql" file to create your MySQL table. I do not know how do i use this file to as told, where do i start

This means you need to import the 'user_table' table into your database.  There are different ways of doing this depending on how your setup is but if you have a server and it has a control panel, you can go into mysql databases and create a database where you can import the 'user_table'

Now all the other errors are a result of not editing the code with the proper MYSQL information.  To access a MYSQL database the script needs to know where is the database (the host), the database name, the user name that has access to that database, and the password.  In the db_config file you can set all of these but your MYSQL server needs to know all of these as well so you need to set them server side by either using the control panel like I mentioned above or by command line.


this is the message i get;

SELECT command denied to user 'maniicom'@'localhost' for table 'users'

Thanks for your input
I am a metal monkey!
Administrator
Community Supporter ?
Jedai Sword Master
*****
Gender: Male
Posts: 5799
46391 credits
Members referred : 3



« Reply #4 on: Jul 30, 2006, 04:18:09 pm »

Hey, I am going to attempt to answer your questions but a PHP book with MYSQL or some other MYSQL resource would probably be the best source

Use the "users_table.sql" file to create your MySQL table. I do not know how do i use this file to as told, where do i start

This means you need to import the 'user_table' table into your database.  There are different ways of doing this depending on how your setup is but if you have a server and it has a control panel, you can go into mysql databases and create a database where you can import the 'user_table'

Now all the other errors are a result of not editing the code with the proper MYSQL information.  To access a MYSQL database the script needs to know where is the database (the host), the database name, the user name that has access to that database, and the password.  In the db_config file you can set all of these but your MYSQL server needs to know all of these as well so you need to set them server side by either using the control panel like I mentioned above or by command line.


this is the message i get;

SELECT command denied to user 'maniicom'@'localhost' for table 'users'

Thanks for your input

This is not a problem of the class, it is a access problem (you have not setup the login info for mysql)

Trial and Error my two best teachers Cool
Join us @ facebook or twitter

Last blog : Butterfly Marketing 2.0
Total Zero
*
Posts: 5
34 credits
Members referred : 0


« Reply #5 on: Aug 01, 2006, 06:34:03 am »

very well, I can see the light just how, but just how do i setup the login info for mysql ? I feel very dumb since this sound too easy to even to me, its just that i dont know.
Moderator
Community Supporter ?
Jedai Sword Master
*****
Gender: Male
Posts: 6691
34714 credits
Members referred : 374


It's time to use PHP5!


« Reply #6 on: Aug 01, 2006, 10:29:47 am »

very well, I can see the light just how, but just how do i setup the login info for mysql ? I feel very dumb since this sound too easy to even to me, its just that i dont know.
The php manual is one of the best from the world!

check http://www.php.net/mysql_connect

Trackback URI for this entry : http://www.webdigity.com/trackback.php?topic=3459
Tags : php mysql databases browsers Bookmark this thread : Digg Del.icio.us Dzone more....

Pages: [1] Print 
Webdigity Webmaster Forums  >  Web Development  >  PhP  >  PHP classes @finalwebsites.com  >  Access_user Class (Moderator: Olaf)
Topic: Help! ,Newbee cant get Login right
« previous next »
Jump to:
User Area
Welcome, Guest. Please login or register.
Did you miss your activation email?
May 28, 2012, 12:40:19 pm





Login with username, password and session length

Donate to our community, and get a permanent link back to your site!

Donate to our community, and get a permanent link back to your site!






Web Design Gallery · Whois Lookup · Pagerank · Tag Browsing · Lo-fi version · Syndication · Webmaster forum history · Advertise
Developed by HumanWorks © 2005 - 2012 Webdigity webmaster community · sublime directory
Webdigity Webmaster Forums | Powered by SMF 1.0.12. © 2001-2005, Lewis Media. All Rights Reserved.