1 answer
- 10-1
Hi, the error saying "Access denied for user 'root'@'localhost' (using password: NO)" means that your database user credentials are incorrect so you need to check that.
- Sam Louis
Hi, can you show me how to check database credentials properly? I'd google so many thing, but wasn't sure what's wrong with my database. I can't even access database through mariadb command prompt, it said the same thing. When I typed "mysql SHOW DETAIL" at mariadb-10.3.9-win32/bin, it said my port was 3307, so i tried to change app_datasource-default.properties, from workflowUrl=jdbc\:mysql\://localhost\:3306/jwdb?characterEncoding\=UTF-8 to workflowUrl=jdbc\:mysql\://localhost\:3307/jwdb?characterEncoding\=UTF-8, but nothing happen
Add your comment...
Hi
Recently I install few database tool like MySQL Community Server 8.0.13 , MySQL Installer , XAMPP , and MariaDB 10.3 Series . All because i want to look into the database in joget that i'm using, which i'm failed. I'm not sure what i did but all were default setting during installed. Now, even after i uninstall back all the tool, i still get this error code.
Here my app_datasource-default.properties
Here from joget.log
INFO 17 Jan 2019 16:02:46 org.joget.commons.util.SetupManager - Using base directory: ./wflow/
INFO 17 Jan 2019 16:02:48 org.joget.commons.util.DynamicDataSource - profileName=default, url=jdbc:mysql://localhost:3306/jwdb?characterEncoding=UTF-8, user=root
ERROR 17 Jan 2019 16:02:48 org.joget.commons.spring.web.CustomContextLoaderListener - ===== Error initializing WebApplicationContext =====
INFO 17 Jan 2019 16:02:48 org.displaytag.filter.ResponseOverrideFilter - Filter initialized. Response buffering is enabled
Here from localhost.log
* Action: org.owasp.csrfguard.action.Log
* Parameter: Message = potential cross-site request forgery (CSRF) attack thwarted (user:%user%, ip:%remote_ip%, method:%request_method%, uri:%request_uri%, error:%exception_message%)
* Action: org.owasp.csrfguard.action.Error
* Parameter: Message = Security Violation.
* Parameter: Code = 403
* Action: org.owasp.csrfguard.action.Rotate
Here from catalina.log
INFO [localhost-startStop-1] org.apache.jasper.servlet.TldScanner.scanJars At least one JAR was scanned for TLDs yet contained no TLDs. Enable debug logging for this logger for a complete list of JARs that were scanned but no TLDs were found in them. Skipping unneeded JARs during scanning can improve startup time and JSP compilation time.
SEVERE [localhost-startStop-1] org.apache.tomcat.jdbc.pool.ConnectionPool.init Unable to create initial connections of pool.
java.sql.SQLInvalidAuthorizationSpecException: Could not connect: Access denied for user 'root'@'localhost' (using password: NO)
Caused by: java.sql.SQLException: Could not connect: Access denied for user 'root'@'localhost' (using password: NO)