Portal   Forum   Members   Market   Gallery   Events

MySQL - OS X

Discussion in 'Help Forum' started by Jakeman, Oct 29, 2002.

  1. Jakeman

    Jakeman MSC Founder and Donator

    Joined:
    Feb 26, 2000
    Messages:
    25,759
    Likes Received:
    27
    Market Rating:
    16
    i'm doing a vBulletin install on an OS X server for this guy. i need to create a new database for his forums so i login to his shell and try to bring up the mysql prompt:

    mysql -uusername -p <hit enter>
    password <hit enter>
    Error 1045: permission denied for user (username@localhost)...etc

    he isn't sure what to do and neither am i. he has the user created under OS X and is able to login to the finder with that user.

    cow? harley? linux boy? i mean haite :p
     
  2. harleyb

    harleyb Peasant

    Joined:
    Aug 12, 2002
    Messages:
    866
    Likes Received:
    9
    Market Rating:
    0
    the MySQL user database doesn't relate to the NetInfo database. i thought i explained this to you yesterday... the guy has to create the MySQL user through the MySQL monitor (or whatever management tool he uses). get this through: they're completely different user situations.
     
  3. filburt1

    filburt1 Peasant

    Joined:
    Jul 23, 2002
    Messages:
    802
    Likes Received:
    0
    Market Rating:
    0
    username == root, password == nothing
     
  4. Jakeman

    Jakeman MSC Founder and Donator

    Joined:
    Feb 26, 2000
    Messages:
    25,759
    Likes Received:
    27
    Market Rating:
    16
    he just figured it out
     
  5. filburt1

    filburt1 Peasant

    Joined:
    Jul 23, 2002
    Messages:
    802
    Likes Received:
    0
    Market Rating:
    0
    I bet I was right :yeah: :suspect:
     
  6. cowofwar

    cowofwar Peasant

    Joined:
    Jun 14, 2000
    Messages:
    13,721
    Likes Received:
    18
    Market Rating:
    0
    I alrways did
    % su
    % ./mysql --user=root --password=blah create xxx
     
  7. Haite

    Haite Forum Moderator

    Joined:
    Jan 29, 2001
    Messages:
    9,325
    Likes Received:
    34
    Market Rating:
    0
    I think what harleyb was trying to get across was that actual computer users and MySQL users are entirely different entities. You create MySQL databases with their own MySQL users. SQL has its own user list that has no relation to the computer running it.

    For example, on macintoxication.com I logged in with username macintox (both for the administration panel and in shells), but the user for my vB SQL database was macintox_vbb, which I had to create separately.
     
  8. Jakeman

    Jakeman MSC Founder and Donator

    Joined:
    Feb 26, 2000
    Messages:
    25,759
    Likes Received:
    27
    Market Rating:
    16
    yeah, he found his mysql manager and set the root password.

    no. you didn't anything about separate user databases or the mysql manager yesterday. you just said to make sure the user has the right credentials.
     
  9. harleyb

    harleyb Peasant

    Joined:
    Aug 12, 2002
    Messages:
    866
    Likes Received:
    9
    Market Rating:
    0
  10. Jakeman

    Jakeman MSC Founder and Donator

    Joined:
    Feb 26, 2000
    Messages:
    25,759
    Likes Received:
    27
    Market Rating:
    16
    bah, never assume. i have learned to always start with the basics when troubleshooting any problem.
     
  11. Haite

    Haite Forum Moderator

    Joined:
    Jan 29, 2001
    Messages:
    9,325
    Likes Received:
    34
    Market Rating:
    0
    That's what tech support people always do, and like cow said they have to repeat everything the customer says :yeah:.
     

Hitometer: 53,932,109 since 1995