First Python Script - Web Scraper with results saved to MySQL DB
Here are some notes grouped by categories.
HTML Parsing
Instead of collecting names and amounts in separate lists, iterate over the elements with a tab_row class and collect the results into a single list of dictionaries.
You can get performance improvements by switching to lxml from html.parser. Requires lxml to be installed.
You can use more concise CSS selectors instead of find_all().
You can also use SoupStrainer class that would allow to improve on parsing speed by limiting what the parsing tree to the desired part only.
Working with the database
First of all, do not use string formatting to pass your query parameters into the query. You are not only exposing your code to SQL injection attacks, but also get potential issues with character escaping and type conversions. Use parameterized queries instead.
If you are gonna collect your data into the list of dictionaries, you may do your insert via executemany() which, aside from being more concise,
may provide a performance boost as well.
It is also a good idea to use multi-line strings for your database queries.
Code Style
There are multiple code style issues. The code is not PEP8-complaint. Please analyze your code with flake8, pylint or other linters.
Also, don't repeat the database connection code, extract it into a separate function and reuse.

Here is the modified version of the code (renamed functions and logically separated into multiple functions):
import sys
import urllib2

import MySQLdb as mdb
from bs4 import BeautifulSoup, SoupStrainer

import dbconfig as cfg


def db_connect():
    connection = mdb.connect(cfg.mysql['host'], cfg.mysql['user'], cfg.mysql['passwd'], cfg.mysql['db'])
    cursor = connection.cursor()
    
    connection.set_character_set('utf8')
    cursor.execute('SET NAMES utf8;')
    cursor.execute('SET CHARACTER SET utf8;')
    cursor.execute('SET character_set_connection=utf8;')

    return connection, cursor


def pull_games(page):
    parse_only = SoupStrainer(class_='tab_row')
    soup = BeautifulSoup(page, 'lxml', parse_only=parse_only)

    return [
        {
            'name': row.h4.get_text(),
            'price': row.select_one(&quot;.discount_original_price&quot;).get_text(),
            'discount': row.select_one('.discount_final_price').get_text()
        }
        for row in soup.select(&quot;.tab_row&quot;)
    ]


def insert_games(connection, cursor, data):
    query = &quot;&quot;&quot;
        INSERT INTO 
          game_pricing
          (game_name, original_price, discount_price)
      VALUES
          (%(name)s, %(price)s, %(discount)s)
    &quot;&quot;&quot;
    cursor.executemany(query, data)
    connection.commit()


def check_games(cursor):
    query = &quot;&quot;&quot;
        SELECT 
            game_name, original_price, discount_price 
        FROM 
            game_pricing
    &quot;&quot;&quot;
    cursor.execute(query)

    result = cursor.fetchall()
    for game_name, original_price, discount_price in result:
        print(&quot;game_name=%s, original_price=%s, discount_price=%s&quot; % (game_name, original_price, discount_price))


if __name__ == '__main__':
    reload(sys)
    sys.setdefaultencoding('UTF8')

    url = 'http://localhost'
    page = urllib2.urlopen(url)

    games = pull_games(page)

    try:
        connection, cursor = db_connect()
        insert_games(connection, cursor, games)
    
        check_games(cursor)
    finally:
        cursor.close()
        connection.close()