1) Open {laravel home}/application/config/database.php
2) Edit the connection setting.
3) Access MySql database via phpmyadmin. Create new database myfirstdb.
4) Click Check Privileges. Click Add user.
5) Enter new user details.
Username: myfirstuser
Host: localhost
Password: myfirstpassword
Global Privileges -> Check All.
Click Add user.
6) You can use a php script file to test your connection setting. (e.g https://sites.google.com/site/notalaravel/home/download/dbtest.php?attredirects=0&d=1)
7) Put the dbtest.php at the public folder and access it via web browser.
8) Check that the connection is successful.
Thanks for the workflow ...
ReplyDeleteIf you see an error message ... as I did ...
phpmyadmin error: “Connection for controluser as defined in your configuration failed”
follow this related thread ...
http://www.rvdavid.net/how-to-fix-phpmyadmin-error-connection-for-controluser-as-defined-in-your-configuration-failed/