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