Database error in mysql

Community support
#1

I am receiving the following SQL error when i try to install phpfusion .

Error: Unable to connect with MySQL.
Please ensure your MySQL username and password are correct.

Username and password are correct since i am using phpmyadmin to log in to the database i have created.

Thanks and appreciate any help.

#2

Hi @sandro!

Make sure you’re using localhost as MySQL host :wink:

#3

Yes i am as well

Thanks

#4

Is your issue resolved, then…? :slight_smile:

#5

im afraid not still have the same error.
thanks

#6

Step 3: Database Settings
Please enter your MySQL database access settings.

Database Hostname: localhost
Database Username: sandro
Database Password: ••••••••
Database Name: mrc01
Table Prefix: fusionNlm9N_
Cookie Prefix: fusionq4L5a_

These are my database settings

sandro

#8

Database name and username are wrong.

Copy and paste them from your members area.

1 Like
#9

Which members area please?

#10

000webhost cPanel > Manage database

#11

The members area and then manage database.

#12

Database Hostname: localhost
Database Username: id1753700_sandro
Database Password: ••••••••
Database Name: id1753700_mrc01
Table Prefix: fusionNlm9N_
Cookie Prefix: fusionDXn1j_

Done it as above but still the same

#13

Please change your PHP version to a lower one: cPanel > Settings > General > Change PHP version > 5.6

#14

done it and now the error is
Error: Unable to connect with MySQL database.
The specified MySQL database does not exist.

#15

Can you screenshot the error please?

#16

#17

Ok… Then change your PHP version to PHP 5.3 (it’s the minimum one required by PHP Fusion, however we recommend upper versions for security reasons and php language compatibility)

#18

downgraded phpmyadmin and restarted browser but still same error

#19

Download the script from the developer’s website

Upload the script to your 000webhost account

Once uploaded, right click and extract the script fully.

Now rename the _config.php to config.php

Now visit yoursite.com/setup.php

Make sure all are green

Ensure you have set config.php to 777

On 000webhost.com create your database keeping note of the details

Now once created copy and paste the username, database name into the script install

Once you enter them in the script hit next

If you reach this screen then PHPFusion is unable to be installed on your free hosting account, you’ll need to upgrade if you want to install it.

or

However if you get this screen

You should proceed and follow the instructions as such.

Following the advice delete setup.php

And permissions back to 644 for config.php

1 Like
#20

Thanks a lot for your help, I will do it and if it does not work , i will upgrade.

Again appreciate your help

Sandro

#21