How to set root user password for mysql while installing erpnext?

Question

I am installing Erpnext in my ubuntu 18.04 Lts. I want to know how to set password for MySql root user.

I am installing erpnext in my ubuntu 18.04 LTS. while running the command - 'sudo bench new-site site4.local' for creating a new frappe site, it is asking for - 'MySQL root password':

I have tried - sudo mysql --user=root mysql' but it is giving output as- mysql: unknown variable 'pid-file=/var/run/mysqld/mysqld.pid

pymysql.err.InternalError: (1698, "Access denied for user 'root'@'localhost'")

I think you will find a password parameter in here : `sudo cat /etc/mysql/debian.cnf` — Kostas Charitidis, Aug 20 '19 at 12:03
It is giving output as -> cat: –: No such file or directory. — Nitish awasthi, Aug 20 '19 at 12:21
Path for my configuration file is as follows - sudo cat /etc/mysql/my.cnf — Nitish awasthi, Aug 20 '19 at 12:23
Edit this file and set your desired password at the password variable — Kostas Charitidis, Aug 20 '19 at 12:42

score 0 · Answer 1 · answered Sep 01 '19 at 08:36

You need to set root password if not set already. While setting root password check if password plugin is set to mysql_native_password or not. If password plugin is set to unix_socket change it to mysql_native_password. unix_socket ignore passwords and allow the corresponding Unix user in without a password check. To change plugin type follow below command:

sudo mysql -u root -p
UPDATE mysql.user SET plugin = 'mysql_native_password', 
      Password = PASSWORD('NEWPASSWORD') WHERE User = 'root';
flush privileges;
quit;

Replace NEWPASSWORD with your password

How to set root user password for mysql while installing erpnext?

1 Answers1