Posts

Showing posts from March, 2015

MySQL Database Cookbook

-- MYSQL Cookbook. Make databases and tables, create a user, set his password
-- the password shown here "PutYourFavePasswordHere" should be changed to your
-- preferred password, before running these scripts.
-- Instructions:
-- SSH into your MYsql server or open a dos prompt on your server
-- use this command to logon to mysql as the root user:   mysql -u root -p
-- Copy & paste these scriptlets into the window, or save them to a file, and use
-- this command to run them:  source afile.sql;
-- that's all.
--
-- MAKE A DATABASE FOR MAGENTO CE EDITION

DROP database magento_ce;
CREATE DATABASE magento_ce;
USE magento_ce;
GRANT ALL ON magento_ce.* TO magentosql@localhost IDENTIFIED BY 'PutYourFavePasswordHere';
FLUSH PRIVILEGES;


-- ADD AN ISAM TABLE FOR STORE LOCATIONS
CREATE TABLE IF NOT EXISTS `location` (
`id` int(10) NOT NULL AUTO_INCREMENT,
`lat` varchar(256) NOT NULL,
`lan` varchar(256) NOT NULL,
`name` varchar(128) NOT NULL,
PRIMARY KEY (`id`) )
ENGINE=MyISAM DEFAULT CHARSET=…