# create-user.sql - OpenCart database account creation script
#
# This script will create the userid and password for the OpenCart database.
#
#   * cartdb is the name of the database (same as $db1{name} in cart.pm)
#   * cart is the userid (same as $db1{user} in cart.pm)
#   * buyme is the password (same as $db1{pass} in cart.pm)
#
# The values defined here must agree with those used in the cart.pm module
# found in the cgi-bin directory.  To add the user to the database, simply
# run the script as follows:
#
#    mysql < create-user.sql
#

# connect to the mysql database
use mysql;

# create the userid
GRANT ALL on cartdb.* To 'cart'@'localhost' IDENTIFIED BY 'buyme';

# commit the updates
flush privileges;