If you need to change a database connected to your CMS WordPress, the change is simple and will only take few minutes. Follow the steps bellow.
To change the database you will need to create a new database and have access to FTP account. Copy of the current database can be created by this guide. FTP login credentials can be access here: FTP login credentials article.
1. Log in to the FTP
- For login to FTP you can use FTP client like FileZilla or Total Commander or our web interface ftp.active24.cz.
2. Go to directory where the WordPress is installed.
- If you have WordPress installed at the domain domain.tld it is located in the “web” directory
- If you have WordPress on any of your subdomains (e.g. blog.yourdomain.tld), go to the sub directory and there locate your subdomain directory (e.g. /sub/blog)
3. Locate file wp-config.php and open it. We recommend to make a copy first, just in case.
4. Locate following lines of code and edit them:
// ** MySQL settings ** // /** The name of the database for WordPress */ define( 'DB_NAME', 'cs6fs1zkb2' ); ------------------> instead of "cs6fs1zkb2" enter new database name /** MySQL database username */ define( 'DB_USER', 'cs6fs1zkb2' ); ------------------> instead of "cs6fs1zkb2" enter new database user /** MySQL database password */ define( 'DB_PASSWORD', '84r6rv5o' ); ------------------> instead of "84r6rv5o" enter new database password /** MySQL hostname */ define( 'DB_HOST', 'mariadb105.websupport.cz:3315' ); -> here enter hostname of the database
List of hostname (DB server) for each database can be found in the administration
- Select your domain in the Services tab
- Go to Databases section in the left menu
- Click on the name of your database in the list
You can see all login information in the left box:
