MySQL Workbench Access Denied

0

Good afternoon, I'm having problems with mysql workbench, it's giving permission denied, but when I enter the terminal as superuser I get access.

(Access image denied in workbench)

(terminalaccessimageasroot)

(my.cnfcode)

#TheMariaDBconfigurationfile##TheMariaDB/MySQLtoolsreadconfigurationfilesinthefollowingorder:#1."/etc/mysql/mariadb.cnf" (this file) to set global defaults,
# 2. "/etc/mysql/conf.d/*.cnf" to set global options.
# 3. "/etc/mysql/mariadb.conf.d/*.cnf" to set MariaDB-only options.
# 4. "~/.my.cnf" to set user-specific options.
#
# If the same option is defined multiple times, the last one will apply.
#
# One can use all long options that the program supports.
# Run program with --help to get a list of available options and with
# --print-defaults to see which it would actually understand and use.

#
# This group is read both both by the client and the server
# use it for options that affect everything
#
[client-server]

# Import all .cnf files from configuration directory
!includedir /etc/mysql/conf.d/
!includedir /etc/mysql/mariadb.conf.d/
    
asked by anonymous 23.04.2018 / 21:49

1 answer

1

use mysql db and the command below.

UPDATE user SET plugin = 'mysql_native_password' WHERE user = 'root';
FLUSH PRIVILEGES;
    
05.08.2018 / 18:47