Hello.


> music> mysql -u root -p

>..............................

> music untz$ mysql music_development <db/create.sql



Why haven't you added "-uroot -p" for you second action ? See:

  http://dev.mysql.com/doc/refman/5.0/en/error-access-denied.html









untz wrote:

> Hello there!

> 

> I am experiencing an error trying to make a DDL execute....

> 

> Am using Mac OS X Tiger and MySQL 5..

> 

> This is what I did:

> 

> music> mysql -u root -p

> Enter password: ******

> Welcome to the MySQL monitor.   Commands end with ; or \g.

> mysql> create database music_development;

> mysql> create database music_test;

> mysql> create database music_production;

> mysql> grant all on music_development.* to 'untz'@'localhost';

> mysql> grant all on music_test.* to 'untz'@'localhost';

> mysql> grant all on music_production.* to 'untz'@'localhost'  identified

> by 'dolphin';

> mysql>exit

> 

> Then I placed a create.sql DDL file in music/db

> 

> When I tried to run this file, I got the following error:

> 

> music untz$ mysql music_development <db/create.sql

> ERROR 1045 (28000): Access denied for user 'untz'@'localhost' (using 

> password: NO)

> 

> Any suggestions, hints, and tips are highly appreciated!

> 

> Kindest regards,

> 

> Unnsse

> 

> 



-- 
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.NET http://www.ensita.net/
   __  ___     ___ ____  __
  /  |/  /_ __/ __/ __ \/ /    Gleb Paharenko
 / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.NET
       <___/   www.mysql.com




-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to