Results 1 to 2 of 2
  1. #1

    adding ip masks for remote mysql connections

    Hello I am having some trouble getting this to work for me.
    I need to temp. allow access to all ips to remote mysql connection.
    I have centos and cant get the syntax right for some reason.

    mysql> grant all on this_db.* to userx@'%' identified by pass;
    ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'pass' at line 1

    thanks in advance.

  2. #2
    i figured it out i needed 'pass' not pass

Similar Threads

  1. remote mysql connections
    By PresFox in forum Web Hosting
    Replies: 4
    Last Post: 06-12-2005, 04:46 PM
  2. MySQL remote connections
    By EfreeZe in forum Hosting Security and Technology
    Replies: 6
    Last Post: 04-17-2005, 11:49 PM
  3. Remote MySQL connections
    By parsafliffum in forum Hosting Security and Technology
    Replies: 2
    Last Post: 07-07-2004, 08:14 PM
  4. remote MySQL connections
    By SarcasticDwarf in forum Web Hosting
    Replies: 5
    Last Post: 02-05-2004, 02:42 AM
  5. Remote connections to MySQL?
    By S2 Web Design in forum Web Hosting
    Replies: 8
    Last Post: 07-25-2001, 08:25 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
  •