setting up bolt cms with SQL

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

Post Reply
User avatar
gautamz07
Forum Contributor
Posts: 331
Joined: Wed May 14, 2014 12:18 pm

setting up bolt cms with SQL

Post 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.
User avatar
Celauran
Moderator
Posts: 6427
Joined: Tue Nov 09, 2010 2:39 pm
Location: Montreal, Canada

Re: setting up bolt cms with SQL

Post 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.
User avatar
Christopher
Site Administrator
Posts: 13596
Joined: Wed Aug 25, 2004 7:54 pm
Location: New York, NY, US

Re: setting up bolt cms with SQL

Post 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.
(#10850)
User avatar
gautamz07
Forum Contributor
Posts: 331
Joined: Wed May 14, 2014 12:18 pm

Re: setting up bolt cms with SQL

Post 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.
User avatar
gautamz07
Forum Contributor
Posts: 331
Joined: Wed May 14, 2014 12:18 pm

Re: setting up bolt cms with SQL

Post by gautamz07 »

Thanks alot guys :D :D
Post Reply