Shulou(Shulou.com)06/01 Report--

This article introduces you how to build CBoard data visualization BI platform, the content is very detailed, interested friends can refer to, hope to be helpful to you.

GRANT ALL PRIVILEGES ON *. * TO root @'% 'IDENTIFIED BY "123456"

FLUSH PRIVILEGES

Java.sql.SQLException: Access denied for user 'root' @ 'localhost' (using password: YES) is the stupidest

I made the mistake I made before, a space, which I thought of yesterday, and compared the password with or without a space.

Cause of problem 1: write more spaces

An extra space is written after the value root of username in datasource.properties

Cause of jdbc.driver_class com.mysql.jdbc.Driverjdbc.url jdbc:mysql://localhost:3306/mytest?useUnicode=true&characterEncoding=utf-8&useSSL=truejdbc.username rootjdbc.userpassword root problem 2: GRANT ALL PRIVILEGES ON *. * TO root @'% 'IDENTIFIED BY "mypassword" is not authorized;--% means that all IP can be accessed, or can be changed to exclusive-- mypassword needs to be changed to your own FLUSH PRIVILEGES for the connection password.

-- password is replaced by field authentication_string in the advanced version

On how to build CBoard data visualization BI platform to share here, I hope the above content can be of some help to you, can learn more knowledge. If you think the article is good, you can share it for more people to see.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.