To properly hash the user's password before inserting it into the database, you can use a secure hashing algorithm like bcrypt. Here's an example of how you can modify the code to achieve this:
1. Install the bcrypt library by running the command `pip install bcrypt`.
2. Import the bcrypt library at the top of your code:
```python
import bcrypt
```
3. Modify the section where the password is obtained from the form and hashed before inserting it into the database:
```python
# Obtain the password from the form
password = request.form['password']
# Hash the password
hashed_password = bcrypt.hashpw(password.encode('utf-8'), bcrypt.gensalt())
# Insert the user's name, email, and hashed password into the database
cursor.execute("INSERT INTO users (name, email, password) VALUES (%s, %s, %s)", (name, email, hashed_password))
```
4. After making these changes, the user's password will be properly hashed using bcrypt before it is inserted into the database.
Note: Make sure to import the necessary modules (e.g., `flask`, `flask-mysql`) and establish a connection to the database before executing the `INSERT` statement. Also, don't forget to update the `redirect` URL to the login page after the user is inserted into the database.