This website is deprecated, and remains online only for historic access to old issues and docs for historic versions of Virtualmin. It has been unmaintained for several years, and should not be relied on for up-to-date information. Please visit www.virtualmin.com instead.

Created remote access for one DB but shows all DBs on server

5 posts / 0 new

Topic locked

Last post

#1 Tue, 08/02/2016 - 17:18

jonas-2

Created remote access for one DB but shows all DBs on server

Hi, I created a remote user for a specific DB as follows:

1. "Mysql Database Server" -> "User Permissions" -> Hosts with the source IP (67.xx.xx.xx)

2. "Mysql Database Server" -> "Database Permissions" -> same user as above (1)

When I connect using MySQL WorkBench from the remote machine, I see all the databases on the server. What gives? Am I missing some security settings?

Any help is much appreciated!

#2 Thu, 08/04/2016 - 05:32

unborn

Hi - are you connecting to remote db as root user? or just as a db user?

Configuring/troubleshooting Debian servers is always great fun

#3 Thu, 08/04/2016 - 15:51

jonas-2

Hi unborn,

Sorry I should have been clearer on that. It's a DB user created via "Mysql Database Server" -> "User Permissions" -> "Create New User"

Under "Mysql Database Server" -> "Database Permissions", this specific user has access only to the desired database. The database name is entered verbatim with no wild card.

I'm on Centos 6.6 with Mysql Ver 14.14 Distrib 5.5.43 just in case it matters.

Thanks for your help!

#4 Mon, 08/08/2016 - 05:45

jonas-2

Bump...

Anyone?

#5 Tue, 08/09/2016 - 04:50

jonas-2

help!

Topic locked