DKY wrote:...I used to be able to have a username and password other than root in the older versions of MySQL, is this a new thing?
In phpMyAdmin you can create a new user under the
Privileges menu and give that new user a password and full
Global Privileges the same as the root user.
Then you can use that new user to login instead of the root user.
This is a note from the phpMyAdmin documentation:
A word about users:
Many people have difficulty understanding the concept of user management with regards to phpMyAdmin. When a user logs in to phpMyAdmin, that username and password are passed directly to MySQL. phpMyAdmin does no account management on its own (other than allowing one to manipulate the MySQL user account information); all users must be valid MySQL users.