Getting this when trying to use my mysqli database.
"Access denied for user 'SYSTEM'@'localhost' (using password: NO)"
Heres the script:
<?php
$host = "SERVERIP"; // Host name
$username = "energyhosting"; // Mysql username
$password = "MYPASSWORD"; // Mysql password
$db_name = "energyhosting"; // Database name
$tbl_name = "forum_question"; // Table name
// Connect to server and select databse.
mysql_connect("$host", "$username", "$password"
or die(mysql_error());
//mysql_connect("$host", "$username", "$password"
or die(mysql_error());
mysql_select_db("$db_name"
or die("cannot select DB"
;
$sql="SELECT * FROM $tbl_name ORDER BY id DESC";
// OREDER BY id DESC is order result by descending
$result=mysql_query($sql);
?>
<table width="90%" border="0" align="center" cellpadding="3" cellspacing="1" bgcolor="#CCCCCC">
<tr>
<td width="6%" align="center" bgcolor="#E6E6E6"><strong>#</strong></td>
<td width="53%" align="center" bgcolor="#E6E6E6"><strong>Topic</strong></td>
<td width="15%" align="center" bgcolor="#E6E6E6"><strong>Views</strong></td>
<td width="13%" align="center" bgcolor="#E6E6E6"><strong>Replies</strong></td>
<td width="13%" align="center" bgcolor="#E6E6E6"><strong>Date/Time</strong></td>
</tr>
<?php
while($rows=mysql_fetch_array($result)){ // Start looping table row
?>
<tr>
<td bgcolor="#FFFFFF"><? echo $rows['id']; ?></td>
<td bgcolor="#FFFFFF"><a href="view_topic.php?id=<? echo $rows['id']; ?>"><? echo $rows['topic']; ?></a><BR></td>
<td align="center" bgcolor="#FFFFFF"><? echo $rows['view']; ?></td>
<td align="center" bgcolor="#FFFFFF"><? echo $rows['reply']; ?></td>
<td align="center" bgcolor="#FFFFFF"><? echo $rows['datetime']; ?></td>
</tr>
<?php
// Exit looping and close connection
}
mysql_close();
?>
<tr>
<td colspan="5" align="right" bgcolor="#E6E6E6"><a href="create_topic.php"><strong>Create New Topic</strong> </a></td>
</tr>
</table>
The mysqlo is not hosted on same computer,. its on a lan computer.
Root password just changed with "update user set password = 'mypassowrd' where user = 'root';
anyone who can help? :/