Migrating Joomla CMS from local desktop to new server?

[urbanfas]

Greetings,

I'm experiencing complications migrating my Joomla 3.8.6 site from my local htdocs folder to a new x10hosting server. The site is staged on my desktop computer using MAMP. Thus far, I've successfully migrated the files using Akeeba and Kickstart. However, I'm stuck at the restoration page for connecting the main database. This should be a simple step. I have created both a new MySQL database and a new user in . I'm assuming that the database server host name is 'localhost'? However, I've not succeeded with connecting to the new database.

Your help is greatly appreciated!

 

[lylex10h]

public $host = 'localhost';
public $user = 'cpaneluser_user';
public $password = 'password_for_cpaneluser_user';
public $db = 'cpaneluser_database';

 

[urbanfas]

Thanks, but I still get error an message.

 

[lylex10h]

Import the database using phpMyAdmin

 

[urbanfas]

Yes, I have. I've also tried installing Joomla from within the server, then over writing it with my original version. I imported the original database tables into the new installed database, ...No luck! I have not been able to get the CMS to connect with the MySQL data base.

user: urbanfa3_smitty
db: urbanfa3_network
pw: ********

FYI: "0-configuration.php", is the CMS's original config file.

 

[Anna]

By looking in your cPanel I can see that the database urbanfa3_network does not have an assigned user, meaning that currently urbanfa3_smitty would not be able to connect to the database at all.

Under mysql databases down at the bottom of the page there's a section that allows you to add a user to the database, you would need to add urbanfa3_smitty to the urbanfa3_network database for the connection to be successful.

Also since you posted the password publicly I'd recommend changing the password for urbanfa3_smitty, I have edited your post to hide the information as well.

 

[urbanfas]

Ok, I see my error... I'm gonna make a second attempt at this install.

 

[urbanfas]

Eureka! It worked!

Thanks a bunch! I obviously need to be more proficient in my procedures. Thanks for your insight! Now, just hope this site can generate revenue for me.