Question Problem accessing database on new installation

Hello

I am just now installing the latest version but from running the installation the software has problem accessing my database.
I have checked and re-check the login information but still it will not connect.

I know this could be difficult to answere but I try anyway if any of you have a hint for me.

SQLSTATE[HY000] [2002] Connection refused (SQL: CREATE DATABASE IF NOT EXISTS `engelarsen` COLLATE utf8_unicode_ci)

 

From the error message it seems the user can connect, but is not allowed to create tables etc.

Have you specified another owner / schema / database than the user which is used to connect?

Another possibility is that you are trying to connect to MySQL via the network (e.g. 127.0.0.1), but MySQL is only available by a socket (localhost).

Check your connection settings.

Thank you folks

Please find attached the setting I have on the MySQL database.  
All rights are ticked.
The software is running on the same server as the linux is installed.  So I expect that localhost:3306 should be okay since I am not trying to connect from a remote site.  Should I try to specify the actuall IP adress instead of just localhost ?


Petter

1. Firewall rule: If your server deny/not allow 3306 port, can not connect it.
2. Bind Address: if your bind address are 127.0.0.1 in MySQL configuration, you must change to 0.0.0.0 in [mysqld] on /etc/mysql/my.cnf
3. Restart Service: you have to run command 'service mysql restart'

Hello again

Thank you for trying to help me.
The problem is solved now.
It seemed to have something to do with the DNS setting at the domain holders site.
I managed to add a missing CNAME parameter and got rid of a warning message at my server and then also the SQL database connection worked.
So I have it installed now.

I have also imported at GEDCOM file from MyHeritage and it went well except the images/photos is not working yet.
I learned that I during the importing of the GEDCOM I needed to have the software to remove the path to the source for images at my local desktop. So I did.
The question is now, were should I now upload my images ?
I read one place that they should be upladed at data/media   ??
There is a data folder but no media subfolder.
So I created it and uploaded all my images to that folder.

Am I right so far ?

Petter
 

Yes, you are right. You should be able to see and manage the media files in webtrees.

Thank you for your reply. Yes everything is working fine now. I just wonder one thing. There is no Norwegian language possibility but Swedish and Danish. Not a big issue but is there a possibility for me to translate into Norwegian ? On a file level ? Create a new file with the norwegian words ?

Thanks

Norwegian language is optional and just needs a tick to be activated.

Go through some options in the Control Panel. Under website preferences?

Control panel -> Modules -> Languages

Yes I see that I can enable Norwegian language now. 
I found it.

Thank you all for quick respons to my questions.

Thank youl

Petter