I'm trying to connect a Node.js app with a MySQL database which works for another app really well on a remote server with this code: var mysql = require('mysql'); var con = mysql.createConnection({ host: "www.<dnw>.com", port: <correct port number>, user:…
I'm currently following a laravel/mysql tutorial on lynda and followed the following steps to create a database and connect it to my laravel framework. The following steps helped name my database, change my user name, and password (in which it…
This seems to be a highly covered issue. However majority of the threads I have seen have been local connection issues, or people saying make sure the user name and password are correct, which I have done. I am hosting…
I have two different SQL codes, one to get user names and emails, and the other one just phone numbers. Can you help to combine it with one script so it will be possible to get a list of user…
We run a CentOS DirectAdmin install with MariaDB 10.2.14 where on Magento is installed. Currently our DB locks very often when a process runs, so all other processes are waiting until the current process finishes. This is quite a problem,…
I was setting up a Laravel environment. So, I downloaded XAMPP and configured my vhost files accordingly. Then, I setup MySQL and ran the following commands: composer install npm install php artisan (to confirm I had artisan) php artisan migrate…
I am unable to connect to the database on my website. The user account has permissions and the user name and password are correct. The only thing that could be wrong is the link I am using for the database…
I have a mysql database table in wordpress where I declare a BIGINT field without any problem. But when I create the same table in mysql installed on my own computer the large numbers are stored as 2147483647, which in…
I've been having problems getting anything but index.php to work on Magento. Having finally got everything to execute I've not just got a simple problem where the urls to files are incorrect. For example: the site is requesting .../static/version1111/.../logo.svg which…
I need external connection to MySQL. Using Plesk/Ubuntu 16/nginx. In firewall policy the port 3306 is allowed from any IP. Is it somewhere else where it shall be allowed? If so, what file is needed to be edited?