• Register
0 votes
345 views

Problem :

I have recently installed Ubuntu 16.04 and installed web server on it. Everything works well, but I am unable to access database. Even if I create new user and grant all privileges, I can't create database In PHP I am getting below error:

SQLSTATE[HY000] [1698] Access denied for user 'root'@'localhost'

When I try to login in the terminal, it works, but in the PHP and phpmyadmin don't.

My PHP Code:

protected $myhost = '127.0.0.1';

protected $mydb = 'dbname';

protected $myname = 'root';

protected $mypass = 'root';

protected $myconn;

private static $mysettings = array(

    PDO::MYSQL_ATTR_INIT_COMMAND => 'SET NAMES utf8'

);



public function __construct() {

    try {

        $this->myconn = new PDO("mysql:myhost=$this->myhost;dbname=$this->mydb", $this->myname, $this->mypass, self::$mysettings);

    } catch (PDOException $e) {

        echo $e->getMessage();

    }

}

 

7 5 2
3,870 points

1 Answer

0 votes

Solution :

Turns out you can not use a root user in 5.7 anymore without becoming the sudoer. That means you can't just run a mysql -u root anymore and have to do the sudo mysql -u root instead.

That also means that it will no longer work if you are using a root user in the GUI (or supposedly any of the non-command line application). To make it work you should have to create the new user with a required privileges and use that instead.

9 7 4
38,600 points

Related questions

1 vote
1 answer 330 views
330 views
Problem : I am naïve to mysql. Currently I am continuously facing below error. “Mysql access denied for user 'root'@'localhost' (using password yes)”. I have recently started using mySQL Workbench and after doing research on above error I found that my root's ... of no us. I want to get my root access back as soon as possible. Can somebody help me in getting my root access back?
asked Apr 7 morrisBson 3.2k points
0 votes
2 answers 2.4K views
2.4K views
Problem : I keep getting a below error with mysql connection through a XAMPP and I really don't know what to do: “Mysqli_real_connect(): (hy000/1045): access denied for user 'pma'@'localhost' (using password: no)” I have already reset my password from a MySql from a ... a changes to my code and to my php.ini file, but at each time it goes back to a error. Any help on this issue?
asked Jan 31 jwilliam 3.9k points
0 votes
1 answer 16 views
0 votes
1 answer 59 views