1
0
-1
3 answers
- 10-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.
- moch fauzi
Thanks u brother, No Problem
Add your comment... - 10-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)
Add your comment... - 10-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)
Add your comment...
Overview
Content Tools
search
attachments
weblink
advanced
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.