Re: [SLE] mysql
From: Jim Cunning (jcunning_at_cunning.ods.org)
Date: 09/29/05
- Previous message: Ronald Wiplinger: "[SLE] mysql"
- In reply to: Ronald Wiplinger: "[SLE] mysql"
- Next in thread: Scott Leighton: "Re: [SLE] mysql"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Date: Wed, 28 Sep 2005 21:39:28 -0700 (PDT) To: Suse <suse-linux-e@suse.com>
On Sep 29 at 12:30pm, 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?
You don't need to worry about the "0 rows affected" -- that's normal. What
you do need to do is FLUSH PRIVILEGES; in mysql. This will cause the
privileges set in the grant tables to be reloaded by the server.
Jim
-- 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
- Previous message: Ronald Wiplinger: "[SLE] mysql"
- In reply to: Ronald Wiplinger: "[SLE] mysql"
- Next in thread: Scott Leighton: "Re: [SLE] mysql"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Relevant Pages
|
|
