CODEWITHSUNDEEP
phpmysqlopencartmysql-workbench
Oliver Morgan
Oliver Morgan

Reputation: 21

cant connect opencart to mySQL database

I'm trying to set up opencart for my website, but when I fill in everything for the MySQL database I get this error:

No connection could be made because the target machine actively refused it.

I've tried putting it on localhost, I've tried on 127.0.0.1. when I try on 192.168.1.126 (the database server) it says it can't find the database

the server hosting the PHP site is on 192.168.1.125

I'm very new to SQL, I really don't understand it fully. I'm creating a new database in SQL workbench. and filling in the info I need. How to I fix this error?

Upvotes: 1

Views: 1339

Answers (1)

Sergey Vidusov
Sergey Vidusov

Reputation: 1342

My guess is that your DB user is only allowed to access the DB server from 127.0.0.1. You might want to grant additional privileges to it and in your SQL shell run something like

GRANT ALL PRIVILEGES ON *.* To 'your-db-user'@'192.168.1.125'

Upvotes: 2

Related Questions