MySQL settings test failed
Author: Mohamed F.
Visited 1878,
Followers 1,
Shared 0
I have a new website hosted by Godaddy, and I am used dynamic content in some pages so I create a database file on the server with user that have full authority and add those to my data management and assign on my dynamic object to use that database, this feature was working well on my old host location but with this new one with godaddy I got that message while I am uploading my site.
"The Following test Failed - MySQL Database Settings"
Note that I have
MySQL 5.6.39
PHP5.6
7.0
7.1
7.2 (default)
7.3
I tried to contact godaddy for this but they couldn't figure out the problem.
so I hope you can help me on that.
My dynamic page is:
Posted on the
Hello Mohamed,
Log in to your WebSite X5 online control panel located here:
http://www.systemsdesign.tv/admin/login.php
...using the Administrator email and password which you will find in Step 1 Settings > Advanced > Access Management
Once logged in go to the Website Test section and report back the details of any errors displayed under MySQL Database settings.
Kind regards,
Paul
Search the WebSite X5 Help Center
Author
this is the screen
Thank you for the screenshot, Mohamed.
I had hoped there might be a more descriptive error message, but never mind. We will try and work it out regardless.
Your screenshot shows that you created a third database (Systems trial) which did pass all the necessary tests and thus was correctly configured for use with WebSite X5. Can you think of any reason why this might be? What is different about this database compared to the other two?
Are all three databases on the same server?
Are the two problematic databases on the same server as your WebSite X5 project?
Can you double-check your MySQL database access credentials (Host name; Database name; Username; Password) by attempting to log in to the databases using phpMyAdmin? This free tool can be found on most web servers... look for it in cPanel if you have it:
https://www.phpmyadmin.net/
If you can log in using phpMyAdmin (or any other third party database tool), and are using exactly the same credentials in WebSite X5, then we can rule out access credentials as the source of the trouble.
Did you create any tables for your databases manually? WebSite X5 prefers to create the database tables itself.
If you have access to your server logs (again using cPanel or a similar online control panel) then there might well be more detailed information there as to the nature of the failure. It would be worthwhile looking through the logs for anything related to MySQL, which could give a clue and help to narrow down possible causes.
Author
Hi Paul,
Are all three databases on the same server?
No the first one which is working on my old server but the others on the godaddy server with my website.
Are the two problematic databases on the same server as your WebSite X5 project?
Yes
If you can log in using phpMyAdmin
Yes I have it and already use with the same user details
Did you create any tables for your databases manually? WebSite X5 prefers to create the database tables itself.
one of them I import my old data in it according to Godaddy's technical support request and the other was empty but now I have both Empty without any tables
If you have access to your server logs
Kindly find the attached log file for our ftp and I hope it can help
I have a hunch that this might be key.
Can you tell me please what you have entered as the Host Name in Step 1 Settings > Advanced > Data Management > Database for each of the three databases in turn?
Author
1- egytouch.com
2- systemsdesign.tv
3-systemsdesign.tv
Author
by the way the first one will not be used in the new server I just keep it to keep testing the connection with my old server as it was just a demo version of the site before uploading to systemsdesign.tv
The main target is to let the new data base working on systemsdesign.tv server
Please delete systemsdesign.tv from the Host Name field, and enter localhost instead.
Then reupload your project to the server and use the WebSite Test facility in the online control panel to check if connection is now successful.
Author
Thanks for your support it works :)