创建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; }

Konsole 和 oh-my-zsh 的配置与使用 修改Konsole默认字体大小点击设置->配置当前方案->外观->自体调整为Hack 16pt修改Konsole快捷键点击设置->配置键盘快捷键复制快捷键由 Ctrl+Shift+C 调整为 Ctrl+C粘贴快捷键由 Ctrl+Shift+V 调整为 Ctrl+V关闭会话快捷键由 Ctrl+Shift+W 调整为 Ctrl+W新建标签页快捷键由 Ctrl+Shift+T 调整为 Ctrl+T安装zshsudo apt-get install zsh cat /etc/shellszsh设为默认shellchsh -s /bin/zsh安装oh-my-zshsh -c "$(curl -fsSL https://raw.github.com/ohmyzsh/ohmyzsh/master/tools/install.sh)"修改Kconsole的默认命令为/bin/zsh调整主题配置 juanghurtado修改光标为$vim ~/.oh-my-zsh/themes/juanghurtado.zsh-theme安装高亮插件 zsh-syntax-highlightinggit clone https://github.com/zsh-users/zsh-syntax-highlighting.git ${ZSH_CUSTOM:-~/.oh-my-zsh/custom}/plugins/zsh-syntax-highlighting编辑配置文件 vim ~/.zshrcsource ~/.zshrc