Hi all: Once the connection was made, I ran a command: create database dbtest It works!
Now testing on NB 9.0 beta build 413 on Windows and MacOS. Regards, Efrem On Thu, Apr 26, 2018 at 12:29 AM, Efrem Mc <efrem...@gmail.com> wrote: > Hi all: > > Here is something to review. Starting in mySQL 8.0.11, there is a new > authentication method; Use Strong Password Encryption for > Authentication using SHA256-based password methods or Legacy > Authentication Method (Retain mySQL 5.x Compatibility). If you select > the Strong Password Encryption method, a new connector and clients > (caching_sha2_password authentication) is needed. The system admin > can select which method to use. For compatibility, I selected Legacy > authentication and different connector. > > The default connector in NB 8.2 for mySQL uses the following: > > Driver: C:\Program Files\NetBeans > 8.2\ide\modules\ext\mysql-connector-java-5.1.23-bin.jar > Driver class: com.mysql.jdbc.Driver > Name: <any name you want here, defaults: MySQL (Connector/J driver)> > > This will NOT work with 8.0.11! > > Using Legacy mode, use the following: > Driver: C:\Program > Files\Java\jdk1.8.0_162\db\lib\mysql-connector-java-5.1.46.jar > Driver class: com.mysql.jdbc.Driver (Same calling method) > Name: <any name you want here, I changed it to: MySQL > (Connector/J driver) 5.1.46> > > This works using NB. See attached. I downloaded the above driver, > search for it. > > I will next change the authentication method to the Strong Password > Encryption and use the following configuration. I will also test it > with the legacy authentication to just see it fail. > > mysql-connector-java-8.0.11.jar > > It is installed in: C:\Program Files (x86)\MySQL\Connector J 8.0 > But this requires either a selective installation of mySQL using their > installer, just don't accept the default method to customize it. I > selected the components to install and selected the connector. > > The connector is also available at: > https://dev.mysql.com/downloads/connector/j/5.0.html > > > phpMyAdmin from version 1.42 and higher supports the administration of > multiple MySQL servers. I am attaching one I am usings as an example. > I am using XAMPP on Windows here. > > The file is located in: C:\xampp\phpMyAdmin\ > > The filename is config.inc.php. I changed the name because I hard > coded the admin account and password. There is probably a method to > prompt for the name. I did not have time to set it up or try it. > > > Regards, > > Efrem McCrimon > GUI Builder Tribe > DB Tribe > > > > On Wed, Apr 25, 2018 at 6:04 PM, Martin O'Shea <martin_os...@outlook.com> > wrote: >> Paul >> >> >> >> I have just run MySQL_Upgrade as you suggested, and have restarted MySQL and >> NetBeans. But unfortunately, the result is the same as before. >> >> >> >> Yet I know that table 'mysql.plugin' does exist. >> >> >> >> Any ideas? >> >> >> >> Thanks >> >> >> >> Martin O’Shea. >> >> --------------------------------------------------------------------- To unsubscribe, e-mail: users-unsubscr...@netbeans.apache.org For additional commands, e-mail: users-h...@netbeans.apache.org For further information about the NetBeans mailing lists, visit: https://cwiki.apache.org/confluence/display/NETBEANS/Mailing+lists
