• Register
0 votes
599 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

Please log in or register to answer this question.

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 493 views
493 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, 2020 morrisBson 3.2k points
0 votes
2 answers 3.7K views
3.7K 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, 2020 jwilliam 3.9k points
0 votes
1 answer 82 views
0 votes
1 answer 23 views
0 votes
1 answer 73 views
0 votes
1 answer 43 views
43 views
Problem: I had installed MySQL on my linux server sometimes back now I forgot the password so I tried to change it using the ways I found online. What I did was as shown below: /etc/init.d/mysql stop mysqld_safe --skip-grant-tables & mysql --user root mysql SELECT * ... it still shows me below errors  "Access denied for user 'root'@'localhost' (using password: Yes)". How to fix above MYSql error?
asked Jul 14, 2020 Raphael Pacheco 4.9k points
0 votes
1 answer 82 views
82 views
Problem : I am new to MySql. The problem started when I was unable to login to Mysql using my Mysql console. It is repeatedly asking me the password and now I am unable to remember my password. Can I change my password ? And now when I am trying to open my PhpMyAdmin ... WAMP and after that deleted all my related files and then reinstalled it .But it did not fix my issue. How can I fix the issue ?
asked Feb 26, 2020 mphil 2.3k points
0 votes
1 answer 1.4K views
1.4K views
Problem : I am new to NodeJS and trying to connect to mySQL through the NodeJS file, however I am facing the below error : { Error: ER_ACCESS_DENIED_ERROR: Access denied for user 'root'@'localhost' (using password: YES) at Handshake.Sequence._packetToError (/home/alecxe/Node ... bar" AS second_field', function(err, results, fields) { console.log(err); console.log(results); myconnection.end(); } );
asked Dec 6, 2019 alecxe 7.5k points
0 votes
1 answer 354 views
354 views
Problem : I am currently using the Mac OS Yosemite and Laravel 5.0. I am new to Laravel 5.0. In the local environment whenever I run the below command php artisan migrate I always encounter below error : “Access denied for user 'homestead'@'localhost' (using password: YES)” I am unable to fix above error. Any clue to fix the above error?
asked Feb 13, 2020 mphil 2.3k points
0 votes
2 answers 772 views
772 views
Problem : Whenever I want to open a mysql in my windows cmd by simply typing mysql. I am facing below error : “ERROR 1045 (28000): Access denied for user ODBC@localhost (using password: NO)” After that by looking at similar queries I somehow got the ... password=root ERROR 1045 (28000): Access denied for user 'admin'@'localhost' (using password:NO) Any pointers will be the great help.
asked Dec 18, 2019 alecxe 7.5k points