Results 1 to 3 of 3

Thread: Add a new user

  1. #1
    Join Date
    Jan 2004
    Location
    Australia
    Posts
    42

    Unanswered: Add a new user

    How do I add a new user who can connect from anywhere to the database server?
    username is alan
    password is alan

  2. #2
    Join Date
    Jan 2005
    Posts
    362

    Admin

    You can use administrator tools like Mysql Administrator - Mycc from mysql.com
    or sql manager lite (http://sqlmanager.net/products/mysql/manager/) with host option % or i think simply sql (see mysql site for options)
    dimis

  3. #3
    Join Date
    Jan 2004
    Location
    Australia
    Posts
    42
    Finally, I found this works:
    Grant all on machineA.* to alan@"%" identified by 'alan'

    However, I found strange thing is when I use DOS prompt to issue command:
    mysql -h localhost -u alan -palan
    use databaseA

    It works.

    BUT not the following:
    mysql -h 192.168.1.xx -u alan -palan
    use databaseA <-- cause access deny

    It did not allow me to access the databaseA.
    Both command issued in the machine where the MySQL installed.

Posting Permissions

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