----- 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