Re: [SLE] mysql

From: Ronald Wiplinger (ronald_at_elmit.com)
Date: 09/29/05

  • Next message: jdd sur free: "Re: [SLE] Looking for my mail in a lost Linux partition" 
    Date: Thu, 29 Sep 2005 15:03:39 +0800
To: Brad Dameron <brad@seatab.com>

    Brad Dameron wrote:

    >
    > ----- Original Message ----- From: "Scott Leighton"
    > <helphand@pacbell.net>
    > To: <suse-linux-e@suse.com>
    > Sent: Wednesday, September 28, 2005 9:42 PM
    > Subject: Re: [SLE] mysql
    >
    >
    >> On Wednesday 28 September 2005 9:30 pm, Ronald Wiplinger wrote:
    >>
    >>> I am trying to setup ser. The script should create the database and
    >>> Grant all priveleges to the user ser.
    >>>
    >>> It does not grant the priveleges!
    >>>
    >>> I tried to login into mysql and do the command by hand:
    >>> mysql> GRANT ALL PRIVILEGES ON SER.* TO ser IDENTIFIED BY 'password';
    >>> Query OK, 0 rows affected (0.00 sec)
    >>>
    >>> 0 rows affected !!!!
    >>>
    >>> select * users shows the records with ser as user but with all flags
    >>> set
    >>> to N
    >>>
    >>> If I try to use phpMyAdmin I do not even see the records for ser.
    >>> I use the right server!
    >>>
    >>> Where is my thinking error?
    >>
    >>
    >> Privilege changes do not take plush until the server
    >> is restarted or you issue a 'flush privileges' command.
    >>
    >> Scott
    >>
    >
    > This is all incorrect. Priviledges from within MySQL are
    > instantaneous. The problem is your formating:
    >
    > GRANT ALL PRIVILEGES ON ser.* to 'ser'@'localhost' IDENTIFIED BY
    > 'password'
    >
    >

    I tried that too, but the table mysql.user does not change
    The priveliges are still all set to 'N'

    And something what I cannot explain at all, this record in the table
    does NOT show up in phpMyAdmin !!!!

    > localhost can be just that, or a IP or a hostname as long as it has
    > forward and reverse DNS or is in the hosts file.
    >
    > Brad Dameron
    > SeaTab Software
    > www.seatab.com
    >
    >
    > 

    -- 
Ronald Wiplinger  (CEO of ELMIT)
http://www.elmit.com  http://voip.elmit.com  http://e-paper.elmit.com 
Tel. (M) +886.939.775.516  (O) +886.2.2835.7765 (ENUM)   or FWD 511208
- I'm a SpamCon Foundation Member, #694, Verify it at http://www.spamcon.org
PS: Spam prevention!
Our system is protected with a spam prevention program. 
If you send us an e-mail, our system will send you a confirmation message back. Just reply to this confirmation message please. 
After receiving this confirmation message, our system will send the hold message (one) and all future messages (after the received confirmation message) to me without asking you again.
-- 
Check the headers for your unsubscription address
For additional commands send e-mail to suse-linux-e-help@suse.com
Also check the archives at http://lists.suse.com
Please read the FAQs: suse-linux-e-faq@suse.com
  • Next message: jdd sur free: "Re: [SLE] Looking for my mail in a lost Linux partition"

    Relevant Pages