Site icon Knowledge Base| Kiến thức Dịch vụ P.A Việt Nam

Những giới hạn Mysql trên dịch vụ share hosting!

Những giới hạn Mysql trên dịch vụ share hosting!

 Trên dịch vụ Share Hosting sử dụng database mysql ( Local hay Remote) Bảng danh sách dưới đây sẽ liệt kê những quyền(Privilege) được phép sử dụng hoặc không được phép sử dụng, để sử dụng các quyền không được phép bạn xem xét nâng cấp lên Cloud VPS, Hoặc Dedicated Server.  

Privilege Giải Thích Ý Nghĩa Cho Phép
ALL [PRIVILEGES] Grant all privileges at specified access level except GRANT OPTION NO
ALTER Enable use of ALTER TABLE YES
ALTER ROUTINE Enable stored routines to be altered or dropped (Only if you are the user@host DEFINER that created the routine) YES
CREATE Enable database and table creation (Only tables can be created, Databases must be created in the control panel) YES
CREATE ROUTINE Enable stored routine creation (Cannot set DEFINER as non-root user, please remove DEFINER=’user’@’host’ combo to create routines) YES
CREATE TEMPORARY TABLES Enable use of CREATE TEMPORARY TABLE YES
CREATE USER Enable use of CREATE USER, DROP USER, RENAME USER, and REVOKE ALL PRIVILEGES NO
CREATE VIEW Enable views to be created or altered YES
DELETE Enable use of DELETE YES
DROP Enable databases, tables, and views to be dropped YES
EVENT Enable use of events for the Event Scheduler NO
EXECUTE Enable the user to execute stored routines YES
FILE Enable the user to cause the server to read or write files (unnecessary, if you get this error you are likely using “LOAD DATA INFILE” and should use “LOAD DATA LOCAL INFILE” instead) NO
GRANT OPTION Enable privileges to be granted to or removed from other accounts NO
INDEX Enable indexes to be created or dropped YES
INSERT Enable use of INSERT YES
LOCK TABLES Enable use of LOCK TABLES on tables for which you have the SELECT privilege YES
PROCESS Enable the user to see all processes with SHOW PROCESSLIST (shows only your specific MySQL users processes) YES
REFERENCES Not implemented NO
RELOAD Enable use of FLUSH operations NO
REPLICATION CLIENT Enable the user to ask where master or slave servers are NO
REPLICATION SLAVE Enable replication slaves to read binary log events from the master NO
SELECT Enable use of SELECT YES
SHOW DATABASES Enable SHOW DATABASES to show all databases (Only shows those databases you have access to) NO
SHOW VIEW Enable use of SHOW CREATE VIEW YES
SHUTDOWN Enable use of mysqladmin shutdown NO
SUPER Enable use of CHANGE MASTER TO, KILL, PURGE BINARY LOGS, and SET GLOBAL statements, the mysqladmin debug command; allows you to connect (once) even if max_connections is reached NO
TRIGGER Enable triggers to be created or dropped (Cannot set DEFINER as non-root user, please remove DEFINER=’user’@’host’ combo to create trigger) YES
UPDATE Enable use of UPDATE YES
USAGE Synonym for “no privileges” NO
4.5 / 5 ( 106 bình chọn )
Exit mobile version