How to install a SQL database onto a linux?

Discussion in 'Bukkit Help' started by Kegan187, Feb 19, 2011.

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

    Kegan187

    I want to install a SQL database onto my Linux VPS, CentOS 5 32bit, so that I could run a few more plugins that I believe would enhance my server gameplay. I have yet to find a tutorial on how to install it. Any help?
     
  2. Offline

    Padeius Etoh

    your vps provider would be a good place to start, mysql is part of a normal amps server set up so i would be surprised if you didn't already have it.
     
  3. Offline

    mughi

  4. Offline

    Kegan187

    Thanks @mughi Ill check that out!
     
  5. Offline

    mughi

    note: i simply found that via a google search for "centos mysql"

    i cannot verify how well it works/applies to your situation
     
  6. Offline

    Kegan187

    Okay, thank you.
     
  7. Offline

    Chugger

    I wrote a gathering of info on this post:
    http://www.minecraftforum.net/viewtopic.php?f=25&t=173507
    But I still have a bad address to my database and haven't found the correct way to point to it. It worked breifly and after a computer reboot, I couldn't connect again. I have no idea what the problem is :(
     
  8. Offline

    Obsidian

    Use "localhost" for the connection address, and make sure mysql is running. For ubuntu and ubuntu-like systems, "sudo service mysql status" will tell you if mysql is running. "sudo service mysql start" will start mysql if it's not running, afterwards.
     
  9. Offline

    Kegan187

    I am using localhost and it won't let me sign in. I set the password and everything, but the password doesn't work.
     
  10. Offline

    jwideman

    I had to do a bit of legwork myself and it's actually easier than it first appears, so I'll be glad to help. Exactly how did you set the password?
     
  11. Offline

    Kegan187

    I stop mysql using /etc/init.d/mysqld stop and then start it up with no password using mysqld_safe --skip-grant-tables & . I then logged into mysql using mysql -u root and attempted to create a password by typing in update user set password=81480****** where User='root'; . I says that no rows were changed. I then type flush privileges; and quit mysql. Then I restart mysql by typing /etc/init.d/mysqld stop and /etc/init.d/mysql start . Next I try and login using mysql -u root -p and then typing in my password. I get an error message saying ERROR 1045
    Code:
    ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
    
     
  12. Offline

    jwideman

    I bet your password is still blank. Try this in your shell:
    mysqladmin -u root password putyourpasswordhere
     
  13. Offline

    Kegan187

    It says this error
    Code:
    mysqladmin: Can't turn off logging; error: 'Access denied; you need the SUPER privilege for this operation'
    
    
    --- merged: Feb 27, 2011 4:30 AM ---
    bump
     
Thread Status:
Not open for further replies.

Share This Page