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