RE: [SLE] mysql

From: Albert (albert_at_fastworx.com)
Date: 09/29/05

  • Next message: Albert: "FW: [SLE] FW: WiFi looses connection" 
    To: <suse-linux-e@suse.com>
Date: Thu, 29 Sep 2005 09:24:48 +0200

    Ronald Wiplinger wrote:
    > > 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 !!!!

    I executed the above GRANT statement on my MySQL server (4.1.10) after
    creating a database 'ser'.

    After which I could log in with user 'ser' and had access to database 'ser'.

    In mysql.user I have a user 'ser' with all privileges set to 'N'.

    In mysql.db I have a user 'ser' with db 'ser' with all privileges except
    Grant_priv set to 'Y'

    If you want user 'ser' to have all privileges set to 'Y' in mysql.user add
    the user as follows:

    GRANT ALL PRIVILEGES ON *.* TO 'ser'@'localhost' IDENTIFIED BY 'password'
    WITH GRANT OPTION;

    Take not that this will create a user that have access to **ALL** databases
    with **ALL** privileges. This user will have the same rights as the 'root'
    user.

    Albert 

    -- 
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.344 / Virus Database: 267.11.8/114 - Release Date: 2005/09/28
 
-- 
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: Albert: "FW: [SLE] FW: WiFi looses connection"