When I make database restore every time is problem
How are you restoring? The method that has always worked for me is: create a dump, create ab empty db and use source sqlfile.sql. Please explore this
It may help to say what version ERPNext, how it was installed and why the command is being issued as the root user.
~$ sudo /etc/init.d/mysql stop
~$ sudo mysqld_safe --skip-grant-tables &
~$ mysql -u root
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 1 to server version: 4.1.15-Debian_1-log
Type ‘help;’ or ‘\h’ for help. Type ‘\c’ to clear the buffer.
mysql>
mysql> use mysql;
mysql> update user set password=PASSWORD(“root”) where User=‘root’;
mysql> flush privileges;
Hi all