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`) ) EN