SitePoint Sponsor

User Tag List

Results 1 to 5 of 5
  1. #1
    SitePoint Member
    Join Date
    Jun 2005
    Location
    Kennett Square, PA USA
    Posts
    16
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    MySQL on Leopard problems

    I have a development server that is an OS X 10.5.2 box.

    MySQL is started.

    I cannot access MySQL with phpMyAdmin even though I have defined the root mysql password in Server Administrator

    Also, I cannot access mysql from the command line.

    error message from command line is "Access denied for user 'root'@'localhost' (using password:YES)

    Anyone else having difficulties with mysql on Leopard?

    Thanks,

  2. #2
    reads the ********* Crier silver trophybronze trophy longneck's Avatar
    Join Date
    Feb 2004
    Location
    Tampa, FL (US)
    Posts
    9,854
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)
    that error means communications to the server service is working, but you're using the wrong password.
    Check out our new Industry News forum!
    Keep up-to-date with the latest SP news in the Community Crier

    I edit the SitePoint Podcast

  3. #3
    SitePoint Member
    Join Date
    Jun 2005
    Location
    Kennett Square, PA USA
    Posts
    16
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    In the OS X Server Admin application, I set the MySQL password and it is accepted.
    Then, restart the MySQL Service.

    It's as though I'm not communicating with the MySQL service.

  4. #4
    SitePoint Member
    Join Date
    Jun 2005
    Location
    Kennett Square, PA USA
    Posts
    16
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Again, just so nobody thinks this is resolved, I cannot connect to the mysql db on Leopard server.

    I cannot connect to mysql from command line.

    When I run OS X Server Admin, it is able to start mysqld and apparently change its password, but when I try to connect to the server, the password is rejected.

    I am using two separate methods in trying to connect:
    1. I have installed phpMyAdmin and modified its config file. I've done this many times on other servers.
    2. From the command line, I type mysql -u root -password "mypassword'

    In both cases, the error message indicates that the password is not correct, even though I am using the same password that I specified when I set it in Server Admin.
    I just installed this instance of OS X server. It was a clean install over a wiped clean drive. I have installed the latest server patch, bringing the server version up to 10.5.3.

  5. #5
    SitePoint Member
    Join Date
    Jun 2005
    Location
    Kennett Square, PA USA
    Posts
    16
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    I'll take part of the blame for this, but I do think that Apple's Server Admin application is misleading when it comes to MySQL.

    Anyway, here it is:

    In Server Admin, I set the MySQL root password, but it was not being recognized.

    The actual root password that MySQL wanted was the OS X system root password.

    I have no idea what Server Admin is setting when you specify the MySQL root password. Maybe you do. If so, I'd love to know.

    Thanks,


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
  •