EKINdesigns Posted May 30, 2006 Share Posted May 30, 2006 Hey guys. How can i get the current users mysql permissions?I connected to the database.Should i run a query?Help is much appreciated! Quote Link to comment https://forums.phpfreaks.com/topic/10807-mysql-user-permissions/ Share on other sites More sharing options...
trq Posted May 31, 2006 Share Posted May 31, 2006 You would need to run a SELECT statement on the [i]mysql[/i] databases [i]user[/i] table. Quote Link to comment https://forums.phpfreaks.com/topic/10807-mysql-user-permissions/#findComment-40401 Share on other sites More sharing options...
EKINdesigns Posted May 31, 2006 Author Share Posted May 31, 2006 OK thanks...thats what i thought, ill give it a try.I get an "Access denied for user: 'user@localhost' to database 'mysql'" Quote Link to comment https://forums.phpfreaks.com/topic/10807-mysql-user-permissions/#findComment-40449 Share on other sites More sharing options...
trq Posted May 31, 2006 Share Posted May 31, 2006 More than likely you need to be root (or maybe mysql) to login to the [i]mysql[/i] database. Quote Link to comment https://forums.phpfreaks.com/topic/10807-mysql-user-permissions/#findComment-40455 Share on other sites More sharing options...
poirot Posted May 31, 2006 Share Posted May 31, 2006 I guess you can know the privileges by "trial and error", what means, executing queries and see what happens. Quote Link to comment https://forums.phpfreaks.com/topic/10807-mysql-user-permissions/#findComment-40590 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.