Access denied for user 'root'

Question

I downloaded an adobe flex mysql script (from a tutorial I am learning) and ran the script in my sql 5.5. It created a database, but it was stored in my wamp folder under:

C:\wamp\bin\mysql\mysql5.1.36\data

I have a test php page that is supposed to print out the data from the database (from the adobe tutorial).

But, when I load the test page from localhost/test.php it just says:

Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'root'@'localhost' (using password: YES) in C:\wamp\www\test.php on line 7
Error connecting to MySQL

And if I run it from localhost:3306/test.php I get just gibberish:

B???
5.1.36-community-log????nKm`zell?ÿ÷??????????????Z\Ap3JZcfVZD???ÿ„Got packets out of order

What password do I use -- my wamp password / login name, or the new mysql5.5 root password? I've tried the mysql5.5 root & password, but I still can't connect.

Why is mysql5.5 loading the database under my older WAMP sql data folder? Is there some conflict having MySQL5.1 installed with WAMP, and MySQL5.5 I just installed separately?

You'll need to post your configuration to really get help here. Just make sure you replace your real passwords with placeholders. — jamesmortensen, Apr 07 '12 at 06:03
I don't understand when you say "configuration". What configuration? — Adam, Apr 07 '12 at 07:05
Possible duplicate of ["Connect failed: Access denied for user 'root'@'localhost' (using password: YES)" from php function](http://stackoverflow.com/questions/6445917/connect-failed-access-denied-for-user-rootlocalhost-using-password-yes) — JYoThI, May 13 '16 at 05:22

score 1 · Answer 1 · answered Mar 26 '13 at 17:18

After wasting most of a day on this problem, it turned out that all i had to do was supply the non-localhost hostname. I've no idea why (the user is allowed to connect from Any host), but it works!

root@base:~# mysql -u username -h hostname -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.

And in PHP:

Test 1807:
<?php
$username = "username";
$password = "password";
$hostname = "actualhostnamenotlocalhost"; 

$con = mysqli_connect($hostname, $username, $password);

// Check connection
if (mysqli_connect_errno($con)){
    echo "Failed to connect to MySQL: " . mysqli_connect_error();
}

mysqli_close($con);    

?>
OK.

score 0 · Answer 2 · answered Apr 07 '12 at 06:10

Please verify if you are using the right password, with the help of phpMyAdmin or my sql work bench

if this is a fresh installation then you will not have any password for the root

You need to set the password and the start connecting to the database using the password that is set

also if you are able to run the script without specifying the password, that means, no password is set for the database

You can use the switch "use password" to NO and connect using root

score 0 · Answer 3 · edited Apr 07 '12 at 15:41

0

Same problem after updating my phpmyadmin version, and turn out was the config problem:

step 1)open the corresponding phpmyadmin installation directory , duplicate config.sample.inc.php to config.inc.php under the same directory .

step 2)Open config.inc.php

change

$cfg['Servers'][$i]['AllowNoPassword'] = **false**;

to

$cfg['Servers'][$i]['AllowNoPassword'] = **true**;

and save the file.

edited Apr 07 '12 at 15:41

dldnh

8,923
3
40
52

answered Apr 07 '12 at 06:47

Kaley

1
1

after starting up WAMP, go to http://localhost/phpmyadmin/server_privileges.php and check whether your user,host and password settings are fine – Kaley Apr 07 '12 at 14:20

score 0 · Answer 4 · edited Mar 27 '13 at 23:28

I spent almost the whole day resolving this issue so if this help anyone I solved it by using the following code:

// - Get Connection - //

$this->dbCon = mysqli_connect($this->dbHost,$this->dbUser) or 
    die("Connection failed:<br/>" . mysqli_connect_error());

// - Select Database - //

mysqli_select_db($this->dbCon,$this->dbName) or
    die("Selection failed: <br/>" .   mysqli_connect_error());

-and also by setting

  $cfg['Servers'][$i]['AllowNoPassword'] = true - in the config.inc.php file.

Hope that helps

Access denied for user 'root'

4 Answers4