How do I log into phpMyAdmin with another user?

Question

Steps to solve this: log in to phpmyadmin using root. Select privileges. Select the user you want to modify (i.e., to give log in privileges). If you already have given the host as any (%) now change it to localhost. Make sure you click on the option button "keep the old one" and update.

1Go browser & type localhost/phpmyadmin/2Go to User accounts.3Edit privileges from marked bellow image in last options root->localhost-> Yes->ALL PRIVILEGES->Yes-> Edit privileges.

How do I select a user in phpMyAdmin?

To create a new user, click the Add user account link near the bottom of the User accounts page (you must be a “superuser”, e.g., user “root”). Use the textboxes and drop-downs to configure the user to your particular needs.

How do I find my phpMyAdmin username and password?

Show activity on this post. You can access that database with the user/password used to login on the phpMyAdmin. You can also create new users (if you have permission to) under the tab Privileges > Add new User. Here you can create pairs of user-database with the same name and auto-permission-granting.

10 Answers1Reconfigure phpmyadmin.2Ctrl + Alt + T to launch terminal.3sudo dpkg-reconfigure phpmyadmin.4Connection method for MySQL database for phpmyadmin: unix socket.5Name of the database's administrative user: root.6Password of the database's administrative user: mysqlsamplepassword.7MySQL username for phpmyadmin: root.

Expert · Answer