1 Topic by primavero

  • primavero
  • Member
  • Offline
  • Registered: 2017-02-07
  • Posts: 5

Topic: MySQL root password is not working after install

==== Required information ====
- iRedMail version (check /etc/iredmail-release): 0.9.6 MYSQL edition
- Linux/BSD distribution name and version: Ubuntu 16.04 LTS
- Store mail accounts in which backend (LDAP/MySQL/PGSQL): MySQL
- Web server (Apache or Nginx): Apache
- Manage mail accounts with iRedAdmin-Pro? No
- Related log if you're reporting an issue:
====

I have a problem connecting to mysql after iredmail install on fresh system.
RoundCube and iRedAdmin is working correctly and i can connect to mysql from command line with user vmail and password from iredmail.tips file.
But when I try to connect as root user i got
ERROR 1698 (28000): Access denied for user 'root'@'localhost'

P.S. password is 100% correct. i tried to connect million of times smile I even reinstall whole system+iredmail for 5 times...

----

Spider Email Archiver: On-Premises, lightweight email archiving software developed by iRedMail team. Supports Amazon S3 compatible storage and custom branding.

2 Reply by ZhangHuangbin

  • ZhangHuangbin
  • ZhangHuangbin
  • iRedMail Developers
  • Offline
  • Registered: 2009-05-06
  • Posts: 30,770

Re: MySQL root password is not working after install

primavero wrote:

But when I try to connect as root user i got
ERROR 1698 (28000): Access denied for user 'root'@'localhost'

Show us the full command you ran please.

iRedMail will generate /root/.my.cnf during installation, it contains mysql root password too. And you can simply type "mysql" command without any arguments to login to MySQL. Please try it.

3 Reply by primavero

  • primavero
  • Member
  • Offline
  • Registered: 2017-02-07
  • Posts: 5

Re: MySQL root password is not working after install

mysql -u root -p
Enter password: ************
ERROR 1698 (28000): Access denied for user 'root'@'localhost'

I checked root password in .my.cnf file  - it is the same as I entered during installation.

4 Reply by primavero

  • primavero
  • Member
  • Offline
  • Registered: 2017-02-07
  • Posts: 5

Re: MySQL root password is not working after install

mysql
ERROR 1045 (28000): Access denied for user 'andrey'@'localhost' (using password: NO)

5 Reply by ZhangHuangbin

  • ZhangHuangbin
  • ZhangHuangbin
  • iRedMail Developers
  • Offline
  • Registered: 2009-05-06
  • Posts: 30,770

Re: MySQL root password is not working after install

Any error in files /root/iRedMail-0.9.6/runtime/*log?

6 Reply by addy

  • addy
  • Member
  • Offline
  • Registered: 2019-10-05
  • Posts: 1

Re: MySQL root password is not working after install

This will fix the issue:

sudo mysql -u root
UPDATE mysql.user SET plugin='mysql_native_password' WHERE User='root';
exit;
sudo service mysql restart