Hi Everyone! MySQL is one type of database that you can use on all KincaiHosting hosting. You can connect MySQL with website applications, create databases, delete and do other activities. Now in this guide we will explain some privileged MySQL users on shared hosting. This guide will explain what is allowed and what cannot be done with MySQL on Hosting.

Why Is There a Difference?

MySQL on shared hosting is, of course, different from MySQL in XAMPP. The only difference lies in the access rights they have. When you use XAMPP or LAMPP on a computer / laptop, surely you will get admin access rights. So that whatever you want to do with MySQL databases, can be implemented. However, shared hosting is different. Remember what shared hosting is and how it works?

Also Read : What is Domain and Hosting?

Shared hosting is like a lot which is a piece of land that has been plotted with a certain size which will be used as a place to build a building. So, the website will be located in a land that has been divided. It's easier, you live in a rented house. Now in this rented house you can only rent, not sell. You can paint the walls of the house, replace the broken doors. However, you cannot change the shape of the house.

For this reason, the use of MySQL is also limited. There are some things you can't do because your access rights are not “super admin / super user”. This is also related to data security problems from several other users who occupy 1 server. But take it easy for standard usage, the privileged MySQL user on shared hosting is more than enough!

Well, if you've ever created a database or connected a database via cPanel, you must be familiar with this image. This is what you can do at Hosting.

how to create a MySQL database

As for the explanation,
ALTER : Access rights to change tables
ALTER ROUTINE: Access rights to change stored routines
CREATE : Access rights to create tables and databases
CREATE ROUTINE : Access rights to create and delete stored routines
CREATE TEMPORARY TABLES : Access rights to create temporary tables
CREATE VIEW : Access rights to create and modify views
DELETE : Access rights to delete data
DROP : Access rights to delete databases, tables and views
EVENT : Access rights to create events
EXECUTE : Access rights to run stored routines
FILE: Access rights to make the server read or create
INDEX files : Access rights to create and delete indexes
INSERT : Access rights to add data
LOCK TABLES : Access rights to lock tables
REFERENCES : Not implemented
SELECT : Access rights to view data
SHOW VIEW : Access rights to see the creation of the view
TRIGGER : Access rights for trigger operations
UPDATE : Access rights to update data

All these privileges are standard activities that programmers do.

Also Read : How to Create a MySQL Database on Hosting

What Can MySQL Not Do on Hosting?

There are a number of things that MySQL cannot do on Hosting. That is,

1. Hosting does not support MySQL Event Schedule

This is because the MySQL event scheduler requires high resources. Thus, it will make the server load high and cause down. This will harm other users. But take it easy for those of you who need an event scheduler, you can use KincaiHosting VPS.

2. Users are not granted "root" or superuser permissions

Now this is what was emphasized at the beginning. So, MySQL on shared hosting is not given "root" access.

Conclusion

MySQL user privileges on shared hosting are limited. But you don't need to worry. For standard users, all of these MySQL permissions are more than enough! You can alter table, delete table, drop table, select and update. For CRUD purposes it is complete!

What is Safelink Asia?

Safelink.asia is a completely free tool where you can create short links. URL security with cryptographic algorithm. Protect your web visitors with a secure link, to avoid viruses, malware, thief, etc. Apart from being free, you get paid! Register now!


Shorten URLs & earn money

So, now you can make money from home, when managing and protecting your links with Safelink Asia. Signup for an account in just 1 minutes. Once you've completed your registration just start creating short URLs and sharing the links with your family and friends. See our proof of payment and publisher rate.


Our partners and network

Here are some of our partners and networks that have collaborated on advertising: 401XD Group, MC Project, Kincai Media, Kartu Nama Digital, SEO Secret Indonesia, Safelink Asia, Media Bisnis, Blackexpo, Adigunawan.net.