正式环境网站目录权限 指定用户跟用户组chown -R www.www /data/code/配置文件夹权限find /data/code/ -type d -exec chmod 755 {} \;配置文件权限find /data/code/ -type f -exec chmod 644 {} \;

创建postgres帐号 切换postgres用户sudo -i -u postgres进入Postgres数据库psql创建root帐号create user root with login password '123456';将root帐号提升为超级帐号ALTER USER root WITH SUPERUSER;

MySql 导入sql数据 去到sql文件所在的目录cd /media/jypony/Data/kubuntu/bak/mysql_database输入账号密码mysql -uroot -p123456 create databse xxx;导入sqlsource xxx.sql

MySql8.0配置普通用户登陆root帐号 查看debian-sys-maint用户信息cat /etc/mysql/debian.cnf使用debian-sys-maint用户登录MySQL ，密码为debian.cnf中的密码mysql -u debian-sys-maint -p删除原来的Root/普通用户use mysql; delete from user where user = 'root';新建Root/普通用户create user 'root'@'%' identified by '123456';权限授予grant all privileges on *.* to 'root'@'%' with grant option;刷新权限flush privileges;使用Root/普通用户登录exit; mysql -uroot -p123456报错处理出现The server requested authentication method unknown to the client的话,修改密码连接方式ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY '123456'; flush privileges;

配置jsonview插件 google 配置jsonview插件body { white-space: pre; font-family: "Times New Roman",Georgia,Serif; font-size: 20px; background-color: #1E2822; color: #FFF; } .property { color: #8EFF2B; } .type-null { color: gray; } .type-boolean { color: firebrick; } .type-number { color: red; } .type-string { color: #E6DB74; } .callback-function { color: gray; } .collapser:after { content: "--"; color: #FFF; } .collapsed > .collapser:after { content: "+"; color: #FFF; } .ellipsis:after { content: " … "; color: #FFF; } .collapsible { margin-left: 1em; color: #FFF; } .hoverable { padding-top: 1px; padding-bottom: 1px; padding-left: 2px; padding-right: 2px; border-radius: 2px; } .hovered { background-color: rgba(200, 200, 255, 0.3); } .collapser { padding-right: 6px; padding-left: 6px; }