The data in MySQL is unavailable in the website.

[sysulawliet]

I have run the website and can visit the website but the data in MySQL is unavailable. So, how can I connect the website with MySQL?

[apavlo]

I have run the website and can visit the website but the data in MySQL is unavailable.

What does that mean? Can you provide the error message?

[sysulawliet]

I can open the website by the port 8000 but I can not see any data from MySQL shown in the website. So, are there some things wrong in the connection between the website and MySQL. I have edited the credentials.py file:

# SECURITY WARNING: keep the secret key used in production secret!
SECRET_KEY = '123'

## ==============================================
## DATABASE CONFIGURATION
## ==============================================

DATABASES = {
    'default': {
        'ENGINE': 'django.db.backends.mysql',
        'NAME': 'ottertune', 
        'USER': 'root',
        'PASSWORD': '123321',
        'HOST': '',
        'PORT': '',
        'OPTIONS': {
            'init_command': "SET sql_mode='STRICT_TRANS_TABLES',innodb_strict_mode=1",
        },
    }
}

[dvanaken]

Can you sign up as a new user and login successfully?

[sysulawliet]

Yes, I can. I can create my project and know the Application Info. But there are no data available in the table of Filtered Results. How can I use ottertune to adjust the parameters of MySql by the website automatically?