MySql Problem

Discussion in 'Bukkit Help' started by john924xps, May 17, 2012.

Thread Status:
Not open for further replies.
  1. Offline

    john924xps

    Theres thing I dont get. How the HELL do you install MySql? I've searched tons of videos, and they all included MAMP, this random program. Would someone please give me a basic tutorial on installing MySql, please? If this helps, I use a mac.

    No suggestion? :(

    EDIT by Moderator: merged posts, please use the edit button instead of double posting.
     
    Last edited by a moderator: May 25, 2016
  2. Offline

    Paswaru

  3. Offline

    john924xps

    Yes. And then? What file do you RUN??
     
  4. Offline

    HunterT

    Dude, What operating system do you have?
     
  5. Offline

    john924xps

    I use a mac..

    Bump. please help

    I guess no-one here knows? :( Ok then

    EDIT by Moderator: merged posts, please use the edit button instead of double posting.
     
    Last edited by a moderator: May 25, 2016
  6. Offline

    Rjames426

    I use Xampp on Linux but its available for every OS. Download it, open the .DMG and drop the Xampp folder in your Applications folder, that installs it. Now to run it open XAMPP Control and start Apache, MySQL and ProFTPD. Now you should be able to go to "localhost" in your browser.

    Like this if it helped!
     
  7. Offline

    Paswaru

    You can start and stop the server using the preference panel you installed in the forth link (step 4). So long as it starts, you have MySQL installed. Beyond that you get into administering a MySQL server, which isn’t something that can be broken down into a step by step guide without knowing exactly what you’re trying to setup. Each plugin will be a bit different. Some will setup their database, tables and structure automatically; you only need to specific the address and port for the SQL server (which is going to be localhost and port 3306). Others will require you to run a SQL script to do all that. Some may require configuration of a special database driver.

    Once the server is started one of the first things you will want to do is set a password for root (not to be confused with OSX’s root account). You do this by running the following command in terminal.

    Code:
    /usr/local/mysql/bin/Mysqladmin –u root password THENEWPASSWORD
    You can run commands against the server by running the MySQL client, but unless you know SQL it won’t do you much good. Best to let the program handle that stuff or follow their setup instructions.

    Code:
    /usr/local/mysql/bin/mysql –u root –p
    That is pretty much what MAMP is.

    EDIT by Moderator: merged posts, please use the edit button instead of double posting.
     
    Last edited by a moderator: May 25, 2016
  8. Offline

    Rjames426

    1. Mamp is not a random program. 2. I gave you a basic tutorial on how to install Xampp, I would suggest trying to use Xampp. "Pretty much what Mamp is", thats because they ARE the same, Wamp, Lamp, Mamp, and Xamp (X meaning for any OS) are all Apache, MySQL, and PhpMyAdmin just for different OS's.

    The answer to your request "basic tutorial", was answered in post #9 of this thread.
     
  9. Offline

    Paswaru

    The "That is pretty much what MAMP is" comment was referring to the indvidual programs MAMP and XAMPP, not the solution stack. MAMP is packaged and maintained a by different group and contain some different programs outside of (A)pache, (M)ySQL and (P)HP.
     
  10. Offline

    john924xps

    Thanks guys, I got most of what you said! Except: The preference panel and MAMP, are they BOTH CRUCIALLY required?
     
  11. Offline

    Paswaru

    The preference panel isn't required for a MySQL install, but it will make it easier to start and stop the server.

    As for MAMP (the program). MAMP is a bundled install. It will install Apache Web Server, MySQL and PHP. It will also install phpMyAdmin which is a web interface into the SQL database. You may find having a web interface to the database easier to use. Both will get you a SQL server.

    http://www.mamp.info/en/index.html
     
  12. Offline

    john924xps

    So... Which one do you recommend? MAMP or just MySQL?
     
  13. Offline

    Paswaru


    I'm going to recommended XAMPP.
    http://www.apachefriends.org/en/xampp-macosx.html

    It will give you the same core stuff with less extra stuff like the Zend Framework. Unless your going to be developing PHP code, the extra stuff in MAMP you won't need.

    If your going to switch, we need to uninstall the MySQL install from earlier. To do that you need to run the following list of commands in terminal.

    Code:
    sudo /Library/StartupItems/MySQLCOM/MySQLCOM stop
    sudo rm /usr/local/mysql
    sudo rm -rf /usr/local/mysql*
    sudo rm -rf /Library/StartupItems/MySQLCOM
    sudo rm -rf /Library/PreferencePanes/My*
    edit /etc/hostconfig and remove the line MYSQLCOM=-YES-
    rm -rf ~/Library/PreferencePanes/My*
    sudo rm -rf /Library/Receipts/mysql*
    sudo rm -rf /Library/Receipts/MySQL*
    sudo rm -rf /private/var/db/receipts/*mysql*
    
     
  14. Offline

    john924xps

    Yes. I have. Would you (sorry) mind giving me a full tut? Cause Im kinda muddled up about download this, no dont, yes, no. Bleh. Make one for me pls. Thanks a lot Paswary :3
     
  15. Offline

    Paswaru

    *I'm assuming you where able to run the commands to uninstall the MySQL server we install earlier. If not let me know and I'll try to make that easier to do.*

    I normal reply to OSX things from work where I have access to a Mac. That way I can run through the steps and make sure there are no problems, but I'm winging this one from videos. I'm breaking it down into groups of steps. If you run into a problem in a group of steps. Stop there and let me know.

    I recommend you watch the videos, but don't do any of the steps yet. This way you have an idea of the screens your going to be seeing. After you watch them, then proceed threw the steps.



    1) Download XAMPP at this link
    http://www.apachefriends.org/download.php?xampp-macosx-1.7.3.dmg
    2) Mount the DMG by double clicking it.
    3) You will get a panel with the XAMPP folder and the Application Folder.
    Drag and Drop XAMPP onto Application.
    [​IMG]


    At this point its install, we just need to launch it.
    1) In your Dock, click on Finder, then Click on Applications.
    2) In your list of Applications, you will see a folder XAMPP. Double Click the Folder.
    3) Double Click XAMPP Control.
    (It will launch a little Window. You may have to move other Windows around to see it.)
    [​IMG]
    4) On the XAMPP Control, click Start beside MySQL.
    *Enter your account password*
    *If prompted to allow incoming connections, select Allow*
    5) On the XAMPP Control, click Start beside Apache.
    6) Launch a Brower and type http://localhost and have a look around.

    A Note: XAMPP will not auto start when you reboot, you will have to go to a XAMPP control and start it each time. There is a way to do a StartupItems, but I'll need access on a Mac to test it. So I'll post that Monday.


    You now have Apache and MySQL installed and running, on to some basic Administration.


    1) Open Terminal
    2) Copy and Paste this line into Terminal

    Code:
    sudo /Applications/XAMPP/xamppfiles/xampp security
    *Enter your password*

    3) For question "Your XAMPP pages are NOT secured by a password."
    Type N for No and Press Enter.
    4) For question "MySQL is accessable via network."
    Type N for No and Press Enter.
    5) For question "The MySQL/phpMyAdmin user pma has no password set."
    Type N for No Press Enter.
    (Note: I would normal recommend setting a password for pma but it breaks on Windows, I'll test it on OSX Monday and if it does not break, we'll go back and address that.)

    6) For question "MySQL has no root password set."
    Type Y for Yes and Press Enter.
    *Enter the password you want to use*
    *Type password again*
    7) For question "Do you want to change the password anways."
    Type N for No and Press Enter.

    8) Goto XAMPP Control
    [​IMG]
    9) Click Stop on MySQL then Click Start
    10) Click Stop on Apache then Click Start

    At this point we are ready to point CraftBukkit and some plugins to use the SQL server. Was there a particular plugin you planned on using?
     
    garrett2smart87 likes this.
  16. Offline

    john924xps

    You forgot the part On how to install MySQL itself XP well, I get teh xampp part now. But what bout MySQL? Do I have to install EVERYTHING you said in your first reply here?? Sorry for inconvinience caused. But you truly are a great teAcher. :)

    Pas
    sorry I didnt understand everything in the first
    Place...

    EDIT by Moderator: merged posts, please use the edit button instead of double posting.
     
    Last edited by a moderator: May 25, 2016
  17. Offline

    Paswaru

    XAMPP will install MySQL as part of its install. So you need to remove the MySQL we installed in my first reply.
     
  18. Offline

    john924xps

    I tried the command to uninstall mySQL, but it said directory not found. can you give me the actual destinations of the folder, so I can manually remove it? Thanks
     
  19. Offline

    Paswaru

    /usr/local/mysql is where the main application is located. If you didn't run all three of the installers earlier, I'd expect there be some directory's not found. So no big worries.
     
    john924xps likes this.
  20. Offline

    john924xps

    Oke. Thanks! Liked :)
     
  21. Offline

    john924xps

    Just asking. HOW AMI SUPPOSED TO CREATE A DATABASE? Sorry, its fly pissing me off. Ive got xampp, but no idea how you Crete a database...
     
  22. Offline

    jacklin213

    goto MySQL the localhost page and there should be a button called "createdatabase"
     
  23. Offline

    Paswaru

    Goto http://localhost/phpmyadmin
    On the top menu, click on databases.
    In the Create new database text box, enter a name for your database.
    Leave the pull down menu on Collation
    Then click the create button.

    If your planning on using this mysql for plugins, let me know the name of a plugin you plan to use with it and I'll write a guide on configuring the database for you.
     
    john924xps likes this.
  24. Offline

    john924xps

    LogBLock :)

    New problem. I can't access PhpMyAdmin. Where it says Create New Database, it says I don't have permission... Help? Im using XAMPP on a MAC

    EDIT by Moderator: merged posts, please use the edit button instead of double posting.
     
    Last edited by a moderator: May 25, 2016
  25. Offline

    Paswaru

    When you went to phpMyAdmin, did it prompt you to login as root?

    [​IMG]

    Also which version of OSX are you using?

    EDIT by Moderator: merged posts, please use the edit button instead of double posting.
     
    Last edited by a moderator: May 25, 2016
  26. Offline

    john924xps

    I don't know yet. When I get on my comp, I will tell you. And no, it didn't prompt me for ANYTHING

    I THINK I may be usin mac osx the latest version. 13inch

    EDIT by Moderator: merged posts, please use the edit button instead of double posting.
     
    Last edited by a moderator: May 25, 2016
  27. Offline

    jacklin213

    r u creating the data base with the admin account
     
  28. Offline

    john924xps

    Dude. I can't even accerss the root account. And I do not know the password...
     
  29. Offline

    jacklin213

    i mean r u the admin user of the computer
     
  30. Offline

    john924xps

Thread Status:
Not open for further replies.

Share This Page