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! 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. 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'" 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. 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. Link to comment https://forums.phpfreaks.com/topic/10807-mysql-user-permissions/#findComment-40590 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.