java.sql.SQLException: Access denied for user 'root; password = plemia000' @ 'localhost' (using password: NO)

<Realm className="org.apache.catalina.realm.JDBCRealm" driverName="com.mysql.jdbc.Driver" connectionURL="jdbc:mysql://localhost:3306/coupon_system?user=root;password=plemia000" userTable="user" userNameCol="nickname" userCredCol="password" userRoleTable="user_roles" roleNameCol="role"/>
  • I can not understand what's wrong! Do not understand the error "using password: NO"?

    1 answer 1

    Set a password for the root using the console

     mysqladmin -u root password qwertyuiop123
    • "mysql is not recognized as internal command or external command" console error - Maks.Burkov 6:48 pm
    • Are you running a team with admin rights? - Dmitry Petukhov 6:49 pm
    • Yes. Now I get the same thing in MySql itself - this time using password: YES - Maks.Burkov
    • It is also necessary to give GRANT ALL PRIVILEGES ON rights . TO 'root' @ 'localhost' IDENTIFIED BY '% password%' WITH GRANT OPTION; - Dmitry Petukhov 7:01 pm
    • Where do I write this ??? - Maks.Burkov