MySQL Admin WordPress Password Change Tutorial

Have you ever forgotten your WordPress admin password and not having access to your email or not properly logging into your WordPress email account? Do not worry. Here’s how to change your password through the MySQL command line . This will be very easy if you have a database connection username and password or access the wp-config.php file. Reset your WordPress admin password using MySLQ Let’s start by searching for the username and password of the WordPress database that you have stored in the wp-config.php file. We do this by going to the directory where you have WordPress installed and opening the…

Read More

What is MySQL?

MySQL is a relational database management system (RDBMS) that enables storage, searching, sorting and retrieving data. The MySQL server allows multiple users to use data at the same time and speeds up credible access to data. So MySQL is a multi-user, multi-threaded server. Although the history of MySQL dates back to Year 2, its public release has begun since Year 2. This database management system is the most common open source database. Early versions of MySQL cannot be compared to newer versions of MySQL. Older versions did not have a very user-friendly interface due to…

Read More

MySQL Tutorial – Part 5 – Nested Tables – Foreign Key in MySQL

MySQL Tutorial – Part 5 – Nested Tables with Foreign Key As mentioned in the previous lessons, building optimal tables is very important in database design. Nested tables are very effective in reducing database size. For this reason, in this talk we will teach you how to build a foreign key in MySQL.     Nested Tables Definition In the example in Lesson 2 we created the following two tables to store information about our friends.   Row name last name Age Date of birth Profile code 1 Tofique Ahmed Soomro 40…

Read More

MySQL Tutorial – Part Four – Flags in MySQL

In this lesson we are going to talk about Flags in MySQL. In the previous lesson we learned how to add a table to the database. If you remember when creating the tables in the section below, check the expressions PK, NN and UQ as shown.     Now, because of the importance of this section, we will briefly explain the functional flags.   PK – Primary Key When you create a table you must define a key for each row of the database. This means that we render each database row with…

Read More

MySQL Tutorial – Part Three – MySQL Workbench

Creating a Table in MySQL Workbench In this lesson, we are going to build our first database table with the MySQL Workbench tool. First we need to create our new schema in MySQL. To practice the tables we will build the previous lesson together.   Open MySQL Workbench To open the program go to the Start menu in your Windows and click the MySQL Workbench option in the MySQL folder. You can also open the program by going to the Notification Area in your Windows by clicking on the MySQL form like…

Read More

MySQL Tutorial – Part Two – Schema and Table

In this section of MySQL tutorial we will briefly introduce Tables. In general, each database consists of structures called Schema. Schemes have different sizes and sections on which different processes or views can be defined. MySQL tutorial MySQL Tutorial – Part 1 – Installation MySQL Tutorial – Part 2 – Schema and Table MySQL Tutorial – Part 3 – MySQL Workbench MySQL Tutorial – Part 4 – Flags in MySQL MySQL Tutorial – Part 5 – Nested Tables with Foreign Key Each Schema can have different tables or tables to store information.…

Read More

MySQL Tutorial – Part 1 – Installation

Data storage, processing and easy use of information stored in the computer world is of paramount importance. Today, the use of RDBMS (Relational Database System) has become an integral part of the software world. So we’re trying to get stronger and tighter by training MySQL and installing it in the software world. You must first download the latest version of MySQL Installer from http://dev.mysql.com/downloads/installer/ . Note that this Setup page is listed either as an online installation called “mysql-installer-web-community.msi” or as an Offline installation called “mysql-installer-community.msi”, We recommend downloading the second file because it is…

Read More

how to create MySQL database in cPanel

First Login the Cpanel with Username and Password click on the MySQL Databases menu in the Databases section:   Type the database name in new Database to  which database you need to Create New Database, click on the Create Database button:    The database is created and ready to use.   The successfully created database in MySQL   To create a MySQL User, in under the Create new MySQL database. MySQL Users > Add New User and enter the username you wish to assign to your database. Once done, choose a secure password and password (again) for MySQL User and type it into…

Read More

How to Install MySQL on CentOS7

MySql is an open source database management system. In version 7 of the CentOS operating system, this database is set aside and MariaDB is the default relational database, and by installing the yum install mysql command, the MariaDB software is installed instead of MySql. In this article, we will examine how to install and run the MySQL version 5.7 on CentOS7. You can use the link below to install MariaDB. Step One: Install As explained in the previous section, MariaDB is the default database management software in CentOS7. In order to install…

Read More

How To User Grant Permissions in MySQL

MySQL is an open source database management software that helps users store, organize, and later retrieve data. this tutorial will give a short overview. 01 – Login MySQL server and then user accounts 02 – click on “Edit privileges”   03 – change privileges How To Grant Different User Permissions Here is a short list of other common possible permissions that users can enjoy. ALL PRIVILEGES- as we saw previously, this would allow a MySQL user all access to a designated database (or if no database is selected, across the…

Read More