Tag: mysql

Categories
cPanel Blog

How to Use Remote MySQL in cPanel

Having remote MySQL access can be advantageous for a variety of reasons. Remote hosts (different servers) can access your mySQL database using this function. For example, if you want to make the database available to a third party, such as a shopping cart application.

Find Remote MySQL Feature

Under the Databases section, look for and open the Remote MySQL® tool.

Allowing Remote Server Access to Your Databases

In the Host area, type the hostname or IP address. You can use your public IP address, to access the database from localhost. Alternatively, type a fully eligible domain name, such as www.jkucart.com, and then press Add Host.

Deleting Remote Server Access.

You can do the following to revoke previously granted access:

In the Manage Access Hosts list, find the hostname you want to drop and press Delete.

A confirmation window will appear, and all you have to do now is press Remove Access Host.

That’s what there is to it. Remote access to your MySQL databases can be enabled and disabled with ease. Please don’t grant permission to an unauthorised individual for security purposes.

Categories
cPanel Blog

How to Create MySQL Database in cPanel

To store your data, each website needs a location. Here, we will build a database and allow a user to access it for your domain.

Accessing the MySQL Databases

Use the MySQL Databases tool after logging in.

Creating New MySQL Database

You’ll be taken to a window called MySQL Databases. To make a database, type the name in the appropriate field (without spaces) and press Create Database. Select Go Back when you’re done.

Creating and Adding New MySQL User

The Add New User form is located at the bottom of the page. When filling out the form, leave no gaps between the username and the password. Enter your password twice.

You can also use the Password Generator to come up with a more secure password. If you did, I have copied this password in a safe place and then Use Password.

When you’re done, press Create User.

After clicking Go Back, you can fill out the Add User To Database form. Select the user and the database to which the user will be allocated from the drop-down menu.

You’ll be taken to the Manage User Privileges window after clicking Add.

Providing Privileges to the New User

All that remains is to grant the user privileges in this phase. You can check ALL PRIVILEGES and press the Make Changes button if you’re creating an admin.

That’s it; you’ve successfully built a database, a user, and the required privileges to access the website’s database. Keep in mind that this tutorial only created an empty database, so you’ll have to manually generate or import all of the tables and entries.