SitePoint Sponsor

User Tag List

Results 1 to 2 of 2

Thread: Mysql question

  1. #1
    SitePoint Member
    Join Date
    Jan 2012
    Posts
    3
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Mysql question

    I have read around on the site and thought I found a solution to my problem but alas that is not the case.

    I have downloaded Mysql as a dmg file onto my computer and installed it but when I go to start the server I am getting the following response out of my terminal.


    adam-hodnichaks-computer:~ adamhodnichak$ sudo /usr/local/mysql/bin/mysql -u root -p
    Enter password:
    ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)


    I am trying to get this set up to user with Ruby on Rails and any help would be greatly appreciated!

    Thanks,
    Adam

  2. #2
    Foozle Reducer ServerStorm's Avatar
    Join Date
    Feb 2005
    Location
    Burlington, Canada
    Posts
    2,699
    Mentioned
    89 Post(s)
    Tagged
    6 Thread(s)
    Hi,

    You could try resetting the password for root:
    Code:
    /etc/init.d/mysqld stop
    mysqld_safe --skip-grant-tables &
    mysql -u root
    mysql> use mysql;
    mysql> update user set password=PASSWORD("newrootpassword") where User='root';
    mysql> flush privileges;
    mysql> quit
    /etc/init.d/mysqld stop
    /etc/init.d/mysqld start
    Steve
    ictus==""


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •