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? bye Ronald Wiplinger
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
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 -- POPFile, the OpenSource EMail Classifier http://popfile.sourceforge.net/ Linux 2.6.11.4-21.9-default x86_64 SuSE Linux 9.3 (x86-64)
----- Original Message -----
From: "Scott Leighton"
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' 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
Brad Dameron wrote:
----- Original Message ----- From: "Scott Leighton"
To: 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.
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
On Wednesday 28 September 2005 10:19 pm, Brad Dameron wrote:
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:
I stand corrected. You are right, when using GRANT the changes are noticed by the server..... 5.7.7. When Privilege Changes Take Effect When mysqld starts, all grant table contents are read into memory and become effective for access control at that point. When the server reloads the grant tables, privileges for existing client connections are affected as follows: Table and column privilege changes take effect with the client's next request. Database privilege changes take effect at the next USE db_name statement. Changes to global privileges and passwords take effect the next time the client connects. If you modify the grant tables using GRANT, REVOKE, or SET PASSWORD, the server notices these changes and reloads the grant tables into memory again immediately. If you modify the grant tables directly using statements such as INSERT, UPDATE, or DELETE, your changes have no effect on privilege checking until you either restart the server or tell it to reload the tables. To reload the grant tables manually, issue a FLUSH PRIVILEGES statement or execute a mysqladmin flush-privileges or mysqladmin reload command. If you change the grant tables directly but forget to reload them, your changes have no effect until you restart the server. This may leave you wondering why your changes don't seem to make any difference Scott -- POPFile, the OpenSource EMail Classifier http://popfile.sourceforge.net/ Linux 2.6.11.4-21.9-default x86_64 SuSE Linux 9.3 (x86-64)
participants (5)
-
Albert
-
Brad Dameron
-
Jim Cunning
-
Ronald Wiplinger
-
Scott Leighton