Follow the MySql documentation installation.
Set root password using MySQL Installation Wizard . The password that I write in
Tomcat Realm server.xml.
When you log in to MySql Workbench to your connection, everything is fine, but when you try to get access through Realm, setting up the JDBC Connector with the same password causes an error. From this source also does not helpI fulfill MySql 3 and 6 points on the documentation. In the end, after executing the program, I get in cmd: I gave an example of an error below!
What could be the problem ? I have no options, I will be glad to help!
C: \ Program Files (x86) \ MySQL \ MySQL Server 5.7 \ bin> mysqld.exe --default-file = "my.ini" --init-file = "C: \ Users \ Maks \ Desktop \ mysql-init .txt "--console
2016-08-01T20: 44: 58.017811Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated.
Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2016-08-01T20: 44: 58.017811Z 0 [Warning] Insecure configuration for --secure-file-priv: Current value doesn’t restrict of generated files. Consider setting it to a valid, non-empty path.
2016-08-01T20: 44: 58.018799Z 0 [Note] mysqld.exe (mysqld 5.7.11) starting as process 7408 ...
2016-08-01T20: 44: 58.045232Z 0 [ERROR] Plugin keyring_file reported: 'keyring_file initialization failure. Please check if there is a keyring_file_data points to be created. Will get unusable until you get the keyring_file
mysqld: Table 'mysql.plugin' does not exist 2016-08-01T20: 44: 59.335246Z 0 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it. 2016-08-01T20: 44: 59.349387Z 0 [ERROR] unknown variable 'default-file = my.ini' 2016-08-01T20: 44: 59.351372Z 0 [ERROR] Aborting
================================================= ================
java.sql.SQLException: Access denied for user 'root; password = plemia000' @ 'localhost' (using password: NO) at com.mysql.jdbc.SQLError.createSQLException (SQLError.java:957) at com.mysql.jdbc .MysqlIO.checkErrorPacket (MysqlIO.java:3878) at com.mysql.jdbc.MysqlIO.checkErrorPacket (MysqlIO.java:3814) at com.mysql.jdbc.MysqlIO.checkErrorPacket (MysqlIO.java:871) at com.mysql. jdbc.MysqlIO. .jdbc.ConnectionImpl.connectOneTryOnly (ConnectionImpl.java:2286) at com.mysql.jdbc.ConnectionImpl.createNewIO (ConnectionImpl.java:2085) at com.mysql.jdbc.ConnectionImpl. (ConnectionImpl.java:10595; .jdbc.JDBC4Connection. (JDBC4Connection.java:44) at sun.reflect.NativeConstructorAccessorImpl.newInstance0 (Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance (Unknown Source) at sun.reflect. DelegatingConstructorAccessorImpl.newInstance (Unknown Source) at java.lang.reflect.Constructor.newInstance (Unknown Source) at com.mysql.jdbc.Util.handleNewInstance (Util.java:404) at com.mysql.jdbc.ConnectionImpl.ctActolog .java: 400) at com.mysql.jdbc.NonRegisteringDriver.connect (NonRegisteringDriver.java:327) at org.apache.catalina.realm.JDBCRealm.open (JDBCRealm.java:663) at org.apache.catalina.realm. JDBCRealm.startInternal (JDBCRealm.java:726) at org.apache.catalina.util.LifecycleBase.start (LifecycleBase.java:147) at org.apache.catalina.realm.CombinedRealm.startInternal (CombinedRealm.java Fund49) .apache.catalina.realm.LockOutRealm.startInternal (LockOutRealm.java:120) at org. .java: 904) at org.apache.catalina.core.StandardEngine.startInternal (StandardEngine.java:262) at org.apache.catalina.util.LifecycleBase.start (LifecycleBase.java:147 ) at org.apache.catalina.core.StandardService.startInternal (StandardService.java:441) at org.apache.catalina.util.LifecycleBase.start (LifecycleBase.java:147) at org.apache.catalina.core.StandardServer. startInternal (StandardServer.java:769) at org.apache.catalina.util.LifecycleBase.start (LifecycleBase.java:147) at org.apache.catalina.startup.Catalina.start (Catalina.java:629) at sun.reflect .NativeMethodAccessorImpl.invoke0 (Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke (Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke (Unknown Source) at java.lang.reflect. .catalina.startup.Bootstrap.start (Bootstrap.javazon51) at org.apache.catalina.startup.Bootstrap.main (Bootstrap.java:485)
<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"/>