I've got a user, admFrederic
He got the grants shown below.
Those are correct and I configured them that way.
mysql> SHOW GRANTS FOR admFrederic;
+-----------------------------------------------------------------------
----------------+
| Grants for [EMAIL PROTECTED]
|
+-----------------------------------------------------------------------
----------------+
| GRANT USAGE ON *.* TO 'admFrederic'@'%' IDENTIFIED BY PASSWORD
'6ddf5e1a1cc75e8a' |
| GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, ALTER ON `cehdb`.* TO
'admFrederic'@'%' |
+-----------------------------------------------------------------------
----------------+
But, when I log in using that username. That user can access the main
database...
mysql> show databases;
+----------+
| Database |
+----------+
| cehdb |
| mysql |
+----------+
Does anyone know how to fix this?
Only cehdb should be accessable.
Also, the user can run SQL commands on the mysql database.
GRANT commands etc. are not possible.
This is the version info.
mysql> status;
--------------
mysql Ver 11.18 Distrib 3.23.53, for Win95/Win98 (i32)
Connection id: 351
Current database:
Current user: [EMAIL PROTECTED]
Server version: 4.1.0-alpha-max-nt
Protocol version: 10
Connection: nemesis via TCP/IP
Client characterset: latin1
Server characterset: latin1
TCP port: 3333
Uptime: 1 hour 6 min 14 sec
Thanks,
Joris
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
