Page 1 of 1

setting up bolt cms with SQL

Posted: Thu Dec 03, 2015 8:10 am
by gautamz07
I was trying to get my boltCMS to work with mysql and i had the following changed in the setup file , from:

Code: Select all

# If you're trying out Bolt, just keep it set to SQLite for now.
database:
    driver: sqlite
    databasename: bolt
I changed the above to:

Code: Select all

database:
    driver: mysql
    databasename: bolt
    username: root
    password: ''
now i get the following error:

Code: Select all

Bolt - Fatal Error
There is no password set for the database connection, and you're using user 'root'.
That must surely be a mistake, right? Bolt will stubbornly refuse to run until you've set a password for 'root'.

This is a fatal error. Please fix the error, and refresh the page. Bolt can not run, until this error has been corrected. 
Make sure you've read the instructions in the documentation for help. If you can't get it to work, post a message on our forum, and we'll try to help you out. Be sure to include the exact error message you're getting!
I also read this article HERE https://www.fastcomet.com/tutorials/bol ... figuration

i followed the steps , yet i am getting this error , can somebody help me out please ?

Thank you.
Guatam.

Re: setting up bolt cms with SQL

Posted: Thu Dec 03, 2015 8:12 am
by Celauran
The error message tells you exactly what you need to do; set a password for root. Better, don't use the root account.

Re: setting up bolt cms with SQL

Posted: Thu Dec 03, 2015 12:31 pm
by Christopher
Yes, I would recommend creating a 'bolt' user in MySQL that only has permissions to the bolt database. Use that 'bolt' user/password to connect.

Re: setting up bolt cms with SQL

Posted: Tue Dec 08, 2015 6:15 am
by gautamz07
Yes, I would recommend creating a 'bolt' user in MySQL that only has permissions to the bolt database. Use that 'bolt' user/password to connect.
That sounds like a reasonable solution. :D

@celauran , in the mean time i set it up online .. with mysql , with the following credentials

Code: Select all

database:
    driver: mysql
    databasename: somedatabase 
    username: somedatabase
    password: somedatabase
and it works just fine. :D

but i need to run it locally too, for development purpose and so i will try chris's solution.

Re: setting up bolt cms with SQL

Posted: Tue Dec 08, 2015 6:17 am
by gautamz07
Thanks alot guys :D :D