{"id":14098,"date":"2017-02-07T14:08:23","date_gmt":"2017-02-07T13:08:23","guid":{"rendered":"https:\/\/www.oderland.se\/support\/artikel\/hur-skapar-jag-flera-inloggningar-till-phpmyadmin\/"},"modified":"2021-05-27T14:26:01","modified_gmt":"2021-05-27T13:26:01","slug":"how-do-i-create-additional-logins-for-phpmyadmin","status":"publish","type":"ht_kb","link":"https:\/\/www.oderland.se\/support\/en\/artikel\/how-do-i-create-additional-logins-for-phpmyadmin\/","title":{"rendered":"How do I create additional logins for phpMyAdmin?"},"content":{"rendered":"\n

To manage databases on our web hosting accounts, you use phpMyAdmin. You’re able to access it by logging on to cPanel<\/a> and clicking the phpMyAdmin<\/code> icon under Databases<\/code>. This works fine as long as you have access to the login credentials for cPanel. But of you’re the only one with access to those credentials and don’t want to hand them over to anyone else, only you will be able to use phpMyAdmin this way.<\/p>\n\n\n\n

One way to get around this problem is to install phpMyAdmin on your account, circumventing the need to log on to cPanel entirely. You can install it manually, or via Softaculous (also accessible via cPanel). These instructions will describe how you perform the installation via Softaculous.<\/p>\n\n\n\n

Begin by logging on to cPanel<\/a> and clicking the icon Softaculous Apps Installer<\/code> under Software<\/code>.<\/p>\n\n\n\n

\"\"<\/a><\/figure><\/div>\n\n\n\n

Once there, use the search field in the top left and search for phpMyAdmin<\/code>. Click Install<\/code> when you’ve found it.<\/p>\n\n\n\n

\"cpanel-softaculous-phpmyadmin\"<\/a><\/figure>\n\n\n\n

Then, choose domain and directory for the installation. Also, make sure that localhost<\/code> is entered under Database Host<\/code>. When you’re done with the selections, click Install<\/code>.<\/p>\n\n\n\n

\"\"<\/a><\/figure>\n\n\n\n

Once the installation is completed, you should be able to access phpMyAdmin via the URL you selected, e.g.<\/em> exempel.se\/phpmyadmin.<\/p>\n\n\n\n

When you visit the URL for your own installation of phpMyAdmin, you will reach a login page. Here, you log in with the credentials for any database user you’ve created<\/a> and given access to the database(s) of your choice<\/a>. You will only have access to databases the database user has been granted access to.<\/p>\n\n\n\n

\"\"<\/a><\/figure>\n\n\n\n

If you have not yet created any databases on your web hosting account, you need to do so. We’ve written instructions here<\/a> describing the process. Keep in mind that you have to go through the entire process of creating the database, creating a database user and add that user to the database. You’ll then be able to log in on your phpMyAdmin installation using those credentials.<\/p>\n\n\n\n

If you want to access multiple databases with the same database user, add the user to all databases as described above. If you want to add more logins to phpMyAdmin, simply create more database users and add them to the databases.<\/p>\n","protected":false},"excerpt":{"rendered":"

To manage databases on our web hosting accounts, you use phpMyAdmin. You’re able to access it by logging on to cPanel and clicking the phpMyAdmin icon under Databases. This works fine as long as you have access to the login credentials for cPanel. But of you’re the only one with…<\/p>\n","protected":false},"author":12,"comment_status":"open","ping_status":"closed","template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"ht-kb-category":[197],"ht-kb-tag":[],"class_list":["post-14098","ht_kb","type-ht_kb","status-publish","format-standard","hentry","ht_kb_category-databases"],"acf":[],"_links":{"self":[{"href":"https:\/\/www.oderland.se\/support\/en\/wp-json\/wp\/v2\/ht-kb\/14098","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.oderland.se\/support\/en\/wp-json\/wp\/v2\/ht-kb"}],"about":[{"href":"https:\/\/www.oderland.se\/support\/en\/wp-json\/wp\/v2\/types\/ht_kb"}],"author":[{"embeddable":true,"href":"https:\/\/www.oderland.se\/support\/en\/wp-json\/wp\/v2\/users\/12"}],"replies":[{"embeddable":true,"href":"https:\/\/www.oderland.se\/support\/en\/wp-json\/wp\/v2\/comments?post=14098"}],"version-history":[{"count":8,"href":"https:\/\/www.oderland.se\/support\/en\/wp-json\/wp\/v2\/ht-kb\/14098\/revisions"}],"predecessor-version":[{"id":14152,"href":"https:\/\/www.oderland.se\/support\/en\/wp-json\/wp\/v2\/ht-kb\/14098\/revisions\/14152"}],"wp:attachment":[{"href":"https:\/\/www.oderland.se\/support\/en\/wp-json\/wp\/v2\/media?parent=14098"}],"wp:term":[{"taxonomy":"ht_kb_category","embeddable":true,"href":"https:\/\/www.oderland.se\/support\/en\/wp-json\/wp\/v2\/ht-kb-category?post=14098"},{"taxonomy":"ht_kb_tag","embeddable":true,"href":"https:\/\/www.oderland.se\/support\/en\/wp-json\/wp\/v2\/ht-kb-tag?post=14098"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}