Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2004
    Location
    Chicago
    Posts
    54

    Unanswered: How to create database from remote client?

    I am using mySQL client to access mysql on another box. I cannot create database:

    mysql> create database db1;
    ERROR 1044: Access denied for user: 'scott@192.168.0.127' to database 'db1'

    User 'scott@192.168.0.127' can perform other tasks except creating a database. Why?
    Do I have to use the server box to grant scott authority for db1 which does not exist yet?
    Thanks!

  2. #2
    Join Date
    Mar 2004
    Posts
    480
    You likely need to grant create privileges for this user before a new database can be made.

  3. #3
    Join Date
    Jan 2004
    Location
    Chicago
    Posts
    54
    Thanks.
    I did a grant all privileges on *.* and now it works.

Posting Permissions

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