Member Avatar for azapovjednik

hello all
I am a beginner...
I want to move a wordpress site from a local computer to live server...

live server: plesk parallels

I followed some tutorials and it says: you must create a new mySql database on server... ok I went to parallels plesk panel and I created it... created some user ... and now I click on webadmin button (I guess that is how I go to phpmyadmin) and I get error message:

Welcome to phpMyAdmin
You probably did not create a configuration file. You might want to use the setup script to create one.

so, I guess I must modify config file in order to access the database... but how do I access it? where do I find it? when I look throgh FTP... there is nothing referring to phpmyadmin folder...

I am lost... can anyone help me?

I hope I described the problem well... thanks in advance

  • 4 Contributors
  • 7 Replies
  • 2K Views
  • 1 Day Discussion Span
  • Latest Post Latest Post by azapovjednik

Dani AI

Generated

You do not need to edit any phpMyAdmin config file to migrate WordPress on a Plesk host. In Plesk, phpMyAdmin is installed and configured at the server level, so you will not see a phpmyadmin folder in your FTP space. The message about creating a config folder comes from phpMyAdmin’s own setup utility and indicates a server-side configuration/permission issue. As said, that is for the host to fix. Also check that your subscription actually allows databases; if the service plan limit is 0 or your role lacks DB management rights, the WebAdmin link can behave oddly. Ask the account owner or host to grant database privileges, which later confirmed was the real blocker.

Once the host enables databases, use this quick, safe workflow in Plesk:

  1. Subscriptions -> YourDomain -> Databases -> Add Database. Create a DB and a user with all privileges.
  2. Import your local dump via Databases -> [your DB] -> Import (or phpMyAdmin if available). If the dump is large, upload it over SSH and run mysql -u USER -p DBNAME < dump.sql.
  3. Upload your WordPress files to the document root and set the credentials in wp-config.php (DB_HOST is whatever Plesk shows for the database, often localhost):
define('DB_NAME', 'your_db');
define('DB_USER', 'your_user');
define('DB_PASSWORD', 'your_pass');
define('DB_HOST', 'localhost');
  1. Update the site URL if the domain changed (adjust the table prefix if not wp_):
UPDATE wp_options
SET option_value='http://example.com'
WHERE option_name IN ('siteurl','home');
  1. Log in to WP Admin -> Settings -> Permalinks, click Save to flush rewrites. If you moved domains, run a proper search-replace to handle serialized data (WP-CLI wp search-replace or a trusted tool). As @LastMitch noted, mismatched DB details cause most setup failures, so double-check those first.

Recommended Answers

All 7 Replies

Member Avatar for azapovjednik

I guess it is something related to phpmyadmin setup... but how to do it??

Member Avatar for azapovjednik

on phpmyadmin it says:
Cannot load or save configuration
Please create web server writable folder config in phpMyAdmin top level directory as described in documentation. Otherwise you will be only able to download or display it.
my question is: how do I create this folder if there is no phpmyadmin folder visible through ftp

Member Avatar for azapovjednik

thanks, but that doesnt solve my problem... not even close...
what I need is to be able to create a new mySQL database, and apparently I do not have sufficient privileges to create one... thanks though

Member Avatar for Member #949455

I want to move a wordpress site from a local computer to live server...

I hope you didn't do any data entry yet?

what I need is to be able to create a new mySQL database, and apparently I do not have sufficient privileges to create one... thanks though

I don't think that should be any issue at all?

The only reason that I can think you can't create a new mySQL database is that you didn't installed the wordpress platform correctly.

So the website you are trying to upload doesn't match the configuration.

Member Avatar for pritaeas

I guess I must modify config file in order to access the database

This should have been taken care of for you by your webhost. If it isn't working correctly as you say, contact them and have them fix it.

Member Avatar for azapovjednik

you are right pritaeas .... I have just learned that the guy who bought hosting... didnt give me all the permissions.... sorry about the trouble and thanks for replying.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.