NTS Forums

Please login or register.

Login with username, password and session length
 

News:

Welcome to the Newtek Technology Services Forum!


Author Topic: how to create a table in mysql?  (Read 3177 times)

Offline lmayers3

  • Hosting Newbie
  • *
  • Posts: 6
  • Karma: +0/-0
how to create a table in mysql?
« on: July 06, 2014, 10:34:05 AM »
I've written an sql script to create tables in an already existing database, but when I run it in MySQL workbench, I get an error saying Error Code: 1142. CREATE command denied to user 'name'@'123.45.678.901' for table 'tblName'.

How can I change the permissions for the database user to allow me to create tables?

Offline r937

  • Hero Member
  • *****
  • Posts: 1,015
  • Karma: +31/-1
    • http://r937.com/
Re: how to create a table in mysql?
« Reply #1 on: July 07, 2014, 12:01:01 PM »
do a google search for "CREATE command denied to user"

i think you need to use GRANT ALL PRIVILEGES ON ...