prorsum — 2013-03-28T13:05:11-04:00 — #1
I've did a manual installation of MySql, PHP and PHPMyAdmin in a Mac Lion.
When I go to localhost/phpmyadmin I get a window that says: Welcome to PHPMyadmin. Log in: Username and password. I've never set this during the installation. So where do I do this? Someone told me I could put root and no password, but this doesn't let me go in. Anyway, I really want to set a password.
Thanks a lot.
starlion — 2013-03-28T17:47:11-04:00 — #2
You did a manual installation of mysql. Did you go through the process of adding a new user?
prorsum — 2013-03-28T18:16:58-04:00 — #3
No, I have this panel. How do I do it?
starlion — 2013-03-29T10:24:09-04:00 — #4
http://dev.mysql.com/doc/refman/5.6/en/default-privileges.html is probably going to be the most beneficial thing i can point you at... basically, you need to secure the root user, the anonymous (blank) user, and probably create a new superuser for safety. PHPMyAdmin comes with a (configurable) setting which prevents you from using a blank login.
prorsum — 2013-03-29T10:48:51-04:00 — #5
well, that doesn't address Macs, only Windows and Unix...
scannon — 2013-03-29T11:05:19-04:00 — #6
The underpinnings of the MacOS IS Unix.
The following link describes two ways to setup your PHPMyAdmin username and password.