Warning: Function ereg() is deprecated in ..../includes/class_postbit.php(345) : eval()'d code on line 4

Warning: Function split() is deprecated in ..../includes/class_postbit.php(345) : eval()'d code on line 19

Warning: Function ereg() is deprecated in ..../includes/class_postbit.php(345) : eval()'d code on line 4

Warning: Function split() is deprecated in ..../includes/class_postbit.php(345) : eval()'d code on line 19

Warning: Function ereg() is deprecated in ..../includes/class_postbit.php(345) : eval()'d code on line 4

Warning: Function split() is deprecated in ..../includes/class_postbit.php(345) : eval()'d code on line 19
MySQL database user creation help needed
Results 1 to 3 of 3

Thread: MySQL database user creation help needed

  1. #1
    Moderator
    Good Guru
    Compunuts's Avatar
    Join Date
    May 2001
    Location
    California
    Posts
    3,935

    MySQL database user creation help needed

    Okay, I"m not very familiar with MySQL so here goes.

    I'm being able to add users using GRANT command. But all my users are being able to manipulate ALL the database created. How do I get the database only to specific user? For example, if I created mydata database using account "compunuts", then when user "compunuts" log in, he will only see "mydata" database but no one else?

    TIA

    To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
    - The truely community run Linux/Floss forum !

    No IT BS !!

  2. #2
    Code:
    GRANT ALL ON DATABASE.* TO 'USER'@'localhost' IDENTIFIED BY 'PASSWORD';
    "In the heat of conversation I may have said certain things I believe to be untrue. The alleged lie that you might have heard me saying allegedly moments ago ... thats a parasite that lives in my neck." -- Tad Ghostal

  3. #3
    Moderator
    Good Guru
    Compunuts's Avatar
    Join Date
    May 2001
    Location
    California
    Posts
    3,935
    But then this user is not being able to create their own database.

    I want a user to also create their own database but access to only those database that user is created.

    To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
    - The truely community run Linux/Floss forum !

    No IT BS !!

Similar Threads

  1. need help configuring Openldap with mysql database
    By ryswick in forum Linux - Software, Applications & Programming
    Replies: 1
    Last Post: 12-08-2010, 09:15 PM
  2. Problem in Linux System User Creation!
    By honey bee in forum Linux - Hardware, Networking & Security
    Replies: 7
    Last Post: 06-01-2006, 08:33 PM
  3. moving database from its default directory where mysql puts on new databases
    By infinite_root in forum Linux - Hardware, Networking & Security
    Replies: 2
    Last Post: 05-15-2004, 11:52 PM
  4. MySQL database creation error
    By Compunuts in forum Linux - Hardware, Networking & Security
    Replies: 6
    Last Post: 10-24-2003, 06:09 AM
  5. Iptables logging to MySql database
    By xkill in forum Linux - Software, Applications & Programming
    Replies: 1
    Last Post: 02-11-2002, 07:45 PM

Bookmarks

Posting Permissions

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