I created a private mysql instance to run my website but I'm not familiar with the process on how to connect my php app or phpMyAdmin to this new instance. I guess I first have to manually create a user using the cli but even here I have many questions is the root account open by default? Any guidance would be appreciated. asked 08 Apr '13, 16:43 Clooner |
Yes, you'll need to create your MySQL users and grant them permission to their databases via the After you've created your user and have set permissions, you can connect your PHP app to the database using "localhost" as the hostname, and your app's assigned port number as the MySQL port, and of course your database name, database username, and password. If you need phpMyAdmin, you'll need to install your own phpMyAdmin manually into a Static/CGI/PHP application. The root account is not open. The root password is available in the "extra info" field in your app info at https://my.webfaction.com/applications. Hope that helps! answered 08 Apr '13, 17:13 seanf |