I applied the SAME database username to both databases
Why is the Database password the same?
When I reset the password for the database username it made my main domain crash?
It sounds like you created a single MySQL user which is allowed to access both maindomain and subdomain databases. When you change the MySQL user password, you need to update the password in any wp-config.php files where that user is set.
Have I just merged two databases together? Is that even possible?
Based on your description, it sounds like you just need to update the password in the wp-config.php on your maindomain site. It is possible to make your maindomain and subdomain sites point to the same database but you would do that by setting the DB_NAME define and $table_prefix variable exactly the same.
Related Posts:
- Please explain how WordPress works with MySQL character set and collation at a low level
- Connect to database using wordpress wp-config file
- Accessing two databases
- Custom DB_COLLATE (collation) value not working on fresh install?
- Why can’t I swap a DB in a WP install? [closed]
- Can I have multiple database users within WordPress?
- Error establishing a database connection on Installation
- Moving WP from local server to live, error establishing a db connection
- Connect to a remote database for wordpress in my own hosting server
- Switching Databases in LocalHost
- Localhost to Staging to Development Dynamic WP-CONFIG
- How to share plugin created database tables between two WordPress sites
- Problem migrating to localhost
- Is my way to change WordPress server is correct?
- how to encyrpt DB_PASSWORD in wp-config
- Getting WordPress to work inside a rails 3 application
- Can two domains use the same database?
- WordPress keeps redirecting to localhost
- How to re-connect WP files in lampp/htdocs to new SQL database to recover site under development
- Duplicate database to roll back theme & content changes
- Cloned site not connecting to database – MAMP
- execute custom function on database connection error
- Does WordPress Support Using Named Pipes on the Windows Operating System?
- I have include wp-config, should I add global $wpdb also?
- Can’t Install WordPress (local) Failed to open file wp-includes/wp-db.php
- Issue “Error establishing a database connection” problem.
- /var/run/mysqld/mysqld.sock
- DB access blocked when initializing WP externally
- How to use remote db tables in current config? [duplicate]
- Multiple Address In WP-Option Value
- ERROR: “Table Prefix” must not be empty
- Can I connect WordPress website with an external database?
- wp-config was suddenly updated
- What is the difference between an ORM and an ODM?
- Checking if Database Table exists
- How To Export/Import WordPress (MySQL) Database Properly Via Command-Line?
- Is it possible to define two databases for one installation?
- Syncing local content with development / staging sites
- How To Make Connection To WordPress Data Base In A Plugin?
- Improve or optimize a very slow query
- What is the advantage of separating wp_users and wp_usermeta table?
- “MySQL server has gone away” since update to 3.8
- WordPress page title repeated in SOME pages
- MySQL Syntax Error upon restoring database from backup [closed]
- Help running a MySQL query to update all wp_#_options tables in a Multisite install
- Merge two databases: OLD SITE -> NEW SITE
- Is it safe to convert tables from MyISAM to InnoDB?
- Use one WordPress database with multiple instances of one site
- Who is responsible for data sanitization in WordPress development?
- How to check if a core update, like 4.9.8 → 5.0, involves a database update (migration)?
- Accessing WordPress MySQL Database via Data Connection in Visual Studio 2010 using C#
- I need to get an array from the wordpress database
- Moving minor updates between local and live sites – just database?
- what is the best way to store user created data?
- Using GROUP CONCAT in my-sql query with wp_usermeta table
- input data and output table [closed]
- How to move the WordPress site Layout from test site to Production site?
- Your PHP installation appears to be missing the MySQL extension which is required by WordPress
- Retrieve data from the database to table such as comments in the admin control panel
- Need to store custom user information (many-many relationsips), preferably not as user meta
- charset problem with new custom table
- WordPress and user security
- How to connect to a remote database in WordPress?
- Migrating from PDO using SQLite to clean new install using MySQL
- Change WordPress URL in sql file via Terminal
- $wpdb->insert Giving duplicates
- Where is phpMyAdmin inside WordPress?
- What can I do when an outside party hacks into my weblog and changes my display name?
- How to delete database without using any plugin?
- Cannot restore wordpress database from sql dump [closed]
- Is database deleted on clicking “reinstall” button in WordPress updates?
- Fill custom select field with pages/post titles
- WordPress database products structure
- I cannot find the difference between these wp_capabilities values in wp_usermeta
- Files on Localhost, Database on Server
- Is there any way to monitor a MySQL db and check what has changed?
- DB prefix not updating
- Any other way of storing plugin admin data setting
- Will memcached improve performance with WP Super Cache already running?
- Error establishing a database connection – WordPress setup, everything else is working
- Restore of database doesn’t show content
- Why theme settings lost when I installed https
- WordPress site migration – locked out of admin area
- WordPress users table missing indexes
- unable to use my wordpress site after moving
- How to add download link from database on custom page template?
- How to get the id of recently registered user from database?
- How can i syn wordpress user table with a stand-alone php script?
- get_user_meta and umeta_id
- Send data to database after redirect (and popping out of iframe)
- Simple email input store in database
- Pulling values from a sepcific row in table
- import (migration) user database to wp-users
- What is best for saving lot of extra detail of user?
- Insert Extra fields added in the front end registration form to DB
- $wpdb->insert not working for last select option
- How to create a table [closed]
- How to properly configure SSL connection to remote azure database for running queries within a WordPress environment
- Database Queries are crashing the server
- Uploading to WordPress Database