centos sqladmin权限怎么设置
导读:在CentOS系统中,设置SQLAdmin权限通常涉及到数据库管理系统的用户和权限配置。以下是一些常见数据库管理系统(如MySQL和PostgreSQL)的权限设置步骤: MySQL 登录MySQL: mysql -u root -p...
在CentOS系统中,设置SQLAdmin权限通常涉及到数据库管理系统的用户和权限配置。以下是一些常见数据库管理系统(如MySQL和PostgreSQL)的权限设置步骤:
MySQL
-
登录MySQL:
mysql -u root -p -
创建SQLAdmin用户:
CREATE USER 'sqladmin'@'localhost' IDENTIFIED BY 'your_password'; -
授予权限:
GRANT ALL PRIVILEGES ON *.* TO 'sqladmin'@'localhost' WITH GRANT OPTION; FLUSH PRIVILEGES; -
退出MySQL:
EXIT;
PostgreSQL
-
登录PostgreSQL:
sudo -u postgres psql -
创建SQLAdmin用户:
CREATE USER sqladmin WITH ENCRYPTED PASSWORD 'your_password'; -
授予权限:
ALTER USER sqladmin CREATEDB; GRANT ALL PRIVILEGES ON DATABASE your_database TO sqladmin; GRANT ALL PRIVILEGES ON ALL TABLES IN SCHEMA public TO sqladmin; GRANT ALL PRIVILEGES ON ALL SEQUENCES IN SCHEMA public TO sqladmin; GRANT ALL PRIVILEGES ON ALL FUNCTIONS IN SCHEMA public TO sqladmin; GRANT ALL PRIVILEGES ON ALL ROUTINES IN SCHEMA public TO sqladmin; GRANT ALL PRIVILEGES ON ALL TYPES IN SCHEMA public TO sqladmin; GRANT ALL PRIVILEGES ON ALL SEQUENCES IN SCHEMA public TO sqladmin; GRANT ALL PRIVILEGES ON ALL TABLESPACES IN SCHEMA public TO sqladmin; GRANT ALL PRIVILEGES ON ALL FOREIGN SERVERS IN SCHEMA public TO sqladmin; GRANT ALL PRIVILEGES ON ALL EXTENSION IN SCHEMA public TO sqladmin; GRANT ALL PRIVILEGES ON ALL SCHEMA TO sqladmin; GRANT ALL PRIVILEGES ON ALL TABLES TO sqladmin; GRANT ALL PRIVILEGES ON ALL SEQUENCES TO sqladmin; GRANT ALL PRIVILEGES ON ALL FUNCTIONS TO sqladmin; GRANT ALL PRIVILEGES ON ALL ROUTINES TO sqladmin; GRANT ALL PRIVILEGES ON ALL TYPES TO sqladmin; GRANT ALL PRIVILEGES ON ALL SEQUENCES TO sqladmin; GRANT ALL PRIVILEGES ON ALL TABLESPACES TO sqladmin; GRANT ALL PRIVILEGES ON ALL FOREIGN SERVERS TO sqladmin; GRANT ALL PRIVILEGES ON ALL EXTENSION TO sqladmin; GRANT ALL PRIVILEGES ON ALL SCHEMA TO sqladmin; GRANT ALL PRIVILEGES ON ALL TABLES TO sqladmin; GRANT ALL PRIVILEGES ON ALL SEQUENCES TO sqladmin; GRANT ALL PRIVILEGES ON ALL FUNCTIONS TO sqladmin; GRANT ALL PRIVILEGES ON ALL ROUTINES TO sqladmin; GRANT ALL PRIVILEGES ON ALL TYPES TO sqladmin; GRANT ALL PRIVILEGES ON ALL SEQUENCES TO sqladmin; GRANT ALL PRIVILEGES ON ALL TABLESPACES TO sqladmin; GRANT ALL PRIVILEGES ON ALL FOREIGN SERVERS TO sqladmin; GRANT ALL PRIVILEGES ON ALL EXTENSION TO sqladmin; GRANT ALL PRIVILEGES ON ALL SCHEMA TO sqladmin; GRANT ALL PRIVILEGES ON ALL TABLES TO sqladmin; GRANT ALL PRIVILEGES ON ALL SEQUENCES TO sqladmin; GRANT ALL PRIVILEGES ON ALL FUNCTIONS TO sqladmin; GRANT ALL PRIVILEGES ON ALL ROUTINES TO sqladmin; GRANT ALL PRIVILEGES ON ALL TYPES TO sqladmin; GRANT ALL PRIVILEGES ON ALL SEQUENCES TO sqladmin; GRANT ALL PRIVILEGES ON ALL TABLESPACES TO sqladmin; GRANT ALL PRIVILEGES ON ALL FOREIGN SERVERS TO sqladmin; GRANT ALL PRIVILEGES ON ALL EXTENSION TO sqladmin; GRANT ALL PRIVILEGES ON ALL SCHEMA TO sqladmin; GRANT ALL PRIVILEGES ON ALL TABLES TO sqladmin; GRANT ALL PRIVILEGES ON ALL SEQUENCES TO sqladmin; GRANT ALL PRIVILEGES ON ALL FUNCTIONS TO sqladmin; GRANT ALL PRIVILEGES ON ALL ROUTINES TO sqladmin; GRANT ALL PRIVILEGES ON ALL TYPES TO sqladmin; GRANT ALL PRIVILEGES ON ALL SEQUENCES TO sqladmin; GRANT ALL PRIVILEGES ON ALL TABLESPACES TO sqladmin; GRANT ALL PRIVILEGES ON ALL FOREIGN SERVERS TO sqladmin; GRANT ALL PRIVILEGES ON ALL EXTENSION TO sqladmin; GRANT ALL PRIVILEGES ON ALL SCHEMA TO sqladmin; GRANT ALL PRIVILEGES ON ALL TABLES TO sqladmin; GRANT ALL PRIVILEGES ON ALL SEQUENCES TO sqladmin; GRANT ALL PRIVILEGES ON ALL FUNCTIONS TO sqladmin; GRANT ALL PRIVILEGES ON ALL ROUTINES TO sqladmin; GRANT ALL PRIVILEGES ON ALL TYPES TO sqladmin; GRANT ALL PRIVILEGES ON ALL SEQUENCES TO sqladmin; GRANT ALL PRIVILEGES ON ALL TABLESPACES TO sqladmin; GRANT ALL PRIVILEGES ON ALL FOREIGN SERVERS TO sqladmin; GRANT ALL PRIVILEGES ON ALL EXTENSION TO sqladmin; GRANT ALL PRIVILEGES ON ALL SCHEMA TO sqladmin; GRANT ALL PRIVILEGES ON ALL TABLES TO sqladmin; GRANT ALL PRIVILEGES ON ALL SEQUENCES TO sqladmin; GRANT ALL PRIVILEGES ON ALL FUNCTIONS TO sqladmin; GRANT ALL PRIVILEGES ON ALL ROUTINES TO sqladmin; GRANT ALL PRIVILEGES ON ALL TYPES TO sqladmin; GRANT ALL PRIVILEGES ON ALL SEQUENCES TO sqladmin; GRANT ALL PRIVILEGES ON ALL TABLESPACES TO sqladmin; GRANT ALL PRIVILEGES ON ALL FOREIGN SERVERS TO sqladmin; GRANT ALL PRIVILEGES ON ALL EXTENSION TO sqladmin; GRANT ALL PRIVILEGES ON ALL SCHEMA TO sqladmin; GRANT ALL PRIVILEGES ON ALL TABLES TO sqladmin; GRANT ALL PRIVILEGES ON ALL SEQUENCES TO sqladmin; GRANT ALL PRIVILEGES ON ALL FUNCTIONS TO sqladmin; GRANT ALL PRIVILEGES ON ALL ROUTINES TO sqladmin; GRANT ALL PRIVILEGES ON ALL TYPES TO sqladmin; GRANT ALL PRIVILEGES ON ALL SEQUENCES TO sqladmin; GRANT ALL PRIVILEGES ON ALL TABLESPACES TO sqladmin; GRANT ALL PRIVILEGES ON ALL FOREIGN SERVERS TO sqladmin; GRANT ALL PRIVILEGES ON ALL EXTENSION TO sqladmin; GRANT ALL PRIVILEGES ON ALL SCHEMA TO sqladmin; GRANT ALL PRIVILEGES ON ALL TABLES TO sqladmin; GRANT ALL PRIVILEGES ON ALL SEQUENCES TO sqladmin; GRANT ALL PRIVILEGES ON ALL FUNCTIONS TO sqladmin; GRANT ALL PRIVILEGES ON ALL ROUTINES TO sqladmin; GRANT ALL PRIVILEGES ON ALL TYPES TO sqladmin; GRANT ALL PRIVILEGES ON ALL SEQUENCES TO sqladmin; GRANT ALL PRIVILEGES ON ALL TABLESPACES TO sqladmin; GRANT ALL PRIVILEGES ON ALL FOREIGN SERVERS TO sqladmin; GRANT ALL PRIVILEGES ON ALL EXTENSION TO sqladmin; GRANT ALL PRIVILEGES ON ALL SCHEMA TO sqladmin; GRANT ALL PRIVILEGES ON ALL TABLES TO sqladmin; GRANT ALL PRIVILEGES ON ALL SEQUENCES TO sqladmin; GRANT ALL PRIVILEGES ON ALL FUNCTIONS TO sqladmin; GRANT ALL PRIVILEGES ON ALL ROUTINES TO sqladmin; GRANT ALL PRIVILEGES ON ALL TYPES TO sqladmin; GRANT ALL PRIVILEGES ON ALL SEQUENCES TO sqladmin; GRANT ALL PRIVILEGES ON ALL TABLESPACES TO sqladmin; GRANT ALL PRIVILEGES ON ALL FOREIGN SERVERS TO sqladmin; GRANT ALL PRIVILEGES ON ALL EXTENSION TO sqladmin; GRANT ALL PRIVILEGES ON ALL SCHEMA TO sqladmin; GRANT ALL PRIVILEGES ON ALL TABLES TO sqladmin; GRANT ALL PRIVILEGES ON ALL SEQUENCES TO sqladmin; GRANT ALL PRIVILEGES ON ALL FUNCTIONS TO sqladmin; GRANT ALL PRIVILEGES ON ALL ROUTINES TO sqladmin; GRANT ALL PRIVILEGES ON ALL TYPES TO sqladmin; GRANT ALL PRIVILEGES ON ALL SEQUENCES TO sqladmin; GRANT ALL PRIVILEGES ON ALL TABLESPACES TO sqladmin; GRANT ALL PRIVILEGES ON ALL FOREIGN SERVERS TO sqladmin; GRANT ALL PRIVILEGES ON ALL EXTENSION TO sqladmin; GRANT ALL PRIVILEGES ON ALL SCHEMA TO sqladmin; GRANT ALL PRIVILEGES ON ALL TABLES TO sqladmin; GRANT ALL PRIVILEGES ON ALL SEQUENCES TO sqladmin; GRANT ALL PRIVILEGES ON ALL FUNCTIONS TO sqladmin; GRANT ALL PRIVILEGES ON ALL ROUTINES TO sqladmin; GRANT ALL PRIVILEGES ON ALL TYPES TO sqladmin; GRANT ALL PRIVILEGES ON ALL SEQUENCES TO sqladmin; GRANT ALL PRIVILEGES ON ALL TABLESPACES TO sqladmin; GRANT ALL PRIVILEGES ON ALL FOREIGN SERVERS TO sqladmin; GRANT ALL PRIVILEGES ON ALL EXTENSION TO sqladmin; GRANT ALL PRIVILEGES ON ALL SCHEMA TO sqladmin; GRANT ALL PRIVILEGES ON ALL TABLES TO sqladmin; GRANT ALL PRIVILEGES ON ALL SEQUENCES TO sqladmin; GRANT ALL PRIVILEGES ON ALL FUNCTIONS TO sqladmin; GRANT ALL PRIVILEGES ON ALL ROUTINES TO sqladmin; GRANT ALL PRIVILEGES ON ALL TYPES TO sqladmin; GRANT ALL PRIVILEGES ON ALL SEQUENCES TO sqladmin; GRANT ALL PRIVILEGES ON ALL TABLESPACES TO sqladmin; GRANT ALL PRIVILEGES ON ALL FOREIGN SERVERS TO sqladmin; GRANT ALL PRIVILEGES ON ALL EXTENSION TO sqladmin; GRANT ALL PRIVILEGES ON ALL SCHEMA TO sqladmin; GRANT ALL PRIVILEGES ON ALL TABLES TO sqladmin; GRANT ALL PRIVILEGES ON ALL SEQUENCES TO sqladmin; GRANT ALL PRIVILEGES ON ALL FUNCTIONS TO sqladmin; GRANT ALL PRIVILEGES ON ALL ROUTINES TO sqladmin; GRANT ALL PRIVILEGES ON ALL TYPES TO sqladmin; GRANT ALL PRIVILEGES ON ALL SEQUENCES TO sqladmin; GRANT ALL PRIVILEGES ON ALL TABLESPACES TO sqladmin; GRANT ALL PRIVILEGES ON ALL FOREIGN SERVERS TO sqladmin; GRANT ALL PRIVILEGES ON ALL EXTENSION TO sqladmin; GRANT ALL PRIVILEGES ON ALL SCHEMA TO sqladmin; GRANT ALL PRIVILEGES ON ALL TABLES TO sqladmin; GRANT ALL PRIVILEGES ON ALL SEQUENCES TO sqladmin; GRANT ALL PRIVILEGES ON ALL FUNCTIONS TO sqladmin; GRANT ALL PRIVILEGES ON ALL ROUTINES TO sqladmin; GRANT ALL PRIVILEGES ON ALL TYPES TO sqladmin; GRANT ALL PRIVILEGES ON ALL SEQUENCES TO sqladmin; GRANT ALL PRIVILEGES ON ALL TABLESPACES TO sqladmin; GRANT ALL PRIVILEGES ON ALL FOREIGN SERVERS TO sqladmin; GRANT ALL PRIVILEGES ON ALL EXTENSION TO sqladmin; GRANT ALL PRIVILEGES ON ALL SCHEMA TO sqladmin; GRANT ALL PRIVILEGES ON ALL TABLES TO sqladmin; GRANT ALL PRIVILEGES ON ALL SEQUENCES TO sqladmin; GRANT ALL PRIVILEGES ON ALL FUNCTIONS TO sqladmin; GRANT ALL PRIVILEGES ON ALL ROUTINES TO sqladmin; GRANT ALL PRIVILEGES ON ALL TYPES TO sqladmin; GRANT ALL PRIVILEGES ON ALL SEQUENCES TO sqladmin; GRANT ALL PRIVILEGES ON ALL TABLESPACES TO sqladmin; GRANT ALL PRIVILEGES ON ALL FOREIGN SERVERS TO sqladmin; GRANT ALL PRIVILEGES ON ALL EXTENSION TO sqladmin; GRANT ALL PRIVILEGES ON ALL SCHEMA TO sqladmin; GRANT ALL PRIVILEGES ON ALL TABLES TO sqladmin; GRANT ALL PRIVILEGES ON ALL SEQUENCES TO sqladmin; GRANT ALL PRIVILEGES ON ALL FUNCTIONS TO sqladmin; GRANT ALL PRIVILEGES ON ALL ROUTINES TO sqladmin; GRANT ALL PRIVILEGES ON ALL TYPES TO sqladmin; GRANT ALL PRIVILEGES ON ALL SEQUENCES TO sqladmin; GRANT ALL PRIVILEGES ON ALL TABLESPACES TO sqladmin; GRANT ALL PRIVILEGES ON ALL FOREIGN SERVERS TO sqladmin; GRANT ALL PRIVILEGES ON ALL EXTENSION TO sqladmin; GRANT ALL PRIVILEGES ON ALL SCHEMA TO sqladmin; GRANT ALL PRIVILEGES ON ALL TABLES TO sqladmin; GRANT ALL PRIVILEGES ON ALL SEQUENCES TO sqladmin; GRANT ALL PRIVILEGES ON ALL FUNCTIONS TO sqladmin; GRANT ALL PRIVILEGES ON ALL ROUTINES TO sqladmin; GRANT ALL PRIVILEGES ON ALL TYPES TO sqladmin; GRANT ALL PRIVILEGES ON ALL SEQUENCES TO sqladmin; GRANT ALL PRIVILEGES ON ALL TABLESPACES TO sqladmin; GRANT ALL PRIVILEGES ON ALL FOREIGN SERVERS TO sqladmin; GRANT ALL PRIVILEGES ON ALL EXTENSION TO sqladmin; GRANT ALL PRIVILEGES ON ALL SCHEMA TO sqladmin; GRANT ALL PRIVILEGES ON ALL TABLES TO sqladmin; GRANT ALL PRIVILEGES ON ALL SEQUENCES TO sqladmin; GRANT ALL PRIVILEGES ON ALL FUNCTIONS TO sqladmin; GRANT ALL PRIVILEGES ON ALL ROUTINES TO sqladmin; GRANT ALL PRIVILEGES ON ALL TYPES TO sqladmin; GRANT ALL PRIVILEGES ON ALL SEQUENCES TO sqladmin; GRANT ALL PRIVILEGES ON ALL TABLESPACES TO sqladmin; GRANT ALL PRIVILEGES ON ALL FOREIGN SERVERS TO sqladmin; GRANT ALL PRIVILEGES ON ALL EXTENSION TO sqladmin; GRANT ALL PRIVILEGES ON ALL SCHEMA TO sqladmin; GRANT ALL PRIVILEGES ON ALL TABLES TO sqladmin; GRANT ALL PRIVILEGES ON ALL SEQUENCES TO sqladmin; GRANT ALL PRIVILEGES ON ALL FUNCTIONS TO sqladmin; GRANT ALL PRIVILEGES ON ALL ROUTINES TO sqladmin; GRANT ALL PRIVILEGES ON ALL TYPES TO sqladmin; GRANT ALL PRIVILEGES ON ALL SEQUENCES TO sqladmin; GRANT ALL PRIVILEGES ON ALL TABLESPACES TO sqladmin; GRANT ALL PRIVILEGES ON ALL FOREIGN SERVERS TO sqladmin; GRANT ALL PRIVILEGES ON ALL EXTENSION TO sqladmin; GRANT ALL PRIVILEGES ON ALL SCHEMA TO sqladmin; GRANT ALL PRIVILEGES ON ALL TABLES TO sqladmin; GRANT ALL PRIVILEGES ON ALL SEQUENCES TO sqladmin; GRANT ALL PRIVILEGES ON ALL FUNCTIONS TO sqladmin; GRANT ALL PRIVILEGES ON ALL ROUTINES TO sqladmin; GRANT ALL PRIVILEGES ON ALL TYPES TO sqladmin; GRANT ALL PRIVILEGES ON ALL SEQUENCES TO sqladmin; GRANT ALL PRIVILEGES ON ALL TABLESPACES TO sqladmin; GRANT ALL PRIVILEGES ON ALL FOREIGN SERVERS TO sqladmin; GRANT ALL PRIVILEGES ON ALL EXTENSION TO sqladmin; GRANT ALL PRIVILEGES ON ALL SCHEMA TO sqladmin; GRANT ALL PRIVILEGES ON ALL TABLES TO sqladmin; GRANT ALL PRIVILEGES ON ALL SEQUENCES TO sqladmin; GRANT ALL PRIVILEGES ON ALL FUNCTIONS TO sqladmin; GRANT ALL PRIVILEGES ON ALL ROUTINES TO sqladmin; GRANT ALL PRIVILEGES ON ALL TYPES TO sqladmin; GRANT ALL PRIVILEGES ON ALL SEQUENCES TO sqladmin; GRANT ALL PRIVILEGES ON ALL TABLESPACES TO sqladmin; GRANT ALL PRIVILEGES ON ALL FOREIGN SERVERS TO sqladmin; GRANT ALL PRIVILEGES ON ALL EXTENSION TO sqladmin; GRANT ALL PRIVILEGES ON ALL SCHEMA TO sqladmin; GRANT ALL PRIVILEGES ON ALL TABLES TO sqladmin; GRANT ALL PRIVILEGES ON ALL SEQUENCES TO sqladmin; GRANT ALL PRIVILEGES ON ALL FUNCTIONS TO sqladmin; GRANT ALL PRIVILEGES ON ALL ROUTINES TO sqladmin; GRANT ALL PRIVILEGES ON ALL TYPES TO sqladmin; GRANT ALL PRIVILEGES ON ALL SEQUENCES TO sqladmin; GRANT ALL PRIVILEGES ON ALL TABLESPACES TO sqladmin; GRANT ALL PRIVILEGES ON ALL FOREIGN SERVERS TO sqladmin; GRANT ALL PRIVILEGES ON ALL EXTENSION TO sqladmin; GRANT ALL PRIVILEGES ON ALL SCHEMA TO sqladmin; GRANT ALL PRIVILEGES ON ALL TABLES TO sqladmin; GRANT ALL PRIVILEGES ON ALL SEQUENCES TO sqladmin; GRANT ALL PRIVILEGES ON ALL FUNCTIONS TO sqladmin; GRANT ALL PRIVILEGES ON ALL ROUTINES TO sqladmin; GRANT ALL PRIVILEGES ON ALL TYPES TO sqladmin; GRANT ALL PRIVILEGES ON ALL SEQUENCES TO sqladmin; GRANT ALL PRIVILEGES ON ALL TABLESPACES TO sqladmin; GRANT ALL PRIVILEGES ON ALL FOREIGN SERVERS TO sqladmin; GRANT ALL PRIVILEGES ON ALL EXTENSION TO sqladmin; GRANT ALL PRIVILEGES ON ALL SCHEMA TO sqladmin; GRANT ALL PRIVILEGES ON ALL TABLES TO sqladmin; GRANT ALL PRIVILEGES ON ALL SEQUENCES TO sqladmin; GRANT ALL PRIVILEGES ON ALL FUNCTIONS TO sqladmin; GRANT ALL PRIVILEGES ON ALL ROUTINES TO sqladmin; GRANT ALL PRIVILEGES ON ALL TYPES TO sqladmin; GRANT ALL PRIVILEGES ON ALL SEQUENCES TO sqladmin; GRANT ALL PRIVILEGES ON ALL TABLESPACES TO sqladmin; GRANT ALL PRIVILEGES ON ALL FOREIGN SERVERS TO sqladmin; GRANT ALL PRIVILEGES ON ALL EXTENSION TO sqladmin; GRANT ALL PRIVILEGES ON ALL SCHEMA TO sqladmin; GRANT ALL PRIVILEGES ON ALL
声明:本文内容由网友自发贡献,本站不承担相应法律责任。对本内容有异议或投诉,请联系2913721942#qq.com核实处理,我们将尽快回复您,谢谢合作!
若转载请注明出处: centos sqladmin权限怎么设置
本文地址: https://pptw.com/jishu/734330.html
