Portal Home > Knowledgebase > Articles Database > MySQL status command


MySQL status command




Posted by osphere, 07-25-2010, 02:45 AM
Hi guys! here's the deal: I'm setting up a mysql server where many people will connect (via console and applications). Users will have limited priviliges such as create new tables & write/delete on their own tables. For security reasons I'm trying to not disclose too much information to the users (such as mysql server version). As one of the users, I can run the command 'status' from the mysql client and I get all this information: mysql Ver 14.14 Distrib 5.1.31, for redhat-linux-gnu (i386) using readline 5.1 Connection id: 33 Current database: Current user: usuario3@localhost SSL: Not in use Current pager: stdout Using outfile: '' Using delimiter: ; Server version: 5.1.00 Source distribution Protocol version: 10 Connection: 127.0.0.1 via TCP/IP Server characterset: latin1 Db characterset: latin1 Client characterset: latin1 Conn. characterset: latin1 TCP port: 4040 Uptime: 1 hour 52 min 39 sec Threads: 2 Questions: 125 Slow queries: 0 Opens: 17 Flush tables: 1 Open tables: 9 Queries per second avg: 0.18 I edited the binary of mysqld () to modify the server version number (thats why it shows 00 at the end). However I'm worried about the information at the bottom, the number of threads, questions, slow queries, etc. Is there a way I can block this information from being visible to the users? or completely disable the logging of this information on the server? Thank you very much guys!



Was this answer helpful?

Add to Favourites Add to Favourites    Print this Article Print this Article

Also Read
Domain registration? (Views: 589)