By using this Help Desk you permit HonestRepair to collect your email address and the data you provide so they can provide support for your ticket.

Knowledgebase
HonestRepair > HonestRepair Help Desk > Knowledgebase

Search help:


LAMP Setup "ERROR Establishing Connection to Database"

Solution

Since Mysql 5.7, root access to databases has changed.

For applications like WordPress to communicate with the database with the root user, some adjustments must be made.

From..... https://www.digitalocean.com/community/tutorials/how-to-install-linux-apache-mysql-php-lamp-stack-ubuntu-18-04


sudo mysql



SELECT user,authentication_string,plugin,host FROM mysql.user;



ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password';




FLUSH PRIVILEGES;

 

 
Was this article helpful? yes / no
Related articles Installing Wireshark on Ubuntu Linux
Installing NPM (on a LAMP stack) error "The following packages have unmet dependencies. npm : Depends:"
Article details
Article ID: 8
Category: Linux
Date added: 2018-10-08 17:24:05
Rating (Votes): Article rated 3.7/5.0 (3)

 
« Go back

 
Powered by Help Desk Software HESK, in partnership with SysAid Technologies