O'Reilly Forums: Help Problem Creating Database - O'Reilly Forums

Jump to content

Page 1 of 1
  • You cannot start a new topic
  • You cannot reply to this topic

Help Problem Creating Database

#1 User is offline   steveador 

  • New Member
  • Pip
  • Group: Members
  • Posts: 2
  • Joined: 27-August 12

Posted 27 August 2012 - 05:32 AM

Hi I'm new to this,

I installed MAMP (OS 10.6.8) and following along with the book and instruction on page 160, entering:
/Applications/MAMP/Library/bin/mysql -u root -p

then,

mysql> SHOW databases;

seemed to correctly result with:

+--------------------+
| Database |
+--------------------+
| information_schema |
+--------------------+
1 row in set (0.00 sec)

but when I went to CREATE DATABASE publications; (on page 165)

mysql> CREATE DATABASE publications;

I got this

ERROR 1044 (42000): Access denied for user ''@'localhost' to database 'publications'

it would seem I didn't set myself up as (the root) user correctly? or missed getting my username in there?

Any suggestions as to where to go from here to (re)set my self up with root user name / permissions and password? or how to to just start over? not sure where to go from here... Thank You!

Steve
0

#2 User is offline   steveador 

  • New Member
  • Pip
  • Group: Members
  • Posts: 2
  • Joined: 27-August 12

Posted 28 August 2012 - 03:26 AM

--Nevermind, I figured it out... a port number issue...thx
0

Share this topic:


Page 1 of 1
  • You cannot start a new topic
  • You cannot reply to this topic

1 User(s) are reading this topic
0 members, 1 guests, 0 anonymous users