This is beyond the scope of the question but next I would be looking into hooking the unix user creation process to automatically creating a matching MySQL user account. Your MySQL username password will be 'root' if you have not changed the default password setup in MAMP PRO. I also created a MySQL account with the same username as my unix account, again with no password, and using the root account I granted it access to the tables I needed, then I could also connect from apps from my user account without changing to root. You usually set the root user password for MySQL when you first install the product, but with some software bundles the default password is an non-secure. On the more recent versions of MAMP the default password for created databases is: root. If you are using an older version of MAMP or having trouble connecting to your database, then the default password may be set to nothing, so leave the field empty. To test open a new Terminal and do sudo su then mysql and check if it connects with no password (this didn't work when a password was set). On the more recent versions of MAMP the default password for created databases is: root. I connected as root using the password then ran: I also created a root password at installation and wanted to change back to using unix authentication once I understood that if I run commands or launch apps as root they can connect to the database without any password which is much simpler than having another password.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |