How Connecting to a MySQL Database with caching_sha2_password mode with NetBeans?
I want to connect to DataBase MySQL by registering a user who when authenticating is subject to cryptography. I use windows 10 and my my.ini file has the following property default_authentication_plugin = caching_sha2_password
I followed all the existing documentation about this plugin and although it does not say anything about netbeans, I have added the following properties:
# CLIENT SECTION
[mysql]
no beep
--ssl-mode = PREFERRED
-ssl-ca = ca.pem
--ssl-cert = client-cert.pem
--ssl-key = client-key.pem
# SERVER SECTION
[mysqld]
tls_version = TLSv1.2
--ssl-cipher = ECDH-RSA-AES256-GCM-SHA384
ssl-ca = ca.pem
ssl-cert = server-cert.pem
ssl-key = server-key.pem
However the result is the same, while following this tutorial Connecting to a MySQL Database in "Starting the MySQL Server" step I get the error Unable to load authentication plugin 'caching_sha2_password. All solutions found on the internet speak to change the property
default_authentication_plugin = caching_sha2_password
to
default_authentication_plugin = mysql_native_password
This even fixes the error, but the problem is that I want my database encrypted. My question is, how to do MySql connection with netbeans using default_authentication_plugin = caching_sha2_password property
The error Unable to load authentication plugin 'caching_sha2_password occur when i try connect after set properties window
enter image description here
enter image description here
or when i try start database after right-click on MySqL Server at localhost:3306 [cloud] (disconnected)
enter image description here
mysql netbeans server cryptography connection
asked Nov 15 '18 at 3:59
Pedro CorreiaPedro Correia
74
add a comment |
I want to connect to DataBase MySQL by registering a user who when authenticating is subject to cryptography. I use windows 10 and my my.ini file has the following property default_authentication_plugin = caching_sha2_password
I followed all the existing documentation about this plugin and although it does not say anything about netbeans, I have added the following properties:
# CLIENT SECTION
[mysql]
no beep
--ssl-mode = PREFERRED
-ssl-ca = ca.pem
--ssl-cert = client-cert.pem
--ssl-key = client-key.pem
# SERVER SECTION
[mysqld]
tls_version = TLSv1.2
--ssl-cipher = ECDH-RSA-AES256-GCM-SHA384
ssl-ca = ca.pem
ssl-cert = server-cert.pem
ssl-key = server-key.pem
However the result is the same, while following this tutorial Connecting to a MySQL Database in "Starting the MySQL Server" step I get the error Unable to load authentication plugin 'caching_sha2_password. All solutions found on the internet speak to change the property
default_authentication_plugin = caching_sha2_password
to
default_authentication_plugin = mysql_native_password
This even fixes the error, but the problem is that I want my database encrypted. My question is, how to do MySql connection with netbeans using default_authentication_plugin = caching_sha2_password property
The error Unable to load authentication plugin 'caching_sha2_password occur when i try connect after set properties window
enter image description here
enter image description here
or when i try start database after right-click on MySqL Server at localhost:3306 [cloud] (disconnected)
enter image description here
mysql netbeans server cryptography connection
asked Nov 15 '18 at 3:59
Pedro CorreiaPedro Correia
74
It sounds like you might be using an older version of the MySQL Connector/J driver. What version do you have? If it is < 8.0.9 see the release note Changes in MySQL Connector/J 8.0.9... which states: "Connector/J now supports the new caching_sha2_password authentication plugin, which is the default authentication plugin for MySQL 8.0.4 and later". In short, be sure to use recent versions of MySQL and Connector/J if you want to use caching_sha2_password. Update your post with the versions you use if appropriate.
– skomisa
Nov 15 '18 at 7:23
My version is 8.0.13, is the last version. I want create an small program in model client-server. I think that to implement this programe i need MySql server, or MySQL Connector/J run as client-server? I start read documentation, and MySQL connector/j need connect with MySQL server, i continue read thanks.
– Pedro Correia
Nov 15 '18 at 16:06
add a comment |
I want to connect to DataBase MySQL by registering a user who when authenticating is subject to cryptography. I use windows 10 and my my.ini file has the following property default_authentication_plugin = caching_sha2_password
I followed all the existing documentation about this plugin and although it does not say anything about netbeans, I have added the following properties:
# CLIENT SECTION
[mysql]
no beep
--ssl-mode = PREFERRED
-ssl-ca = ca.pem
--ssl-cert = client-cert.pem
--ssl-key = client-key.pem
# SERVER SECTION
[mysqld]
tls_version = TLSv1.2
--ssl-cipher = ECDH-RSA-AES256-GCM-SHA384
ssl-ca = ca.pem
ssl-cert = server-cert.pem
ssl-key = server-key.pem
However the result is the same, while following this tutorial Connecting to a MySQL Database in "Starting the MySQL Server" step I get the error Unable to load authentication plugin 'caching_sha2_password. All solutions found on the internet speak to change the property
default_authentication_plugin = caching_sha2_password
to
default_authentication_plugin = mysql_native_password
This even fixes the error, but the problem is that I want my database encrypted. My question is, how to do MySql connection with netbeans using default_authentication_plugin = caching_sha2_password property
The error Unable to load authentication plugin 'caching_sha2_password occur when i try connect after set properties window
enter image description here
enter image description here
or when i try start database after right-click on MySqL Server at localhost:3306 [cloud] (disconnected)
enter image description here
mysql netbeans server cryptography connection
asked Nov 15 '18 at 3:59
Pedro CorreiaPedro Correia
74
I want to connect to DataBase MySQL by registering a user who when authenticating is subject to cryptography. I use windows 10 and my my.ini file has the following property default_authentication_plugin = caching_sha2_password
I followed all the existing documentation about this plugin and although it does not say anything about netbeans, I have added the following properties:
# CLIENT SECTION
[mysql]
no beep
--ssl-mode = PREFERRED
-ssl-ca = ca.pem
--ssl-cert = client-cert.pem
--ssl-key = client-key.pem
# SERVER SECTION
[mysqld]
tls_version = TLSv1.2
--ssl-cipher = ECDH-RSA-AES256-GCM-SHA384
ssl-ca = ca.pem
ssl-cert = server-cert.pem
ssl-key = server-key.pem
However the result is the same, while following this tutorial Connecting to a MySQL Database in "Starting the MySQL Server" step I get the error Unable to load authentication plugin 'caching_sha2_password. All solutions found on the internet speak to change the property
default_authentication_plugin = caching_sha2_password
to
default_authentication_plugin = mysql_native_password
This even fixes the error, but the problem is that I want my database encrypted. My question is, how to do MySql connection with netbeans using default_authentication_plugin = caching_sha2_password property
The error Unable to load authentication plugin 'caching_sha2_password occur when i try connect after set properties window
enter image description here
enter image description here
or when i try start database after right-click on MySqL Server at localhost:3306 [cloud] (disconnected)
enter image description here
mysql netbeans server cryptography connection
mysql netbeans server cryptography connection
asked Nov 15 '18 at 3:59
Pedro CorreiaPedro Correia
74
asked Nov 15 '18 at 3:59
Pedro CorreiaPedro Correia
74
edited Mar 2 at 13:36
Pedro Correia
asked Nov 15 '18 at 3:59
Pedro CorreiaPedro Correia
74
asked Nov 15 '18 at 3:59
Pedro CorreiaPedro Correia
74
asked Nov 15 '18 at 3:59
Pedro CorreiaPedro Correia
74
74
It sounds like you might be using an older version of the MySQL Connector/J driver. What version do you have? If it is < 8.0.9 see the release note Changes in MySQL Connector/J 8.0.9... which states: "Connector/J now supports the new caching_sha2_password authentication plugin, which is the default authentication plugin for MySQL 8.0.4 and later". In short, be sure to use recent versions of MySQL and Connector/J if you want to use caching_sha2_password. Update your post with the versions you use if appropriate.
– skomisa
Nov 15 '18 at 7:23
My version is 8.0.13, is the last version. I want create an small program in model client-server. I think that to implement this programe i need MySql server, or MySQL Connector/J run as client-server? I start read documentation, and MySQL connector/j need connect with MySQL server, i continue read thanks.
– Pedro Correia
Nov 15 '18 at 16:06
add a comment |
It sounds like you might be using an older version of the MySQL Connector/J driver. What version do you have? If it is < 8.0.9 see the release note Changes in MySQL Connector/J 8.0.9... which states: "Connector/J now supports the new caching_sha2_password authentication plugin, which is the default authentication plugin for MySQL 8.0.4 and later". In short, be sure to use recent versions of MySQL and Connector/J if you want to use caching_sha2_password. Update your post with the versions you use if appropriate.
– skomisa
Nov 15 '18 at 7:23
My version is 8.0.13, is the last version. I want create an small program in model client-server. I think that to implement this programe i need MySql server, or MySQL Connector/J run as client-server? I start read documentation, and MySQL connector/j need connect with MySQL server, i continue read thanks.
– Pedro Correia
Nov 15 '18 at 16:06
It sounds like you might be using an older version of the MySQL Connector/J driver. What version do you have? If it is < 8.0.9 see the release note Changes in MySQL Connector/J 8.0.9... which states: "Connector/J now supports the new caching_sha2_password authentication plugin, which is the default authentication plugin for MySQL 8.0.4 and later". In short, be sure to use recent versions of MySQL and Connector/J if you want to use caching_sha2_password. Update your post with the versions you use if appropriate.
– skomisa
Nov 15 '18 at 7:23
It sounds like you might be using an older version of the MySQL Connector/J driver. What version do you have? If it is < 8.0.9 see the release note Changes in MySQL Connector/J 8.0.9... which states: "Connector/J now supports the new caching_sha2_password authentication plugin, which is the default authentication plugin for MySQL 8.0.4 and later". In short, be sure to use recent versions of MySQL and Connector/J if you want to use caching_sha2_password. Update your post with the versions you use if appropriate.
– skomisa
Nov 15 '18 at 7:23
My version is 8.0.13, is the last version. I want create an small program in model client-server. I think that to implement this programe i need MySql server, or MySQL Connector/J run as client-server? I start read documentation, and MySQL connector/j need connect with MySQL server, i continue read thanks.
– Pedro Correia
Nov 15 '18 at 16:06
My version is 8.0.13, is the last version. I want create an small program in model client-server. I think that to implement this programe i need MySql server, or MySQL Connector/J run as client-server? I start read documentation, and MySQL connector/j need connect with MySQL server, i continue read thanks.
– Pedro Correia
Nov 15 '18 at 16:06
add a comment |
0
active
oldest
votes
Your Answer
StackExchange.ifUsing("editor", function ()
StackExchange.using("externalEditor", function ()
StackExchange.using("snippets", function ()
StackExchange.snippets.init();
);
);
, "code-snippets");
StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "1"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);
else
createEditor();
);
function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);
);
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53312237%2fhow-connecting-to-a-mysql-database-with-caching-sha2-password-mode-with-netbeans%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
0
active
oldest
votes
0
active
oldest
votes
active
oldest
votes
active
oldest
votes
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53312237%2fhow-connecting-to-a-mysql-database-with-caching-sha2-password-mode-with-netbeans%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
It sounds like you might be using an older version of the MySQL Connector/J driver. What version do you have? If it is < 8.0.9 see the release note Changes in MySQL Connector/J 8.0.9... which states: "Connector/J now supports the new caching_sha2_password authentication plugin, which is the default authentication plugin for MySQL 8.0.4 and later". In short, be sure to use recent versions of MySQL and Connector/J if you want to use caching_sha2_password. Update your post with the versions you use if appropriate.
– skomisa
Nov 15 '18 at 7:23
My version is 8.0.13, is the last version. I want create an small program in model client-server. I think that to implement this programe i need MySql server, or MySQL Connector/J run as client-server? I start read documentation, and MySQL connector/j need connect with MySQL server, i continue read thanks.
– Pedro Correia
Nov 15 '18 at 16:06