How to connected Database with server hosting Centos 7
Dear all This my channel we are share all about knowledge sport gaming entertainment and something your are get idea good and from videos I help you like all this videos Please share and like thank you for visited my channel
MySQL is one of the most widely used database management systems for websites and server applications. It’s an essential tool that every webmaster should learn. That’s why in this tutorial, we will show you how to install MySQL on CentOS 7 through an SSH connection.
System Architecture Diagram
We will set up the MariaDB as show in the following diagram. For security and performance optimization purpose, we will need to separated the Web server and the Database server in two different servers. Web server with hostname “vkcent-web01” and IP address of 10.0.0.1 will connect to database on the remote MariaDB database server with hostname “vkcent-dbs01” and IP address of 10.0.0.2.
Create Database
To create a database name “webdb01” and a user name “webdbuser01” and grant all privilege for user “webdbuser01” on the database name “webdb01”, execute the following command.