Skip to Main Content

MySQL Database

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

MySQL 5.7 Secure Installation

Mubashar IftikharMay 3 2018 — edited May 4 2018

Hi Everyone

             I hope you all are doing fine.  I am using **RHEL 7.3** and **MySQL 5.7**. And After **MySql 5.7 Installation** i am trying to run **"mysql\_secure\_installation".** but i am facing this error.![error.JPG](https://objectstorage.us-phoenix-1.oraclecloud.com/p/BqK85Rn1zA5MP0vYiqbAdPgs7Z6OmMxw8SD3WCFVm5kY8uReidZ1KPIKkgJ1hCkG/n/axciphqpnohg/b/forums-legacy/o/uploads/jive_attachments/7/9/3/79325554egami.jpeg)

which type of password i have to enter here
please clear this issue

Best Regards
Mubashar Iftikhar

This post has been answered by Dave Stokes-MySQL Community Team-Oracle on May 4 2018
Jump to Answer

Comments

Regarding writing to Oracle, start by reading the https://oracle.github.io/node-oracledb/doc/api.html
Consuming "a web service" can be done with the http module which is part of Node.js. Check out the manual and doc like https://nodejs.org/en/knowledge/HTTP/clients/how-to-create-a-HTTP-request/

Billy Verreynne

Why nodejs and not use only PL/SQL? Far fewer moving parts.

Arif2018

i am not sure on how pl/sql works , Appreciate if you can post some links. All i want is to read the url and insert data into Oracle table.

Billy Verreynne

Oracle has the UTL_HTTP package API and the HttpUriType advance datatype (oo class).
Sample code provided in manual and you can also look at https://community.oracle.com/tech/developers/discussion/comment/10450611/#Comment_10450611 and as for the oo class:

SQL> select httpuritype( 'http://google.com' ).getClob() as "HTML" from dual;

HTML
-------------------------------------------------------------------------------
<!doctype html><html itemscope="" itemtype="http://schema.org/WebPage" lang="en
-ZA"><head><meta content="text/html; charset=UTF-8" http-equiv="Content-Type">
..snipped..

In PL/SQL use:

clobVariable := new HttpUriType(urlVariable).getClob();
1 - 4

Post Details

Added on May 3 2018
1 comment
147 views