Cory wrote:You can create new users and change their passwords by editing the mysql database under the user table correct?
Wrong. The passwords are encrypted by the their creation process in phpMyAdmin when you create that database and you create a user/pass combo for that database - changes can be made under the
Privileges menu item for that user once created.
Cory wrote:How do you login with a different user?
If you wish to login to phpMyAdmin to access that database using that database's username and password you will only be able to access or see that database associated with that username -
root user can see and edit all databases - see note below.
NOTEDon't use the super user
root as a username for any database you create, it will seriously weaken your server's security, use a different username as
root has access to all databases and if in the wrong hands can devastate
ALL MySQL databases.