Mysql doc, paragraph 6!

  • 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 help

  • I 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"/> 

    1 answer 1

    Mistake

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

    means that instead of 'root', the user is considered to be 'root; password = plemia000'. In <Realm ... > replace the line

     connectionURL="jdbc:mysql://localhost:3306/coupon_system?user=root;password=plemia000" 

    a similar one in which the semicolon is replaced by an ampersand so that the DNS becomes correct

     connectionURL="jdbc:mysql://localhost:3306/coupon_system?user=root&password=plemia000" 
    • A pause on your advice and got: Could not load the server configuration at \ Servers \ Tomcat v8.0 Server at localhost-config. The configuration may be corrupt or incomplete. The reference to entity "password" must end with the ';' delimiter. - Maks.Burkov 6:08 pm