Results 1 to 8 of 8
Discuss MySQL 5.0 on Leopard. Login details...? at the Genuine Mac Support - Hackint0sh.org; I just installed MySQL 5.0 on my Mac mini running Leopard. Now when I connect ...
  1. #1
    Amazingly Knowledgeable Array jashsayani's Avatar

    Join Date
    Dec 2007
    Location
    Salt Lake City, UT
    Posts
    958
    Post Thanks / Like
    Downloads
    0
    Uploads
    0
    Rep Power
    55

    Question MySQL 5.0 on Leopard. Login details...?

    I just installed MySQL 5.0 on my Mac mini running Leopard. Now when I connect to localhost using MacSQL 3, The test database loads up. And when I press the create database button, it says that I dont have privileges to create it. I am the admin on the mac and the only user....

    And ideas on the login details for SQL.....? :hack:
    My iPhone
    iPhone 4 (32 GB) Black, Firmware 4.1

    My Mac mini
    2.0 GHz Dual core, 2GB RAM, 160 GB HDD, Leopard 10.5.8

    My MacBook
    2.0 GHz Dual core, 4 GB RAM, 160 GB HDD, SnowLeopard 10.6.4

    My Blogs:
    Jash's Blog: http://www.jashsayani.com
    The iFone Blog: http://theifoneblog.blogspot.com



  2. #2
    Senior Professional Array

    Join Date
    Apr 2007
    Posts
    191
    Post Thanks / Like
    Downloads
    0
    Uploads
    0
    Rep Power
    17

    Default

    MySQL uses it's own permissions, not your system ones.

    By default, MySQL will use "root"@"localhost" as your username (enter "root") and a blank password.

    If you are trying to use another user account, odds are you will need to do a "GRANT ALL on *.<database_name> to <username>@<host>;" and a "FLUSH PRIVILEGES"

    ~Adrian

  3. #3
    Amazingly Knowledgeable Array jashsayani's Avatar

    Join Date
    Dec 2007
    Location
    Salt Lake City, UT
    Posts
    958
    Post Thanks / Like
    Downloads
    0
    Uploads
    0
    Rep Power
    55

    Default

    Thanks for your reply. I could login as root with a blank password. However, is there a way to setup an additional user and assign all administrative privileges to the user....?

    I am using MacSQL v3
    My iPhone
    iPhone 4 (32 GB) Black, Firmware 4.1

    My Mac mini
    2.0 GHz Dual core, 2GB RAM, 160 GB HDD, Leopard 10.5.8

    My MacBook
    2.0 GHz Dual core, 4 GB RAM, 160 GB HDD, SnowLeopard 10.6.4

    My Blogs:
    Jash's Blog: http://www.jashsayani.com
    The iFone Blog: http://theifoneblog.blogspot.com

  4. #4
    iPhone Moderator Array

    Join Date
    Aug 2007
    Posts
    3,620
    Post Thanks / Like
    Downloads
    0
    Uploads
    0
    Rep Power
    220

    Default

    Quote Originally Posted by jashsayani View Post
    Thanks for your reply. I could login as root with a blank password. However, is there a way to setup an additional user and assign all administrative privileges to the user....?

    I am using MacSQL v3
    Check here for details (didn't you say you installed MySQL 5???):

    http://dev.mysql.com/doc/refman/5.0/...ing-users.html


    hope this helps
    Read the stickies and search the forum before posting!
    If you want to become a Hackint0sh supporter click here
    ----------
    iPhone 4 factory unlocked, iOS 4.3.1, jailbroken
    iPad Wi-Fi + 3G (1G), iOS 4.3.1, jailbroken
    iPad 2

  5. #5
    iPhone Moderator Array

    Join Date
    Aug 2007
    Posts
    3,620
    Post Thanks / Like
    Downloads
    0
    Uploads
    0
    Rep Power
    220

    Default

    Anyway, here is the page for MySQL 3/4

    http://dev.mysql.com/doc/refman/4.1/...ing-users.html
    Read the stickies and search the forum before posting!
    If you want to become a Hackint0sh supporter click here
    ----------
    iPhone 4 factory unlocked, iOS 4.3.1, jailbroken
    iPad Wi-Fi + 3G (1G), iOS 4.3.1, jailbroken
    iPad 2


  6. #6
    Amazingly Knowledgeable Array jashsayani's Avatar

    Join Date
    Dec 2007
    Location
    Salt Lake City, UT
    Posts
    958
    Post Thanks / Like
    Downloads
    0
    Uploads
    0
    Rep Power
    55

    Default

    Quote Originally Posted by volkspost View Post
    Check here for details (didn't you say you installed MySQL 5???):

    http://dev.mysql.com/doc/refman/5.0/...ing-users.html


    hope this helps
    Hi. I did install MySQL 5 and am using MacSQL for managing my MySQL databases and settings...

    Anyways, thanks for the link.
    My iPhone
    iPhone 4 (32 GB) Black, Firmware 4.1

    My Mac mini
    2.0 GHz Dual core, 2GB RAM, 160 GB HDD, Leopard 10.5.8

    My MacBook
    2.0 GHz Dual core, 4 GB RAM, 160 GB HDD, SnowLeopard 10.6.4

    My Blogs:
    Jash's Blog: http://www.jashsayani.com
    The iFone Blog: http://theifoneblog.blogspot.com

  7. #7
    iPhone Moderator Array

    Join Date
    Aug 2007
    Posts
    3,620
    Post Thanks / Like
    Downloads
    0
    Uploads
    0
    Rep Power
    220

    Default

    Quote Originally Posted by jashsayani View Post
    Hi. I did install MySQL 5 and am using MacSQL for managing my MySQL databases and settings...

    Anyways, thanks for the link.
    If you want to manage it via webbrowser (local, local network, Internet) consider PHPmyAdmin (http://www.phpmyadmin.net/home_page/index.php). You need to have running PHP but this is a great tool for managing MySQL databases.
    Read the stickies and search the forum before posting!
    If you want to become a Hackint0sh supporter click here
    ----------
    iPhone 4 factory unlocked, iOS 4.3.1, jailbroken
    iPad Wi-Fi + 3G (1G), iOS 4.3.1, jailbroken
    iPad 2

  8. #8
    Amazingly Knowledgeable Array jashsayani's Avatar

    Join Date
    Dec 2007
    Location
    Salt Lake City, UT
    Posts
    958
    Post Thanks / Like
    Downloads
    0
    Uploads
    0
    Rep Power
    55

    Default

    Quote Originally Posted by volkspost View Post
    If you want to manage it via webbrowser (local, local network, Internet) consider PHPmyAdmin (http://www.phpmyadmin.net/home_page/index.php). You need to have running PHP but this is a great tool for managing MySQL databases.
    Thanks. I have installed PHP on Apache. Will check it out...
    My iPhone
    iPhone 4 (32 GB) Black, Firmware 4.1

    My Mac mini
    2.0 GHz Dual core, 2GB RAM, 160 GB HDD, Leopard 10.5.8

    My MacBook
    2.0 GHz Dual core, 4 GB RAM, 160 GB HDD, SnowLeopard 10.6.4

    My Blogs:
    Jash's Blog: http://www.jashsayani.com
    The iFone Blog: http://theifoneblog.blogspot.com

 

 

Similar Threads

  1. Next Snow Leopard Update and details (10.6.5)
    By hotwheelharry in forum Installation
    Replies: 1
    Last Post: 09-21-2010, 03:09 PM
  2. Slashdot: OS X Snow Leopard Details
    By hackint0sh in forum Latest Headlines
    Replies: 0
    Last Post: 06-13-2008, 07:50 PM
  3. [MobileChat] login details at risk or no..?
    By sukatoro in forum Free Toolchain Software (Cydia App's)
    Replies: 0
    Last Post: 04-28-2008, 11:36 PM
  4. MacNN: Vvidget 10.5.4 does Leopard/MySQL connection
    By hackint0sh in forum Latest Headlines
    Replies: 0
    Last Post: 04-18-2008, 10:40 PM

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
  •  
Powered by vBulletin®
Copyright © 2014 vBulletin Solutions, Inc. All rights reserved.
Search Engine Friendly URLs by vBSEO
(c) 2006-2012 Hackint0sh.org
All times are GMT +2. The time now is 03:30 PM.
twitter, follow us!