Access denied for user root @ localhost
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.