1
0
-1

My Environment :

Ubuntu 18.04 LTS 64 bit. Yesterday I installed Joget and Mysql (First time installed and playing around this). I am on http://localhost:8080/jw/setup and getting :

Cannot create PoolableConnectionFactory (Access denied for user root @ localhost )

I have done :

./tomcat8.sh start

sudo service mysql start
sudo mysql -u root

and I am able to login in the MySQL. Here are further info :

mysql> SELECT DATABASE();

+------------+

| DATABASE() |

+------------+

| jwdb       |

+------------+

1 row in set (0.00 sec)

 

mysql> SHOW VARIABLES WHERE Variable_name = 'port';

+---------------+-------+

| Variable_name | Value |

+---------------+-------+

| port          | 3306  |

+---------------+-------+

1 row in set (0.00 sec)

mysql> GRANT ALL PRIVILEGES ON * . * TO 'root'@'localhost';

Query OK, 0 rows affected (0.00 sec)

mysql> FLUSH PRIVILEGES;

Query OK, 0 rows affected (0.00 sec)

 

I don't know how to solve this error.

    CommentAdd your comment...

    3 answers

    1.  
      1
      0
      -1

      I have same problem too, but i tried to create new user with grant all priviledges and its work.

      sorry for my bad english.

      1. moch fauzi

        Thanks u brother, No Problem

      CommentAdd your comment...
    2.  
      1
      0
      -1

      I don't know how and why this worked for me : (MySql Version 5.7) mysql> alter user 'root'@'localhost' identified with mysql_native_password by 'mypassword'; Query OK, 0 rows affected (0.00 sec)

      Epson Printer Error code 0xf1

        CommentAdd your comment...
      1.  
        1
        0
        -1

        I don't know how and why this worked for me : (MySql Version 5.7) mysql> alter user 'root'@'localhost' identified with mysql_native_password by 'mypassword'; Query OK, 0 rows affected (0.00 sec)

          CommentAdd your comment...