Forum


Notice to all users

We are migrating towards a new forum system located at community.teamspeak.com, as such this forum will become read-only on January 29, 2020

Page 4 of 4 FirstFirst ... 234
Results 46 to 47 of 47
  1. #46
    Join Date
    October 2009
    Location
    here
    Posts
    1

    Exclamation

    MYSQL Requires a password on remote connections. Try setting up an account and give it full permissions to the schema you Chreated for it.

    Quote Originally Posted by JonathanNet View Post
    Hi iam running ts3 server 64 bit, but can't get mysql to work

    I have created a file named: ts3db_mysql.ini with info:

    Code:
    [config]
    host=192.168.10.100
    port=3306
    username=******
    password=******
    database=teamspeak3
    socket=mysql
    And I have created a file: ts3server.ini with info:

    Code:
    machine_id=
    default_voice_port=9987
    voice_ip=0.0.0.0
    licensepath=
    filetransfer_port=30033
    filetransfer_ip=0.0.0.0
    query_port=10011
    query_ip=0.0.0.0
    dbplugin=ts3db_mysql
    dbpluginparameter=ts3db_mysql.ini
    dbsqlpath=sql/
    dbsqlcreatepath=create_mysql/
    logpath=logs
    logquerycommands=1
    Then I try to start it with command line: ts3server_win64 inifile=ts3server.ini

    I get this error:

    Code:
    2009-12-19 16:55:13.073125|INFO    |ServerLibPriv |   | Server Version: 3.0.0-beta1 [Build: 9366]
    2009-12-19 16:55:13.073125|INFO    |DatabaseQuery |   | dbPlugin name:    MySQL plugin, (c)TeamSpeak Systems GmbH
    2009-12-19 16:55:13.073125|INFO    |DatabaseQuery |   | dbPlugin version: 1
    2009-12-19 16:55:13.088750|ERROR   |DatabaseQuery |   | mysql_real_connect() failed with error: Access denied for user 'root'@'localhost' (using password: NO)
    2009-12-19 16:55:13.088750|CRITICAL|ServerLibPriv |   | Server() DatabaseError
    Seems to use the root user, although I have entered the user and password, can any one help me with this problem?

    Kind regards
    Jonathan

  2. #47
    Join Date
    December 2009
    Location
    Germany
    Posts
    62
    Your database password is wrong, or is your database username is incorrect.
    2009-12-19 16:55:13.088750|ERROR |DatabaseQuery | | mysql_real_connect() failed with error: Access denied for user 'root'@'localhost' (using password: NO)
    The problem I had. I simply left out port and Soked and then it worked. Of course, that right is your database user @ (each host) must have.

    My configuration is as follows:

    Code:
    [config]
    host=*.*.*.*
    username=******
    password=******
    database=teamspeak3
    And:
    Code:
    machine_id=1
    default_voice_port=9987
    voice_ip=*.*.*.*
    licensepath=
    filetransfer_port=30033
    filetransfer_ip=*.*.*.*
    query_port=10011
    query_ip=*.*.*.*
    dbplugin=ts3db_mysql
    dbpluginparameter=ts3db_mysql.ini
    dbsqlpath=sql/
    dbsqlcreatepath=create_mysql/
    logpath=logs
    logquerycommands=1

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. FreeBSD 9.0 / 9.2 and TeamSpeak3 MySQL db dont work
    By jacekg in forum Linux / FreeBSD
    Replies: 2
    Last Post: July 28th, 2014, 03:18 PM
  2. still dont work
    By Scania in forum Windows
    Replies: 4
    Last Post: January 21st, 2010, 05:33 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •