mysql.server start
로 서버를 켜주고workbench에서 호스트를 byeonghun_app_2021 하나 만들고 들어가서
const express = require('express');
const app = express();
const mysql = require('mysql');
const db = mysql.createPool({
host: 'localhost',
user: 'root',
password: 'password',
database: 'CRUDDataBase',
});
app.get('/', (req, res) => {
const sqlInsert =
"INSERT INTO movie_reviews (movieName, movieReview) VALUES ('inception', 'good movie');";
db.query(sqlInsert, (err, result) => {
res.send('hello Hun');
});
});
app.listen(3001, () => {
console.log('running on port 3001');
});
import React, { useState, useEffect } from 'react';
import './App.css';
function App() {
const [movieName, setMovieName] = useState('');
const [Review, setReview] = useState('');
return (
<div className="App">
<h1>CRUD APPLICATION</h1>
<div className="form">
<label>Movie Name:</label>
<input
type="text"
name="movieName"
onChange={e => {
setMovieName(e.target.value);
}}
/>
<label>Movie Name:</label>
<input
type="text"
name="review"
onChange={e => {
setReview(e.target.value);
}}
/>
<button>Summit</button>
</div>
</div>
);
}
export default App;
npm i axios
code: 'ER_NOT_SUPPORTED_AUTH_MODE',
errno: 1251,
sqlMessage: 'Client does not support authentication protocol requested by server; consider upgrading MySQL client',
sqlState: '08004',
fatal: true
}
index.js
in server folder 에 app.use(express.json());
추가