No Privileges

[elliott1]

in phpMyAdmin it says No Privileges even though i havent created a new user and gave it all the Privileges and when running script it says:

could not open dbAccess denied for user 'xxxxxx'@'localhost' to database 'Members'

Please help
thanks

 

[Corey]

I reset the permissions if it still does not work, change your password in cPanel so it resets it for everything. If it does not work after you change your password PM me your user\pass and a link to this thread.

-Corey

 

[elliott1]

ok thanks :happysad: , but now i have a new error lol and kinda new to this it is :


Parse error: syntax error, unexpected T_VARIABLE in /home/xxxxx/public_html/xxxx.php on line 3

 

[Corey]

That would be a PHP error not related to your account

 

[elliott1]

i said am new not thick :happysad: i no its a php error can you help with it :biggrin:

 

[Corey]

Paste the first few lines around it here.

 

[elliott1]

this is signup check

<?php
include ("config.php")
////////////////////////////////////////
////// DONOT EDIT BELOW /////////
///////////////////////////////////////
//
connect to the mysql server
$link = mysql_connect($server, $db_user, $db_pass) ;
or die ("Could not connect to mysql because ".mysql_error());
mysql_select_db("$mysql_database",$link) or die ("could not open db".mysql_error());

this is the login file get same sort of error just on differnt line

<?php
ob_start();
include ("config.php")
// connect to the mysql server 
$link = mysql_connect($server, $db_user, $db_pass) 
or die ("Could not connect to mysql because ".mysql_error()) ;
// select the database 
mysql_select_db($mysql_database) 
or die ("Could not select database because ".mysql_error()); 
$match = "select id from $table where username = '".$_POST['username']."' 
and password = '".$_POST['password']."';"; 
$qry = mysql_query($match) 
or die ("Could not match data because ".mysql_error()); 
$num_rows = mysql_num_rows($qry);

THANKS!

 

[Corey]

In your first block of CODE:

include ("config.php")

Needs to be:

include ("config.php");

It's missing the ; at the end of the line.

You have the same error in your second block.

 

[elliott1]

yay! thanks the login works but still says error on the signup check on line 10 :eek4:

thanks

and also thanks for fast reply :biggrin:

 

[elliott1]

I tried not to post on here but i cannot get it to work following error:

Could not select database because Access denied for user 'elliott1_xxxxxx'@'localhost' to database 'Members'

Happends when running the following php script:

<?php
include ("config.php");
////////////////////////////////////////
////// DONOT EDIT BELOW /////////
///////////////////////////////////////
//
// Connect to server and select databse.
mysql_connect("$server", "$db_user", "$db_pass")or die("cannot connect");
mysql_select_db("$mysql_database")or die("cannot select DB");
// select the database or table?
mysql_select_db("Members")
or die ("Could not select database because ".mysql_error());
// insert the data
$insert = mysql_query("insert into $table values ('NULL', '".$_POST['Username']."',
'".$_POST['Password']."')")
or die("Could not insert data because ".mysql_error());
// print a success message
echo "Your user account has been created!<br>";
echo "Now you can <a href=main_login.html>log in</a>";

Again i have changed all the possible password added new user , gave full privileges etc but nope still doenst work

Please help
Thanks!

 

[Christopher]

For database, it should be elliott1_xxxxxx

 

[elliott1]

:biggrin:thanks

almost there ....
new error:

Could not insert data because Column count doesn't match value count at row 1

 

[Corey]

Have you created tables and added columns in your database?

 

[elliott1]

all sorted now thanks any way:biggrin: