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:
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
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:
Posts: 5799
46391 credits Members referred : 3
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)
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:
Posts: 6691
34714 credits Members referred : 374
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.