Welcome to the InMotion Hosting
Ask questions, search for answers, and connect with community members from around the globe! Our forums are open 24/7/365, however, our dedicated InMotion Hosting Community Team monitors questions between 9 am - 5 pm ET, Monday - Friday!
We welcome new discussions and questions. Before posting we do ask that you do a quick search first to see if your topic has already been addressed.
Please keep in mind that your question will be public, so please do NOT post any sensitive information, such as email addresses, usernames, or passwords. Learn more about how to make the most out of our Community Support Center.
Check out these related questions for an answer.Don't see an answer to your question? Click the Ask this Question button to submit it to the Community forum for review.
We have just upgraded to a VPS plan in order to get Magento 2.4 fully working (it requires elasticsearch, which needed the VPS and which I've already installed; that's unrelated to my problem though).
I've just added a new MySQL database through cPanel, and added a user for it, which is of course listed as associated with the database.
When I go into the Root WHM panel's Terminal and try to connect to MySQL through commandline for that user, it works fine.
Example command (replaced actual username with "test_db_user"):
mysql -u test_db_user -p
It connects with that user account fine.
However, when I connect through SSH as my standard CPanel user and run the same command, giving the same password,I get:
ERROR 1045 (28000): Access denied for user 'test_db_user'@'localhost' (using password: YES)
After checking through various things, I then added privileges for an existing MySQL user to the new database. I again can connect fine through the root terminal to the older username, and running "show databases;" lists the older database that user already had access to along with the new database which I just added privileges for. No problems there.
I then connect again through SSH as my standard CPanel user and try to connect to MySQL while specifying that older MySQL user. This time it connects properly, no error. However, when I run "show databases;", it only lists the old database that MySQL user already had access to; it doesn't list the new database, even though the new database showed up through the same command through the root terminal.
It's like it's seeing an older cached version of the MySQL databases (or maybe just MySQL users) when I try to connect through my standard account through SSH. I've tried restarting the MySQL service and restarting the VPS itself, no change in behavior.
Why would this be happening? How can I fix it? Will it just fix itself given enough time? I need to be able to run the installer for Magento 2.4 through SSH which naturally requires database access, so I need to find a fix. The only workaround I can think of is to co-opt an older existing database and user, just wiping that database, but I'd rather not have to resort to that.
Hi, first off all i'm getting interested in buying
Shared hosting plan for 1 year, which is the "Power plan"
but before that i'm getting a lot of doubts about a database connection
so i'll make two basic questions:
Before the questions, Take notes:
1)I'm planning to use inmotion hosting "Power plan" shared hosting, NOT VPS, NOT dedicated servers
2)I'm planning to use inmotion hosting databases from external sources like for example, from AWS lambda with node.js
for certain (mandatory) reasons,
1-How can i connect to an inmotion hosting database with the shared hosting plan from a external server from amazon web services?
For example, i've coded a software and deployed it to aws lambda, but now i want to connect from an aws lambda server to an inmotion hosting database with the shared hosting plan.
How can i get access to that database?
2-What is the connection limit from a database with shared hosting plan?
¡Thanks for reading!
And i need help ASAP before buying it!
Hello! I checked with one of our senior Support Technicians, and confirmed that you should be able to do all of this by setting up a remote MySQL connection in cPanel.
The database connection limit on shared accounts would be 20. Hope that helps!
Hi, I have some database issues 1. 'max_user_connections' active connections". 2. mysqli::__construct(): (HY000/2002): No such file or directory
I have problem understanding why I get the max-user-connection message. I am 100% sure that I close the connection. Everywhere I open the connection I close it. And as a failsafe If check in the destructor of my db-driver if the connection is still open and is so I close it there. And I don't get so many visitors on my site that they can cause this issue. I log all my database errors, so I know when something doesn't work. But I don't get other errors when I get the max-user-connection problem.
The second issue is this message "mysqli::__construct(): (HY000/2002): No such file or directory". It is rare that I get this, I never change the name of my databases. If it was changed I would get this message all the time. But it give me the feeling that the problem is more on the server side or connection.
Thank you for your question regarding MySQL connections. Unfortunately, as this is a public forum, I am unable to provide account-specific information. I recommend contacting our Technical Support team for direct assistance with this issue:
Now, when I'm at my work computer, I click on the phpMyAdmin icon in cPanel, it launches a new tab and then freezes on "Please be patient, you will be redirected in a moment.... " and never gets anywhere.
Hi, two questions: 1. Would it possible to recover a version of my website database of let's say May 2019? If so, how much would it cost? (2) what is the FTP server for my website. I cannot connect through FileZiall? Thanks.
Currently the company Im working for have 5+ accounts in inmotion hosting.
It is posible to somehow replicate a database from one account in one domain to another in other domain?
Using MySQL replication o simple getting access to copy by hand.
Cant connect to the database in other domain even if I add the IP of the "slave" domain in MySQL remote access config in cpanel.
Its possible to copy/access a database in one domain to/from another?
I need to move a Laravel app from one domain to another and will lose access to the database of the default app in that domain.
Its possible to access the database X of domain A.COM from another domain ??
Wich Mysql server/host and user/password I must provide ?
please provide help with phpMyAdmin configuration storage database setup
There is a “Designer” tool that allows us to setup relationships between the tables (foreign key relationships). While is nice, by default phpMyAdmin doesn’t remember the location of tables as they were placed by user dragging and dropping. The default placement is everything stacked on top of each other. There is “Save” feature, but it doesn’t work unless you have the phpMyAdmin configuration storage database setup. Inmotion hosting does not have this setup by default for shared hosting accounts. I would like to be able to save my database table relationship placement in the designer tool. thanks.
Thanks for your patience as I gathered some more information regarding your question about configuring the phpMyAdmin storage database setup. Unfortunately, the phpMyAdmin installation that comes with cPanel can not be modified to allow this kind of functionality in the Shared Hosting environment. However, you can install your own phpMyAdmin instance and therefore should be able to manipulate the features available in your custom installation. Note that this instance will not be integrated with cPanel though.
I hope this helps! If you have further questions please feel free to reply back; we are always happy to help.
Customer support service by UserEcho