Thursday, January 31, 2013

Laravel Database Configuration


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.






1 comment:

  1. Thanks for the workflow ...

    If 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/

    ReplyDelete