Re: cannot connect from mysql client nor PHP, only sudo

On 02/12/17 08:10, Jivanmukta wrote:
> I installed new PHP (5.6).

Did you install a new php5-mysql module?

Running:
sudo apt-get install lamp-server^

should install all packages needed.

> I found no my.ini file. I found mysql.cnf:
> /etc/mysql/mysql.cnf
> /etc/mysql/conf.d/mysql.cnf

mysql.cnf/mysql.conf/my.cnf are the configuration files in Linux and Unix, microsoft installs uses for some reason a ini file instead.

> I have mysql root password.

You grant looks like:
GRANT ALL PRIVILEGES ON *.* TO 'root'_at_'localhost' WITH GRANT OPTION

If you have a password, it should look like: GRANT ALL PRIVILEGES ON *.* TO 'root'_at_'localhost' IDENTIFIED BY PASSWORD 'a hash' WITH GRANT OPTION

-- 

 //Aho