Debian mySQL setup

Discussion in 'Server & Community Management' started by Luther, May 22, 2013.

  1. Been trying to figure out how to set up a database and user for mySQL.
    My OS is Debian, and I'm trying to do this through SSH. Any insight on how to do this would help a lot.
    Also, for plugins like
    The configuration calls for tables. Must I create each table? Or will the plugin automatically create the tables through the mySQL user.
    #1 Luther, May 22, 2013
    Last edited: May 22, 2013
  2. create database ban-management;

    "Modify the config file with your database details, you do not have to create the tables, the plugin will do that for you"
  3. CarpeCervisia

    Can't seem to figure out how to log in to sql via SSH.
    Trying to create a database gives me this error:
    Code (Text):
    ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
  4. Did you setup your mySQL root password?

    mysql -u root -p

    then it should prompt you for your password
  5. That's what I was looking for. I had already set it up but couldn't remember how to log in.
    Thanks! :)