{"id":536,"date":"2009-08-07T09:05:45","date_gmt":"2009-08-07T15:05:45","guid":{"rendered":"http:\/\/www.mooreds.com\/wordpress\/archives\/000536"},"modified":"2009-08-07T09:05:45","modified_gmt":"2009-08-07T15:05:45","slug":"using-phpmyadmin-without-the-show-databases-privilege","status":"publish","type":"post","link":"https:\/\/www.mooreds.com\/wordpress\/archives\/536","title":{"rendered":"Using phpMyAdmin without the “Show Databases” privilege"},"content":{"rendered":"

phpMyAdmin<\/a> is a pretty cool piece of software, and a very useful tool. If you haven’t used it before, it’s a full featured web-based interface to MySQL<\/a> databases. You can use it to add data, update data, delete data, export data, and basically any other management of the database you might need.<\/p>\n

I ran into an issue the other day. I was trying to allow phpMyAdmin to access a database on a remote host. The user that phpMyAdmin was connecting as didn’t have the “show databases” privilege (I imagine this is common in shared hosting environments, which is what this was). This, apparently, is what phpMyAdmin uses to populate the drop-down of databases on the left-hand side after you login. Since it didn’t display that drop-down, there is no way of selecting the database to which this user did have access.<\/p>\n

I searched for a while, but couldn’t find anyone else with this problem. So I thought I would post the solution I found.<\/p>\n

The solution is to hard code authentication data for the remote server in my config.inc.php<\/code> file.\u00a0 Then, you append the server and the database that you want to connect to the phpMyAdmin url.<\/p>\n

In the config.inc.php<\/code> file:
\n$cfg['Servers'][$i]['host'] = 'xxx.xxx.xx.xx';
\n$cfg['Servers'][$i]['user'] = 'user';
\n$cfg['Servers'][$i]['password'] = 'pass';<\/code><\/p>\n

In the url that normal users use to access the database:
\nhttp:\/\/phpMyAdmin.example.com\/phpMyAdmin\/index.php?db=databasename&server=xxx.xxx.xxx.xxx<\/code><\/p>\n

The left hand side still isn’t populated with any databases. But, this allows you to go directly to the database to which you do have access, and perform whatever tasks you want (and have permissions for). I tried adding the “db” parameter to the config.inc.php<\/code> file, but that didn’t seem to work. I didn’t try using any other form of authentication than hardcoded, as I wanted to make this as simple as possible for the phpMyAdmin users.<\/p>\n

I was running an older version of phpMyAdmin (2.11.9.5); I didn’t test this on newer versions.\u00a0 If you do, please post a comment and let me know if this still works.<\/p>\n

[tags]phpmyadmin,mysql privileges,remote database access[\/tags]<\/p>\n","protected":false},"excerpt":{"rendered":"

phpMyAdmin is a pretty cool piece of software, and a very useful tool. If you haven’t used it before, it’s a full featured web-based interface to MySQL databases. You can […]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[28,17,33],"tags":[],"class_list":["post-536","post","type-post","status-publish","format-standard","hentry","category-mysql","category-php","category-useful-tools"],"_links":{"self":[{"href":"https:\/\/www.mooreds.com\/wordpress\/wp-json\/wp\/v2\/posts\/536","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.mooreds.com\/wordpress\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.mooreds.com\/wordpress\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.mooreds.com\/wordpress\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.mooreds.com\/wordpress\/wp-json\/wp\/v2\/comments?post=536"}],"version-history":[{"count":0,"href":"https:\/\/www.mooreds.com\/wordpress\/wp-json\/wp\/v2\/posts\/536\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.mooreds.com\/wordpress\/wp-json\/wp\/v2\/media?parent=536"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.mooreds.com\/wordpress\/wp-json\/wp\/v2\/categories?post=536"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.mooreds.com\/wordpress\/wp-json\/wp\/v2\/tags?post=536"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}