I am new to SQL and have a couple of problems. I have MySQL running on NT4
fine. I can issue queries to the database and retrieve records, create new
I have a problem with the security side. I have tried to add users as per
the manual. Similar to what follows.
shell> mysql --user=root mysql
mysql> GRANT ALL PRIVILEGES ON *.* TO monty@localhost IDENTIFIED BY
'something' WITH GRANT OPTION;
however... The user never seems to appear in the user table and I cannot
logon using that user ID. I can issue an sql insert statement to add the
user, but despite it then appearing in the table, I still can't logon with
that user. At the moment I can only log on as root!