Database:- A database is a structured, organized set of data. In computing terminology a database refers to a software used to store and organize data.
WordPress uses MySQL as its database management system. MySQL is a software used to create databases, store and get data when requested.
MySQL:- It is also an open source software, just like WordPress and works best with other popular open source software, such as Apache web server, PHP, and Linux operating system.
Database Table:- Databases have tables which are like sections or cabinets in database system.
Column:- Each table has columns and information is stored as rows.
Row:- Each row has a field for each column in the table.
WordPress will automatically create tables inside your database. At the time of writing this, a default installation of WordPress would create the following tables:
- wp_commentmeta
- wp_comments
- wp_links
- wp_options
- wp_postmeta
- wp_posts
- wp_terms
- wp_term_relationships
- wp_term_taxonomy
- wp_usermeta
- wp_users
Steps to change the password of database in WordPress Using Control Panel:
Step 1: Login to the control panel.
Step 2: Goto File manager select domain and goto its home directory(public_html).
Step 3: Goto wp-config file and from there you can change the password of database.
Step 4: If you have changed the password of the database update it on MySQL Management also in the provide control panel.
Steps to change the password of database using SSH:
Step 1: Login to your VPS server using the dedicated IP and Password.
Step 2: Following are the commands through which we can change the password of MySQL
Step 3: mysql -u username -p
Step 4: Enter the password of control panel.
Step 5: mysql> show databases;
