I'm trying to divide up my databases between different users, as using root is probably not the most secure thing to do.
Problem is, when I create a user in phpmyadmin, that user never has permission to actually login to phpmyadmin, so I always have to login as root to manage the databases.
Is there a way to make it so the user can login to phpmyadmin? I want that user to only see it's own database.
The weird part is if I try to use mysql command line, it never even prompts me for a password for the new user, and I can't see anything but the test and information_schema database. It's like if it's not assigning the password properly nor the link to the database.
Problem is, when I create a user in phpmyadmin, that user never has permission to actually login to phpmyadmin, so I always have to login as root to manage the databases.
Is there a way to make it so the user can login to phpmyadmin? I want that user to only see it's own database.
The weird part is if I try to use mysql command line, it never even prompts me for a password for the new user, and I can't see anything but the test and information_schema database. It's like if it's not assigning the password properly nor the link to the database.
Last edited:
Facebook
Twitter