I used the flush privileges command There are in total 6 databases
But only mysql and cehdb are visible. The MySQL version is 4.1.0-max-nt There are no other hosts configured for that user other then % Because it's mysql 4, the safe-show-database option is not usefull All the users that existed function normal I tried making some other users All of them have the same problem Some show the mysql database, others show yet an other database It's strange. Can't find any reasonable explanation <> But, when I log in using that username. That user can access the main <> database... <> <> <snip> <> <> Does anyone know how to fix this? <> Only cehdb should be accessable. < <Did you try to set the safe-show-database flag? Hm, let me see where I have put this... OK, I put it in my c:\winnt\my.ini. Here's the line: < <[mysqld] <safe-show-database < <This is generally the way to hide non-rights databases to users, on MySQL 3. It's the default behaviour since MySQL 4. < > Also, the user can run SQL commands on the mysql database. < <What does that mean? The user can successfully SELECT data from mysql.* ? Then it's a granted privilege that enables him to do so. Did you look at other GRANTS for other hosts than % ? < <> 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 < <What's the MySQL server version here, please? 3.23.53 (win) or 4.1.0-max-nt? Can't interpret your information here very well... < <-- <Yves Goergen <[EMAIL PROTECTED] <Please don't CC me (causes double mails) <http://firstknight.no-ip.com:4001/PixelBug.asp?Seed=030901210342>
