How To Create a Database In Phpmyadmin/Mysql

How To Create a Database In Phpmyadmin
How To Create a Database In Phpmyadmin

On This occasion, I will discuss How To Create a Database In PhpMyadmin/Mysql. Before we get into the discussion, What a PhpMyadmin?? Phpmyadmin is an Open Source Software that helps us in managing the Mysql Database whose goal is to build websites in the PHP programming language, JavaScript, Html, etc. With PhpMyadmin we can manage Websites and Mysql Database, because it is easier than Mysql, we can also backup/restore database in Phpmyadmin, and change Username, etc.

It is highly recommended if we build a website using the Php and Mysql programming language, we install Phpmyadmin to facilitate the processing of the database. How To Install  PhpMyadmin In  Kali Linux/Ubuntu is very easy, you can use Xampp or install Manually, you can see How To Install Phpmyadmin On Vps Ubuntu 20.04.

After your Install Phpmyadmin, you create a root user and password to login.

1. Create root permissions (Username and Password Phpmyadmin) typing in terminal/consule ;

sudo mysql 

ALTER USER ‘root’@’localhost’ IDENTIFIED WITH mysql_native_password BY ‘passwordMySQL’;

FLUSH PRIVILEGES;

exit

Note*** Mysql password change according to the password you want.

Then restart apache or nginx and mysql

systemctl restart apache2

systemctl restart mysql

Enter your ipaddress/domain in the browser ;

How To Create a Database In Phpmyadmin
How To Create a Database In Phpmyadmin

 

Username root

The Password is according to what you created earlier.

 

How To Create a Database In Phpmyadmin
How To Create a Database In Phpmyadmin

 

Click New then Create a new Database.

How To easy is it How To Create a Database In Phpmyadmin/Mysql ?? you also have to  How To Install Phpmyadmin/Mysql On Vps Ubuntu 20.04.

HopeFully this article can be useful for all of you.

https://coblong.com

About the author

I Like Linux Although Sometimes it's Hard I Believe I Can, I Definitely Can and I Should be Able to. I Also Loves Websites, Php, Python and All About Linux.

1 thought on “How To Create a Database In Phpmyadmin/Mysql”

Leave a Comment