MySQL user right

		Wrox Programmer Forums > PHP/MySQL > MySQL
MySQL user right

MySQL General discussion about the MySQL database.

Welcome to the p2p.wrox.com Forums.

You are currently viewing the MySQL section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com

April 20th, 2006, 03:41 AM

Mantis

Friend of Wrox

Join Date: Dec 2004

Posts: 154

Thanks: 0

Thanked 0 Times in 0 Posts

MySQL user right

Hi,

I'm doing a small PHP program at the moment and I've noticed something "weird".

I created a new user: test
test has no right at all.. everything is N (no)
I can login to the server fine but when I do:
mysql_list_dbs
I get 1 database (information_schema) showing ??? How can that be, 'test' doesn't have SELECT (it doesn't have anything for that matter)??

Please inlight me!!

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
MySQL said: select command denied to user: 'root@	surendran	MySQL	2	September 9th, 2010 12:27 AM
MySQL "Select Denied to user" Problem	djidave	ASP.NET 2.0 Professional	5	May 29th, 2007 03:06 PM
MySQL "Select Denied to user" Problem	djidave	ASP.NET 2.0 Professional	2	May 25th, 2007 04:38 PM
Run DTS with a windows user, not a SQL user	Kalli	SQL Server DTS	1	September 15th, 2005 11:53 PM
Mysql Graphic User Interface for Db administration	karib	MySQL	3	January 6th, 2005 08:32 AM