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)