Click here for Toll-Free Service for your business starting at $2.00 per month
Started by sasurfers, August 30, 2006, 01:46:08 AM
-- # $Id: mysql_create.sql,v 1.1 2003/02/27 19:04:51 jimmerman Exp $-- #-- # Create a database called 'phpesp'.CREATE DATABASE phpesp;-- # Switch to the mysql database.USE mysql;-- # Create a user called 'phpesp', with a password 'phpesp'. The-- # 'localhost' limits this user to connecting to the database only via-- # localhost. You may change the password by changing the-- # PASSWORD('...') clause.INSERT INTO user (host, user, password) VALUES ( 'localhost', 'phpesp', PASSWORD('phpesp'));-- # Grant the 'phpesp' user (from 'localhost') privileges to select,-- # insert, update, and delete on the database 'phpesp'.INSERT INTO db (host, db, user, select_priv, insert_priv, update_priv, delete_priv) VALUES ( 'localhost', 'phpesp', 'phpesp', 'Y', 'Y', 'Y', 'Y');-- # Tell mysql to re-read the privileges tables so the previous two-- # operations take effect.FLUSH PRIVILEGES;
QuoteMySQL said: Documentation#1044 - Access denied for user 'Samm'@'%' to database 'phpesp'
QuoteCreate new database Create new database: DocumentationNo Privileges