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

Results 1 to 6 of 6
  1. #1
    Join Date
    May 2008
    Location
    Germany
    Posts
    28

    [Not a bug, solved] mysql creat_tables

    My server doesn't want to create the mysql tables.
    ini files are correct...

    When entering the sql commands for tablecreation the phpmyadmin states this error:

    Code:
    Fehler
    SQL-Befehl:
    
    CREATE INDEX index_channel_properties_id ON channel_properties(
    
    id
    );
    
    MySQL meldet: 
    
    #1142 - INDEX command denied to user 'web1'@'localhost' for table 'channel_properties'
    Anything wrong with my mysql version 5.0.51a-24+lenny3 ?

  2. #2
    Join Date
    January 2010
    Location
    Secret Base in Arctic Region
    Posts
    1,671
    Does the user Teamspeak uses to connect to MySQL have the permission to create indexes?
    You can check by entering the following query in MySQL
    Code:
    SHOW GRANTS FOR [email protected];

  3. #3
    Join Date
    May 2008
    Location
    Germany
    Posts
    28
    Code:
    Grants for [email protected]
    GRANT USAGE ON *.* TO 'web1'@'localhost' IDENTIFIED BY PASSWORD '*********'
    GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, ALTER, CREATE TEMPORARY TABLES, LOCK TABLES ON `usr\_web1\_12`.* TO 'web1'@'localhost' WITH GRANT OPTION
    GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, ALTER, CREATE TEMPORARY TABLES, LOCK TABLES ON `usr\_web1\_3`.* TO 'web1'@'localhost' WITH GRANT OPTION
    GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, ALTER, CREATE TEMPORARY TABLES, LOCK TABLES ON `usr\_web1\_1`.* TO 'web1'@'localhost' WITH GRANT OPTION
    GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, ALTER, CREATE TEMPORARY TABLES, LOCK TABLES ON `usr\_web1\_7`.* TO 'web1'@'localhost' WITH GRANT OPTION.

  4. #4
    Join Date
    January 2010
    Location
    Germany / Frankfurt
    Posts
    29
    The web1-user needs the right to create indices.
    Code:
    GRANT INDEX, SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, ALTER, CREATE TEMPORARY TABLES, LOCK TABLES ON `usr\_web1\_12`.* TO 'web1'@'localhost' WITH GRANT OPTION
    GRANT INDEX, SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, ALTER, CREATE TEMPORARY TABLES, LOCK TABLES ON `usr\_web1\_3`.* TO 'web1'@'localhost' WITH GRANT OPTION
    GRANT INDEX, SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, ALTER, CREATE TEMPORARY TABLES, LOCK TABLES ON `usr\_web1\_1`.* TO 'web1'@'localhost' WITH GRANT OPTION
    GRANT INDEX, SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, ALTER, CREATE TEMPORARY TABLES, LOCK TABLES ON `usr\_web1\_7`.* TO 'web1'@'localhost' WITH GRANT OPTION

  5. #5
    Join Date
    January 2010
    Location
    Secret Base in Arctic Region
    Posts
    1,671
    Dont know if you have admin-access to the DBMS.
    The best (and shortest) way to grant permissions needed is to execute
    Code:
    GRANT ALL ON db.* TO [email protected];
    in MySQL, where "db" is the database name and "user" the user name.

  6. #6
    Join Date
    May 2008
    Location
    Germany
    Posts
    28
    #solved

    thank you guys!
    Last edited by Killingmarv; April 6th, 2010 at 12:30 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [Solved] Mysql problems
    By ChaosStarFire in forum Windows
    Replies: 2
    Last Post: August 16th, 2010, 08:35 AM
  2. [solved] Troubles getting TS3 to start with MySQl
    By Jessay in forum Server Support
    Replies: 25
    Last Post: July 31st, 2010, 08:07 PM
  3. [solved] MySQL Problem
    By kedal in forum Linux
    Replies: 8
    Last Post: July 7th, 2010, 02:07 PM
  4. [solved] Beta 17 with MYSQL
    By evendco in forum Linux / FreeBSD
    Replies: 6
    Last Post: February 3rd, 2010, 05:44 PM
  5. [Solved] MySQL Setup Problems
    By LordNova2 in forum Server Support
    Replies: 8
    Last Post: January 14th, 2010, 01:21 AM

Posting Permissions

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