Quick Question About MySQL

Discussion in 'Bukkit Help' started by SlyCooperMan, Nov 18, 2011.

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

    SlyCooperMan

    I have a running server, people are able to connect to it and everything. Recently I've been looking for a good logging command, and I went around servers I go on and saw what they used. A majority of them use LogBlock, so that's what I decided to use. This is the first time I ever successfully set up a MySQL database, and after I set it up, I went and set up LogBlock. I went through the config and started my server. For some reason I'm having trouble with the database name. I went on the MySQL command line and used \s to get the database information.
    \S (open)
    --------------
    C:\Program Files (x86)\MySQL\MySQL Server 5.5\bin\mysql.exe Ver 14.14 Distrib 5
    .5.17, for Win32 (x86)

    Connection id: 4
    Current database:
    Current user: root@localhost
    SSL: Not in use
    Using delimiter: ;
    Server version: 5.5.17 MySQL Community Server (GPL)
    Protocol version: 10
    Connection: localhost via TCP/IP
    Server characterset: latin1
    Db characterset: latin1
    Client characterset: latin1
    Conn. characterset: latin1
    TCP port: 3306
    Uptime: 16 min 19 sec

    Threads: 1 Questions: 14 Slow queries: 0 Opens: 34 Flush tables: 1 Open tab
    les: 27 Queries per second avg: 0.014
    --------------

    As you can see in the spoiler, there is no database name appearing. I was wondering if A. there was a way to change the database name, or B. if there was any way to use a blank database name in the LogBlock config.yml.
     
  2. Offline

    Geoff Winans

    Log into MySQL.

    CREATE DATABASE dbnamehere;
    GRANT ALL ON dbnamehere.* TO 'username'@'localhost' IDENTIFIED BY 'your.password.here';
    FLUSH PRIVILEGES;

    And now you can tell Logblock the dbname, user and password you just specified.

    Use HawkEye. Logblock is just bad.
     
  3. Offline

    SlyCooperMan

    Well, I guess it's worth a try.

    Thanks for the help!
     
Thread Status:
Not open for further replies.

Share This Page