Access denied phpMyadmin

Hi

I tried setting a password for my database in phpMyAdmin and just after making changes, i was kicked off and received the following error message :

MySQL said: 

#1045 - Access denied for user 'root'@'localhost' (using password: NO) 

phpMyAdmin tried to connect to the MySQL server, and the server rejected the connection. You should check the host, username and password in your configuration and make sure that they correspond to the information given by the administrator of the MySQL server.

"please help, How do i reconfigure my password? i tried the whole morning"

No simple solution. Google for help. Or uninstall reinstall.

1. Open config.inc.php file in the phpmyadmin directory

2. Find line 21: $cfg['Servers'][$i]['password'] = ''

3. Change it to: $cfg['Servers'][$i]['password'] = 'your_password';

4. Restart XAMPP

Thanks a lot Mac

I googled till i found a solution and again, i just open the forum to give a solution in case someone may experience the same problem and there you just gave the same solution as well "config.inc.php".

We learn a lot every day Mac

May you show me an example of connection details, because I put the following but nothing is correct:

Language: SQL
$username = "490515";
$password = "";
$database = "490515";
$server = "localhost";
 
//conection details
$db_handle = mysql_conect($server, $username, $password);
 
//DATABASE
$db_found = mysql_select_db($database, $db_handle);

And in the phpMyadmin, I changed line 20 to 490515, and line 21 to password='', because I di put the password yet.
But still errors

Dear Sir,

I have an issue of connecting to db.

Your assistance.

Well, you are not clear if your problem is getting into phpmyadmin, or if it is giving a user access to the database you have created.

http://www.yourwebskills.com/dbphpmyadminusers.php

Dear Sir,
Please what I did and the tables are created but no access to the database as per the following message of warning.

THis is the user.find.php code

Language: PHP
include (';user.php';);
	$connection = mysql_connect("localhost", "490515", "");
	mysql_select_db("490515", $connection);
	// form
	echo "<form method=';post'; action=';user_find.php';>";
	echo "<div>";
	echo "Enter the id: <input type=';text'; name=';_id'; value=';';  />";
	echo "<input type=';submit'; value=';Submit'; name=';submitID'; />";
	echo"</div>";
	echo "</form>";
		if (isset($_POST[';submitID';])){	
 
		$ID = $_POST[';_id';];
		//
		$user = new User();
		$user->getUserById(';$ID';);
 
		//
		echo "<p>User known as: ".$user->getDisplayName()."</p>";
 
		//
		$friends = $user->getFriends();
 
		//
		echo "<p>Friend with: ".implode(';,';,$friends)."</p>";
 
		//
		$user->getUserById(';$ID';);
 
		//
		echo "<p>User known as: ".$user->getDisplayName()."</p>";
 
		echo "<p><a href=';user_find.php';>Return</a></p>";

The following is the warning:

Warning: mysql_connect() [function.mysql-connect]: Access denied for user '490515'@'localhost' (using password: NO) in E:\xampplite\htdocs\portfolio\user_find.php on line 4

Warning: mysql_select_db() expects parameter 2 to be resource, boolean given in E:\xampplite\htdocs\portfolio\user_find.php on line 5

I reinstalled the program and changed the password. but the issue still the same.

I can see the database created (490515) in the msql /data directory.

Your assistance.

@CostaM

Try the following maybe:

Instead of "localhost" rather use:

Language: PHP
$hostserver = "127.0.0.1";
$db_name = "490515";
$password ="???";

and pass the variables in instead of the string with the words, and no "localhost".

And I hope you are not passing in a blank password, but just blanked it out for now, as that might also cause issues. Check that other post to change your password in the backend if need be.

And lastly try something like this:

Language: PHP
$db_handle = mysql_connect($hostserver, $db_name, $password);
$db_found = mysql_select_db($db_name, $db_handle);
if ($db_found) {
  echo "Jipeeee!!!";
}
else {
  echo "sigh, not again";
}

I hope this helps?

---------------------------------------------------------------------
Live life...
---------------------------------------------------------------------

Well, have you created a user for this database in phpmyadmin. Have you also visited the link I posted?

Here is another link http://www.infosolutionsgoa.com/tutor/phpmyadmin-database-management.html

Thank you so much Sir,

I did learn something what I did not do last year on adding users for my database.

Hi CostaM,
Did you manage to resolve your issues for the user_find code. Just wanted to know what you did. I did not have any connection to the databse issues but am also having the following errors:-
Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in C:\xampp\htdocs\user.php on line 11

User known as:

Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in C:\xampp\htdocs\user.php on line 25

Friend with:

Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in C:\xampp\htdocs\user.php on line 11

User known as:

Plse advise, thanks

Please see the link: Here is another link [www.infosolutionsgoa.com]
This link is to create a database and username, then give privileges to the username.
Because, when we create database on our computer with Xampp, it doesn't create username.
Create database, then username by following the link, then assign a password to user created, then no warning will be given.

I've finished my portfolio and uploaded it.

Good luck